If you work with a split sheet or a couple of sheets open in different windows, you're going to like this tip. You can save your view. Then, when you open the workbook, Excel will open it to the saved view. You won't have to spend the first few minutes putting everything in order - it'll be just the way you want it when you open the workbook.
- Click the View tab.
- Choose Save Workspace in the Window group.
- Save the view as an XLW file - that will be the default, so you won't have to change the file type. Just give the file a name that you recognize, and click Save.
- From the View menu, choose Custom Views.
- Click Add and enter a name for the custom view.
- Click OK.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.