Skip to main content
Workforce LibreTexts

14.5: Zoom, View, and Window Options

  • Page ID
    13673
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)

    Just like Microsoft Word, the bottom right-hand corner provides multiple views and zoom options. The three Zoom options from left to right are Normal, Page Layout, and Page Break Preview. clipboard_e7ad09fcb950d331a49ffce8560ae51e8.png. Normal is the standard view with just cell information in the worksheet available to the user. In this view, the user can focus on their work and is not able to determine how their sheet would appear if printed. Page Layout View provides a preview of what the document will look like when printed. Page Layout view is also the place where the user can add headers and footers to their worksheet. Finally, the page break view displays the normal view with dotted lines where the printer would print a new page. To the right of the various views is a zoom slider to allow the user to zoom in or out of their worksheet.

    Finally, just like Word, Microsoft Excel’s top of the document contains numerous window management and document management capabilities, including the Excel Ribbon.

    clipboard_ed7afd1d3902ce2092fedac1ed416fbd8.png

    The Excel Ribbon consists of the File, Home, Insert, Page Layout, Formulas, Data, Review, View, and Help Tabs.

    The File Tab is responsible for saving your workbook, creating new workbooks, or opening other workbook files. It also has options for sharing the workbook and exporting it to other formats. Like Microsoft Word, it also contains options for other Excel Templates for a variety of functions.

    clipboard_e4aca765b586e88ed1694bc73d7ac0bd4.png

    In addition to Open, Saving, and sharing options, Excel contains multiple print options, allowing the user to customize their workbook. As Word, Excel users can choose their printers, the orientation of the printing, as well as what is printed. By default, only the active sheet – the document the user is currently working in, will be printed. Worksheets can also be scaled to fit the entire worksheet on one page, or multiple pages, depending on the user settings. Finally, the user can specify the printing margins on the document in this window as well.

    clipboard_ee9dc0139e7e5e2e929389434bb2ff264.png

    The Home Tab allows various options to change the fonts, text size, cell properties, and insert, delete and modify cell contents and formulas.

    The Insert Tab allows for a variety of tables, charts, pictures, text and symbols to be used in Excel.

    The Page Layout Tab allows for customization of how the worksheet is oriented and appears during printing.

    The Formulas Tab allows for a vast amount of customization of Excel formulas and calculation options.

    The Data Tab allows the user to import and export data as well as manipulate data sets, to establish queries and connections and separate and sort data.

    The Review Tab allows for various worksheet protections and sharing settings along with help with spell and grammar check and accessibility checking. Similar to Microsoft Word, changes to the document can be recorded, and collaboration settings may be controlled.

    The View Tab allows for further worksheet customization to the user to display or hide document tools bars, freeze or expand cells, and Macro settings to complete multiple tasks at once.

    Finally, the Help Tab allows the user to receive help from frequently asked questions. Like Microsoft Word, users can enter their questions in plain text in the “Tell me what you want to do” field clipboard_e82860c5f88e806e82dc93158603db146.png, and Excel will use artificial intelligence to retrieve a solution.


    14.5: Zoom, View, and Window Options is shared under a CC BY license and was authored, remixed, and/or curated by Nick Heisserer.

    • Was this article helpful?