Microsoft Office Tutorials and References
In Depth Information
Arranging Worksheet Windows
To make a hidden column or row visible, select cells on either side of the hidden column
or above and below the hidden row, click Format on the Home tab, click Hide & Unhide,
and then click Unhide Columns or Unhide Rows, as needed. If you want to unhide a single
row or column without disturbing its hidden neighbors, click in the Name box, enter a cell
address located in the hidden row or column, press Enter, and then use the Unhide Rows or
Unhide Columns option from the Hide & Unhide menu. This technique is especially useful
when the first row or column is hidden: type A1 in the Name box to jump to that location
and unhide it.
Arranging Worksheet Windows
When you’re creating a new worksheet, there’s a good chance that you’ll want to reuse
data from another worksheet, in the same workbook or in a different workbook file. The
tedious way is to click back and forth between the two maximized windows, copying,
switching windows, pasting, and repeating those steps until everything’s just right. The
faster way—assuming your PC display is big enough—is to arrange the windows next to
each other. You can then navigate through each one independently, comparing similar
sections and editing or copying data to your heart’s content.
Excel’s tools for managing worksheet windows are slightly different from those in Word
and PowerPoint. The most noteworthy difference is that individual workbook files can be
displayed side by side in a single Excel program window, sharing the ribbon, Quick Access
Toolbar, status bar, and other common interface elements.
All the controls you need are located on the View tab, in the Window group, as shown here:
If you have two or more workbooks open already and you want to rearrange them in the
current Excel program window, click Arrange All. That opens the dialog box shown here,
which gives you four options (plus a check box we’ll discuss shortly):
Search JabSto ::




Custom Search