Useful Inconsistencies of New Windows

When you create multiple windows of the same Microsoft Office 2007 workbook, anything you do in one window happens in all windows—almost. New entries; formatting changes; inserted or deleted rows, columns, or sheets; and just about any other editing changes are reflected in all windows. Display characteristics—or views—are not. This enables you to zoom in or out and change anything on the View tab of the Tools, Options dialog box and almost anything on the View menu.

In Pacific Sales.xls:1, formulas are displayed, the sheet is zoomed in, and scroll bars, row and column headings, and gridlines are removed—all in an effort to review the formulas in the Summary sheet to make sure they refer to the proper cells. You can also use this technique to audit your worksheets.

If you create a view like Pacific Sales.xls:1  and you want to be able to re-create it in the future, choose View, Custom View to save it. If you want to be able to re-create the entire workspace, including additional windows and their view settings, use the File, Save Workspace command.