How to work with different views in Microsoft Excel



You may change views in Excel relying on what you are doing and what you wish to see. Find out how on this step-by-step tutorial.

Picture: Aajan, Getty Photos/iStockphoto

You might work with Microsoft Excel principally in Regular view with the default zoom stage, which shows a restricted variety of rows and columns on the display at one level, however Excel presents quite a lot of different views that may allow you to see roughly of your spreadsheet. As an illustration:

  • You may zoom in or out to a selected proportion or choose a part of your spreadsheet and zoom into that choice.
  • You can even flip off the formulation bar, gridlines, and headings to make extra room in your information.
  • You may see how your spreadsheet will print by going into Web page Break Preview mode or Web page Structure mode.
  • You may even create your individual customized views to use sure show and print settings after which swap amongst these completely different views.

For this text, I am utilizing Excel from an Workplace 365 subscription, however the options I describe are accessible in different variations of Excel.

LEARN MORE: Workplace 365 Client pricing and options

To begin, launch Excel and open a spreadsheet, ideally one with extra rows and/or columns than you may see on the display at one time. You are most likely already conversant in the Zoom software, however let’s go over the choices right here. Click on the View tab to show the View Ribbon. Click on the button for 100%. Relying in your present view that can both zoom you in or zoom you out. In my case, the view was set for 150%, so switching to 100% displayed extra of my spreadsheet on the display (Determine A).

Determine A


Subsequent, you may swap to a selected zoom stage. Click on the Zoom button. You may select any of the default values or kind your individual customized quantity. Choose a worth and click on OK. You can even zoom to a variety. This may be helpful for narrowing your view simply to rows and columns it is advisable to see. Choose a selected space of the spreadsheet after which click on the button for Zoom To Choice (Determine B).

Determine B


You may flip off sure display components to vary the look of your spreadsheet or to see extra of your information. Within the Present part of the View Ribbon, flip off Gridlines to present your sheet a extra open look. Flip off Formulation Bar if you happen to need not add extra formulation to the sheet. Flip off Headings to take away the headings in your rows and columns (Determine C).

Determine C


Gauging how your spreadsheet will print is a problem once you’re in Regular view; two different views provide a greater peek. Within the Workbook Views part of the View Ribbon, click on the button for Web page Structure to see what number of printed pages your spreadsheet will take. Click on the button for Web page Break Preview to see how the pages will look when printed. In each Web page Structure and Web page Break Preview, you should utilize the Zoom instruments to zoom in or out and switch Gridlines, Formulation Bar, and Headings on or off (Determine D).

Determine D


Subsequent, you may create customized views. With a customized view, you may set up sure show and print settings, corresponding to no gridlines or headings, particular margins, and a selected Workbook view. You then save that view so you may simply apply it to your spreadsheet. You may even create a number of views. To do that, make some modifications to a spreadsheet. Flip off gridlines and headings. Set particular margins. Create a header or footer. Change the view from Regular to Web page Structure. On the View menu, click on the button for Customized Views. On the Customized Views window, click on Add. Create a reputation for this view and click on OK (Determine E).

Determine E


Now, reverse all of the modifications you made. Activate gridlines and headings. Reset the margins. Take away or change the header or footer. Go to again Regular view. Click on the Customized Views button. Ensure that the view you created is highlighted. Click on the Present button, and all of the settings you created for that view are utilized again to your spreadsheet (Determine F).

Determine F


Additionally see

Affiliate disclosure: TechRepublic might earn a fee from the services featured on this web page.


Source link