Excel 2007 For Dummies
Book image
Explore Book Buy On Amazon

You can use the Zoom slider on the Status bar in Microsoft Office Excel 2007 to increase the magnification in a worksheet or shrink it down to the tiniest size to get an overall picture of the worksheet data. The Zoom dialog box provides another way to change the zoom magnification.

Find the Zoom slider.

Find the Zoom slider.

The Zoom slider lives on the far right end of the Status bar, next to the View buttons.

Drag the Zoom slider to the right.

Drag the Zoom slider to the right.

Dragging the Zoom slider to the right increases the zoom — the cells appear larger and you can more easily read the worksheet data. You also can click the plus (+) button on the right end of the Zoom slider to increase the zoom level in 10% increments.

Drag the Zoom slider to the left.

Drag the Zoom slider to the left.

Dragging the Zoom slider to the left decreases the zoom. This gives you a bird’s-eye view and enables you to more clearly see the overall worksheet layout. You also can click the minus (–) button on the left end of the Zoom slider to decrease the zoom level in 10% increments.

To quickly return to 100% (normal) magnification in an Excel worksheet, all you have to do is to click the bar in the center of the Zoom slider.

Click the Zoom level button.

Click the Zoom level button.

The Zoom level button shows the current zoom percentage (the default zoom is 100%). This button appears immediately to the left of the Zoom slider. When you click this button, the Zoom dialog box appears. Click Cancel to close the dialog box without making a selection.

About This Article

This article is from the book:

About the book author:

Greg Harvey has authored tons of computer books, the most recent being Excel Workbook For Dummies and Roxio Easy Media Creator 8 For Dummies, and the most popular being Excel 2003 For Dummies and Excel 2003 All-In-One Desk Reference For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, Greg went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.
His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience: the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.
Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May. Everyone is glad that Greg was finally able to get out of school before he retired.

This article can be found in the category: