Zooming

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

Zooming

Introduction

Zooming the work area consists of increasing the ratio of characters or the contents of the worksheet. Although it does not affect the actual display of the characters sizes or cells contents, zooming can make the worksheet a little easier to read.

The Zoom Area

To zoom a worksheet, you have various options:

  • Under the horizontal scroll bar is a long bar called Zoom. This allows you to increase or decrease the viewed items of the main area of Microsoft Excel
  • To change the zoom setting, you can click the Zoom button and scroll left or right until you get the desired view

Zoom With Precision

Microsoft Excel provides a special dialog box that you can use to select the zooming magnification. To access it:

  • On the the Ribbon, click View. In the Zoom section, click the Zoom button
  • On the Status bar, click the button that shows the zooming value

This would open the Zoom dialog box. From there, you can click one of the radio buttons to select a zooming ratio. To be more precise, you can click the Custom radio button, then click its text box, type a number, and click OK.

 Practical Learning: Control The Interface’s Zoom Settings

  1. In the worksheet, select cells B8:F21
  2. On the Ribbon, click View
  3. In the Zoom section, click Zoom to Selection. Notice that the worksheet displays large characters now
     
  4. In the Zoom section of the Ribbon, click 100%
  5. In the lower-right section of the Microsoft Excel, click the spin button and move it to the right until its value displays 274%
     
    Zoom
  6. Still in the lower-right section of the Microsoft Excel, click the spin button and move it to the middle mark 100%
  7. In the Zoom section of the Ribbon, click the Zoom
  8. In the Zoom dialog box, click the text box right to Custom, delete its content and type 68
      
    Zoom
  9. In the Zoom section of the Ribbon, click 100%