Knowledgebase: Microsoft Excel
Zooming In Excel.
Posted by - NA - on 01 April 2006 05:44 AM
Solution:
When you need to get a closer look at a portion of your Excel worksheet, you can simply zoom in on it. Let's suppose that you need to have a close look at a range of cells from A1 through D8. Select the range and choose View/Zoom. When the Zoom dialog box opens, select the radio button labeled 'Fit selection,' and then click OK. The selection will now occupy the entire Excel window. To get back to the normal view, choose View/Zoom and, in the Zoom dialog box, select the '100%' radio button and click OK.
Did you know that you can zoom in on a range and have Excel choose just the right amount of zoom for your selection? Try this: enter some numbers into cells D5 through D9. Now, select the cells and choose View/Zoom. When the Zoom dialog box opens, select the 'Fit selection' radio button and click OK.

After you finish with the zoomed in view, you can simply press Ctrl + Z to undo the zoom. However, this won't work if you made any changes while in the zoomed view--the changes will get undone. In this case, choose View/Zoom again. When the Zoom dialog box opens, select the "100%" radio button and click OK.

(136 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Software by Kayako Fusion