COMPUTER TIPS & TRICKS
from STERLING DAVIS

EXCEL

Page 2

Get more mileage from Excel 2013 with these five free apps
From mapping to specialized charting to invoice generation, these apps provide extra features within Excel 2013
Read more

Reduce start up tasks by customizing the way Excel launches
Reduce tedious and repetitive start up chores by customizing the way Excel launches.
Read more

Sometimes you may  need to see two worksheets in the same workbook side by side. I have actually had folks write to me asking how they can do this.  I tell them, relax – it isn’t all that difficult.

Follow the steps below to learn how:

1. Open the your first worksheet.

2. On the View tab of your Ribbon, click New Window.

3. If your workbook is in full screen mode, you might not notice that anything has happened, but if you take a peek at your title bar, you will see that your workbook title now has a :2 after it.

4. On the View tab, click Arrange All and click either Vertical or Horizontal.

5. In the second window, click the second worksheet tab that you would like to view. You can now see both your worksheets of the same workbook side by side.

To return to a single window, click the Close window icon, which is the white X int he top right corner of your Excel screen.

Tired of arranging your sheets in the same way every time you open a workbook in Microsoft Excel?  Save a view instead and save some time.

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.

Once you have your sheet split or multiple sheets open and arranged, do the following in Excel 2007 or 2010 to save the view:

1. Click the View tab.
2. Choose Save Workspace in the Window group.
3. 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.

The next time you open this workbook, open the XLW version instead of the XLSX version. Excel will open the same workbook with all the sheets intact, but it’ll open to the view you work with the most.

Excel 2003 has a similar feature, but it’s not quite as efficient - you save a custom view and then select it after opening the workbook:

1. From the View menu, choose Custom Views.
2. Click Add and enter a name for the custom view.
3. Click OK.

When you open the workbook, choose Custom Views from the View menu, select the view and click Show. It’s a bit more work, but still effective. You could use the workbook’s Open even to set the view for you.

MUCH MORE TO COME .....