Managing Excel 2007 Workbooks

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 Protect an Excel 2007 Workbook

Excel 2007 includes a Protect Workbook command that prevents others from making changes to the layout of the worksheets in a workbook. You can assign a password when you protect a workbook so that only [more…]

Comparing Two Excel 2007 Worksheets Side by Side

You can use the View Side by Side command button on the View tab in Excel 2007 to quickly and easily do a side-by-side comparison of any two worksheet windows that you have open. When you click this button [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…]

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…]

How to Move or Copy Excel 2007 Worksheets to Other Workbooks

In Excel 2007, you may need to move or copy a particular worksheet from one workbook to another. You can use the Move or Copy dialog box to simplify the process. To move or copy worksheets between workbooks [more…]

Document Recovery in Excel 2007

Excel 2007 offers a document recovery feature that can help you if a computer crashes due to a power failure or some sort of operating system freeze or shutdown. Excel's AutoRecover feature saves your [more…]

Fixing Broken Formula Links in Excel 2007

Formulas in Excel 2007 can reference external workbooks. Links become broken when external workbooks are moved, deleted, or renamed. When a workbook that contains an external reference is opened but cannot [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…]

Arranging Windows in Excel 2007 Workbooks

You can open multiple workbook windows in Excel 2007 and arrange them into windows of varying displays so that you can view different parts of a worksheet from each workbook on the screen at one time. [more…]

Specifying Workbook Properties in Excel 2007

In Microsoft Office Excel 2007, you can use the new Document Information Panel to add or change workbook properties such as the Author, Title, Keywords, Status, and Comments that relate to a specific workbook [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…]

Sign Up for RSS Feeds

Computers & Software
Win $500. Easy. Enter to win now.

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.