Microsoft Office Tutorials and References
In Depth Information
Useful inconsistencies of new windows
Figure 7-6 After clicking the New Window button to open a second window for the same
workbook, select an Arrange option to it both windows on the screen simultaneously.
Note
Again, if other workbooks are open, but you want to view only the windows of the
active workbook, select the Windows Of Active Workbook check box in the Arrange
Windows dialog box.
You can view any part of the workbook in any window associated with that workbook. In
Figure 7-6, NorthwindSales.xlsx:2 originally displayed the summary worksheet when we
first created it, because that was the active worksheet when we clicked the New Window
button. Then we clicked the Brass tab in the new window, leaving the summary worksheet
visible in NorthwindSales.xlsx:1.
Useful inconsistencies of new windows
When you create multiple windows of the same workbook, anything you do in one window
happens in all windows—almost. New entries; formatting changes; inserting or deleting
rows, columns, or worksheets; and just about any other editing changes are reflected in the
windows. Display characteristics—or views —are not. This means that you can zoom in or
out and change anything in the Workbook Views and Zoom groups on the View tab as well
as use the Split and Freeze Panes commands. View adjustments affect only the active
window. You can also click the File tab, click Options, select the Advanced category, and then
Search JabSto ::




Custom Search