Excel worksheet zoom in or out

Source: Internet
Author: User
Tags range

When more information is added to the worksheet, navigating and positioning the desired content becomes more difficult. Excel contains some options that you can use to view a table, sometimes more efficiently for multiple tables. This section describes some additional worksheet options that you can control at your own discretion.

Enlarge or shrink tables to get the best view

Typically, everything you see on the screen is displayed in a 100% ratio, but can be changed from 10 (very small) to 400 (great). Using a small scaling percentage helps you see how the worksheet is designed from a global perspective. If the displayed content is not fully Van Youne in the field of view, then narrowing is useful. Zooming in is extremely useful if you have difficulty recognizing smaller font types. Scaling does not change the font size, so it has no effect on the print output

Cross-reference: for changing the size of the print discovery, Excel includes a separate option (using the page layout in the Ribbon). The controls in the Fit Size group).

Figure 14-5 shows a window that shrinks to 10% and a window that enlarges to 400.

Figure 14-5 can be small or enlarged for better viewing of worksheets

Use the zoom slider at the right end of the status bar to easily change the magnification of the active worksheet, drag the slider, and immediately transform the screen.

Another way to zoom is to select View. Zoom-Zoom, which displays a dialog box.

Select View-Zoom. Zoom to selection scales the worksheet to show only selected cells (more useful when you want to view only 1 specific areas).

Tip: Scaling affects only the active worksheet, so you can use different zoom multiples for different worksheets. In addition, if you have a worksheet that appears in two different windows, you can set a different zoom multiplier for each window.

Cross-Reference: If the worksheet uses a named district, narrowing the worksheet to 39 intestines or smaller displays the name of the range on the cell. Viewing a named range this way is useful for viewing a worksheet from a global perspective.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.