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

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

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

Changing the Default File Location in Excel 2007

When you first start using Microsoft Office Excel 2007, Excel wants to save files in the My Documents (Windows XP) or the Documents (Windows Vista) folder under your user name on your hard drive. So, for [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…]

How to Save an Excel 2007 Workbook

As you work in Microsoft Office Excel 2007, remember to save your work often or you risk losing your Excel data if the computer crashes or the power goes out. When you save a workbook for the first time [more…]

How to Save an Excel 2007 Workbook as a PDF File

Microsoft Office Excel 2007 lets you save your workbook files directly in the PDF (Portable Document File) file format developed by Adobe Systems Incorporated. This format enables people to open and print [more…]

Dealing with the New Excel 2007 File Formats

Office Excel 2007 supports the use of a new XML-based file format that Microsoft officially calls the Microsoft Office Open XML format. This new file format carries the filename extension [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…]

Creating a New Workbook in Excel 2007

If you’re working in Microsoft Office Excel 2007 and want to begin work in a new Excel file, you can easily create a new workbook. To do so, you can use a command on the Office menu or a keyboard shortcut [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…]

How to Use Templates in Excel 2007

Excel 2007 provides predesigned templates, worksheets for common uses. Templates contain standard or boilerplate text, but you can modify the templates to fit your needs. You can use the templates automatically [more…]

Creating Your Own Excel 2007 Templates

When you can’t find a ready-made Excel 2007 template that fits the bill, create your own templates from sample workbooks that you create or that your company has on hand. The easiest way to create your [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…]

Opening an Existing Workbook in Excel 2007

You use the Open dialog box in Office Excel 2007 to open an existing workbook. The appearance and functionality of Excel's Open dialog box differs slightly depending on whether you're running Excel 2007 [more…]

Searching for Workbooks in Excel 2007

If you want to open a workbook in Office Excel 2007, but can’t remember the filename or location, you can use the Search feature to find the missing workbook. To use Excel's Search feature, you only need [more…]

Topics