Viewing

View:

Sorted by:

Splitting an Excel 2007 Worksheet Window

In Excel 2007, you can split the worksheet window into separate panes and scroll the worksheet in each pane so that you can easily compare data from two separate worksheet locations. You can make the panes [more…]

How to Display All Formulas in an Excel 2007 Worksheet

In Excel 2007, it can be difficult to view your formulas without accidentally editing them. That’s because anytime you are in “edit” mode and the active cell has a formula, the formula might incorporate [more…]

Navigating Excel 2007's Worksheet Tabs

Each new workbook you open in Excel 2007 contains three blank worksheets, although you can add many more. You can easily move between the worksheets in an Excel workbook by using the sheet tabs, the Sheet [more…]

Freezing Panes in an Excel 2007 Worksheet

The Freeze Panes command in Excel 2007 enables you to freeze portions of a worksheet, typically column and row headings, so that you can view distant parts of the worksheet while the headings remain in [more…]

Working in Excel 2007’s Page Layout View

Excel 2007’s new Page Layout gives you an instant view of how the printed Excel page will look. You activate this view by clicking the Page Layout View button [more…]

Previewing Pages in Excel 2007 with Print Preview

Save wasted paper and your sanity by using the Print Preview feature in Excel 2007 before you print any worksheet, section of worksheet, or entire workbook. You can use Print Preview to see exactly how [more…]

Zooming into Your Excel 2007 Worksheets

You can use the Zoom slider on the Status bar in Microsoft Office Excel 2007 to increase the magnification in a worksheet or shrink it down to the tiniest size to get an overall picture of the worksheet [more…]