• Skip to main content
  • Skip to primary sidebar
  • Skip to secondary sidebar
  • Skip to footer

Computer Notes

Library
    • Computer Fundamental
    • Computer Memory
    • DBMS Tutorial
    • Operating System
    • Computer Networking
    • C Programming
    • C++ Programming
    • Java Programming
    • C# Programming
    • SQL Tutorial
    • Management Tutorial
    • Computer Graphics
    • Compiler Design
    • Style Sheet
    • JavaScript Tutorial
    • Html Tutorial
    • Wordpress Tutorial
    • Python Tutorial
    • PHP Tutorial
    • JSP Tutorial
    • AngularJS Tutorial
    • Data Structures
    • E Commerce Tutorial
    • Visual Basic
    • Structs2 Tutorial
    • Digital Electronics
    • Internet Terms
    • Servlet Tutorial
    • Software Engineering
    • Interviews Questions
    • Basic Terms
    • Troubleshooting
Menu

Header Right

Home » Excel » Zoom IN/OUT in Excel 2010
Next →
← Prev

Zoom IN/OUT in Excel 2010

By Dinesh Thakur

The data in the table is perceived differently depending on the display scale of the stage (that is, the area of ​​cells). The ribbon version of Excel provides a very convenient way to set the desired scale: there is a special bar with a slider for selecting the display scale in the status bar. A functional text field (scale indicator) is placed next to the strip, displaying the display scale set by the user (by default, the value is 100%). The scale setting bar is shown in Fig below.

Zoom Slider in Excel 2010

By moving the slider, select an acceptable scale for displaying data. In addition to dragging the slider directly, you can click on the icons with the plus and minus signs. In this case, for each click, the scale is respectively increased and decreased discretely in 10% steps. The figure below shows the working window of the Excel application in the mode of displaying data in cells with a scale of 50%.

Display scale is set 50%

Display scale is set 160%For comparison, the above figure shows the application window when the display scale is 160%.

Moreover, the above situations are not borderline. You can adjust the zoom percentage from 10% (tiny) to 400 percent (huge). Zooming does not adjust the font size, so it has no impact on the print quality. The window at the most significant display scale is shown in the figure below.

Display scale is set 400%

Usually, the large scale mode is used when entering or editing formulas. Small scales are helpful when the document contains a large amount of data, and there is a need to view and evaluate the document as a whole.

The described method of changing the scale is far from the only one. In particular, if you click on the field indicating the scale, which is located to the left of the scale setting bar, the dialog box for selecting the scale Scale will open.

Scale selection window

The window contains a switch for several positions with predefined scales. Besides, if you set the switch to the selection position, the scale will be adjusted so that the previously selected area is fully displayed in the window. In fig. illustrates the result of performing the following actions: at a scale of 400%, the range of cells A1: F16 is selected, after which a mouse click is made on the scale value field and in the dialog.

In the Scale window, the switch is set to the selection position. Finally, if the radio button in the dialogue is Scale is set to arbitrary. The user can enter a value for the scale of data display by himself.

It should also be borne in mind that different scales can be set for different sheets in the same workbook. In other words, zoom changes are valid within the worksheet in which they were made.

The scale is chosen so to fully display the selected area

In the tab File item selected Options

The scale indicator and the scale selection slider are displayed by default. To change these settings, right-click in the status bar (the lowest bar of the application working window) and in the context menu that opens, set/deselect the options Scale (show / hide the scale indicator) and Scale slider (show / hide the selection slider scale). These settings apply to all worksheets and workbooks.

Another possibility of changing the scale of the data display is connected with changes in the system settings. In particular, on the File tab, select the Parameters item.

It will open the Excel Options dialog box. In this window, go to the Additional section and in the Editing options section, check the Pan with IntelliMouse option.

