Modifying Worksheet Views

[ LiB ]

When working with a larger worksheet, it can become difficult to see the entire worksheet on the screen. As you scroll down or across the worksheet, you may lose track of which column or row of data you are entering. Excel contains several tools to help you view your worksheet from different perspectives.

Hiding Rows and Columns

If you have rows or columns you don't really need to see, or that you don't want to print, you can hide them from view. Hiding them doesn't delete them or make their data inaccessible; it only keeps them out of view. When you hide rows or columns, Excel is actually changing the row height or column width to zero.


graphic/09fig01.gif


NOTE

You can hide multiple columns at one time or multiple rows at one time, but do not try to hide both columns and rows in a single step.


graphic/09fig02.gif



graphic/09fig03.gif



graphic/09fig04.gif


If you need to see the hidden rows or columns, you can easily make them redisplay in the worksheet.


graphic/09fig05.gif


NOTE

Optionally, right-click over a selected column or row and choose Unhide.


graphic/09fig06.gif


Splitting a Window

Sometimes you need to see two or more different sections of your worksheet at the same time, but your worksheet is too large to view both sections. Excel includes a feature which allows you to split a window into four sections which you can move independently of each other.


graphic/09fig07.gif



graphic/09fig08.gif



graphic/09fig09.gif


When you are finished working in the split view, you can easily return the worksheet to a single panel.


graphic/09fig10.gif


Freezing Panes

When working with a long or wide list, as you add more data, you might lose track of which column or row you are entering data into. It would be helpful if you could see which column or row label you are working with. You can freeze the column headings and row labels so they remain visible no matter where you are working in your worksheet.


graphic/09fig11.gif



graphic/09fig12.gif


NOTE

Typically, when you press the Home key, Excel takes you to cell A1, but when you have the Freeze Panes feature active, Excel will take you to the cell just below and to the left of the frozen headings.

You can easily remove the freeze from row and column headings.


graphic/09fig13.gif


Using Zoom

The Zoom feature enlarges or shrinks the display of your worksheet to allow you to see more or less of it. Excel can zoom your worksheet in percentages, with the normal display of your worksheet being 100%. Zooming in or out does not affect printing.


graphic/09fig14.gif


NOTE

Optionally, type your own magnification percentage.


graphic/09fig15.gif


To reset the display to normal, change the zoom to 100%.

[ LiB ]


Microsoft Office Excel 2003 Fast & Easy
Windows XP Registry: A Complete Guide to Customizing and Optimizing Windows XP (Information Technologies Master Series)
ISBN: N/A
EAN: 2147483647
Year: 2002
Pages: 157
Authors: Olga Kokoreva

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net