Lesson 1, Topic 1
In Progress

1.7. Enlarge and make the view of the spreadsheet smaller

ryanrori February 3, 2021

[responsivevoice_button rate=”0.9″ voice=”UK English Female” buttontext=”Listen to Post”]

To enlarge and make the view of the spreadsheet smaller, you will use the Zoom function in Excel. You can zoom in to get a close-up view of your file or zoom out to see more of the page at a reduced size. You can also save a particular zoom setting with a document or template, presentation, or worksheet.

Do one of the following:

  1. On the View tab, in the Zoom group, click Zoom 100%.
Excel Ribbon Image
  1. On the View tab, in the Zoom group, click Zoom to Selection.
  2. On the View tab, in the Zoom group, click Zoom, and then enter a percentage or choose any other settings that you want.

Quickly zoom in or out of a document, presentation, or worksheet

  1. On the status bar, click the Zoom slider

Zoom slider.

  1. Slide to the percentage zoom setting that you want.

Save a zoom setting in Excel

  1. Open the worksheet that you want to save with a particular zoom setting.
  2. On the View tab, in the Zoom group, click Zoom.
  1. Choose the setting that you want.
  2. Click the File button, and then click Save.

Change the way that the spreadsheet is viewed

You can change the way that the spreadsheet is viewed. You can also use a custom view to save specific display settings and print settings (such as page settings, margins, headers and footers, and sheet settings) for a worksheet so that you can quickly apply these settings to that worksheet when needed. You can also include a specific print area in a custom view.

You can create multiple custom views per worksheet, but you can only apply a custom view to the worksheet that was active when you created the custom view. If you no longer need a custom view, you can delete it.

Create a custom view

  1. On a worksheet, change the display and print settings that you want to save in a custom view.
  1. On the View tab, in the Workbook Views group, click Custom Views.
  1. Click Add.
  2. In the Name box, type a name for the view.

To make a view easier to identify, you can include the name of the active worksheet in the name of a view.

  1. Under Include in view, select the check boxes of the settings that you want to include.
  • All the views that you add to the workbook appear under Views in the Custom Views dialogue box. When you select a view in the list, and then click Show, the worksheet that was active when you created the view will be displayed.
  • If any worksheet in the workbook contains an Excel table, the Custom Views command will not be available anywhere in the workbook.

Apply a custom view

  1. On the View tab, in the Workbook Views group, click Custom Views.
  1. In the Views box, click the name of the view that you want to apply, and then click Show.

 The worksheet that was active when you created the custom view is automatically displayed.

Delete a custom view

  1. On the View tab, in the Workbook Views group, click Custom Views.
  1. In the Views box, click the name of the view that you want to delete, and then click Delete.