After that, the application switches to a mode in which the scrolling of the mouse wheel will correspond to the change in the scale of data display in the working window. Perhaps this is the fastest and most convenient way to change the scale of data display. However, it should be remembered that in this mode, you will not be able to scroll through documents using the mouse wheel – you have to pay for comfort. Moreover, the mode applies not only to all worksheets but also to worksheets. Which mode is more convenient is for the user to decide.

Option checkbox checked Panning with Intelli MouseZoom In

By moving the slider to the right, you can zoom in on the workbook. It will alter the workbook’s only view. You will zoom in to a limit of 400 percent. Take a look at the image below.

Zoom inZoom Out    

By moving the slider to the left, you can zoom out the workbook. It will alter the workbook’s only view. You can only zoom in to a limit of 10%. Take a look at the image below.

Zoom Out in Excel 2010

You’ll also like:

  1. Working with Excel 2010
  2. Excel 2010 Components
  3. Name field in Excel 2010
  4. Paginated View in Excel 2010
  5. Formatting Worksheets in Excel 2010
Next →
← Prev
Like/Subscribe us for latest updates     

About Dinesh Thakur
Dinesh ThakurDinesh Thakur holds an B.C.A, MCDBA, MCSD certifications. Dinesh authors the hugely popular Computer Notes blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps.

Dinesh Thakur is a Freelance Writer who helps different clients from all over the globe. Dinesh has written over 500+ blogs, 30+ eBooks, and 10000+ Posts for all types of clients.


For any type of query or something that you think is missing, please feel free to Contact us.


Primary Sidebar

Excel 2010

Excel 2010 Tutorials

  • Excel - Started
  • Excel - Tour
  • Excel - BackStage View
  • Excel - Entering Values
  • Excel - Navigating Workbook
  • Excel - Save Workbook
  • Excel - Open/Close Worksheet
  • Excel - Managing Worksheet
  • Excel - Managing Data
  • Excel - Rows & Columns
  • Excel - Copy & Paste
  • Excel - Find & Replace
  • Excel - Spell Checker
  • Excel - Zoom In/Out
  • Excel - Paginated View
  • Excel - Insert Comments
  • Excel - Insert Text Box
  • Excel - Undo/Redo
  • Excel - Formatting Cells
  • Excel - Formatting Worksheets
  • Excel - Working with Formula
  • Excel - Quick Access Toolbar
  • Excel - Name Field
  • Excel - Formula Bar
  • Excel - Status Bar
  • Excel - Full Screen Mode
  • Excel - Grid and Indexing Fields
  • Excel - Preferences Window
  • Excel - Color Scheme

Ribbon Tab

  • Excel - Ribbon Tabs
  • Excel - Show and Hide Ribbon
  • Excel - Adding Ribbon Groups
  • Excel - Active Label of Ribbon Group
  • Excel - Customizing the Ribbon
  • Excel - Contextual Ribbon Tabs

Other Links

  • Excel - PDF Version

Footer

Basic Course

  • Computer Fundamental
  • Computer Networking
  • Operating System
  • Database System
  • Computer Graphics
  • Management System
  • Software Engineering
  • Digital Electronics
  • Electronic Commerce
  • Compiler Design
  • Troubleshooting

Programming

  • Java Programming
  • Structured Query (SQL)
  • C Programming
  • C++ Programming
  • Visual Basic
  • Data Structures
  • Struts 2
  • Java Servlet
  • C# Programming
  • Basic Terms
  • Interviews

World Wide Web

  • Internet
  • Java Script
  • HTML Language
  • Cascading Style Sheet
  • Java Server Pages
  • Wordpress
  • PHP
  • Python Tutorial
  • AngularJS
  • Troubleshooting

 About Us |  Contact Us |  FAQ

Dinesh Thakur is a Technology Columinist and founder of Computer Notes.

Copyright © 2025. All Rights Reserved.

APPLY FOR ONLINE JOB IN BIGGEST CRYPTO COMPANIES
APPLY NOW