Here we go over the various options and methods for viewing and laying out your worksheets and workbooks.

In This Chapter:

Cell Comments

Cell comments are a good way of providing extra information about data contained in any cell. Comments are displayed only when the mouse is placed on the cell itself.

Navigating

You can move from one worksheet or chart sheet to another by clicking the sheet tabs at the bottom of the workbook window. There are also keyboard shortcuts you can use to move around an individual worksheet.

Viewing Parts of a Worksheet Simultaneousely

You can split a worksheet to show different parts at the same time and even make sure certain data is always visible.

Creating Custom Views

You can save a set of display and print settings as a custom view, then apply your custom view at any time. For example, you have a worksheet that contains data about four different sales regions. You can set up a view of each region's data and then save

View Multiple Sheets Simultaneously

You can arrange the document windows in Excel to let you see and work with multiple workbooks at the same time.

Change the Number of Worksheets in a New Workbook

When you create a new workbook, you have the option of specifying how many worksheets it starts with.

Splitting and Freezing Panes

You can split the view to see multiple parts of a spreadsheet and freeze some data to keep it visible no mater where you scroll the view.