Microsoft Office

View tab in Excel

View tab in Excel : Click the View tab in Excel and you will find the buttons to view the excel file in different views like Normal View, Page Break Preview, Page Layout and Custom Views.

View tab in Excel

There are five groups in View tab in Excel :

  1. Workbook Views Group
  2. Show/Hide Group
  3. Zoom Group
  4. Window Group
  5. Macros Group

Workbook Views Group 

The Workbook Views Group allows you to change the look of your workspace and view your worksheets in different ways including Normal, Page Break Preview, Page Layout and Custom Views.

View tab in Excel
Workbook Views Group
Normal

This option allows you to view your document in Normal view.

Page Break Preview 

This option allows you to see where the page break will appear when your document is printed.

Page Layout 

By this option, you can see how your printed document will look. This is a good way to check out where the pages begin and end, and to see any headers/footers on the page.

Custom Views

Save your current display and print settings as a custom view that you can quickly apply in the future.

Show Group

The Show Group is used for change the Show and Hide of Ruler, Formula Bar, Gridlines, Headings etc.

Show Group
Ruler

Show rulers next to your document. You can see and set tab stops, move table borders, and line up object in the document. Also you can measure stuffs.

To show or hide Rulers, Click on Rulers in the Show group under the View tab in Excel.

Gridlines

Show the lines between rows and columns in the sheets to make the sheet easier to read.

To show or hide Gridlines, Click on Gridlines in the Show group under the View tab in Excel.

Formula Bar

The Formula Bar displays formula as well as value entered into the active cell it is also used to edit formulas and content in it.

To show or hide Formula Bar, Click on Formula Bar in the Show group under the View tab in Excel.

Headings

Show column headings and row numbers. Column headings are the letters or numbers that appear above the columns on a sheet.

To show or hide Headings, Click on Headings in the Show group under the View tab in Excel.

Zoom Group 

The Zoom Group contains tools related to Zoom or preview bigger or smaller the worksheet.

Zoom Group
Zoom

Use this option to zoom to the level that is right for you.

100%

By this option, you can zoom your document to 100%.

Zoom to Selection

This option zoom the sheet so the selected ranges of the cells fills the entire window. This can help you focus on a specific area of the sheet.

Window Group

The Window Group is used for open a window containing view of the current Excel workbook, open all the Excel workbook side by side, keep a portion of the sheet visible while the rest of sheet scrolls.

Window Group
New Window

By using this option, you can open a second window for your document so you can work in different places at the same time.

Arrange All

By using this option, you can stack your open windows so you can see all of them at once.

Freeze Panes

Whenever you are working with a lot of data, it can be difficult to compare information in your workbook. Fortunately, Excel include several tools that make it easier to view content from different parts of your workbook at the same time, such as a ability to freeze panes and split your worksheet.

It has three options :

  • Freeze Panes : This option keeps rows and columns visible while the rest of the worksheet scrolls.
  • Freeze Top Row : This option keeps the top row visible while scrolling through the rest of the worksheet.
  • Freeze First Column : This option keeps the first column visible while scrolling through the rest of the worksheet.
Split

This option divides the window into different panes that each scrolls separately.

Hide

This option allows you to hide the current window.

Unhide

By this option, you can unhide any window hidden by the Hide Window feature.

View Side by Side

Instead of switching back and forth between workbooks, view them side by side. It makes comparing them easier. View Side by Side option allows you to view your worksheet side by side.

Syhcronous Scrolling

By this option, you can acroll two documents at the same time. This is a great way to compare documents line by line or scan differences. To use this feature, first you have to turn on View Side by Side feature.

Reset Window Position 

By using this option, you can place a document you are comparing side by side so they share the screen equally. To use this feature, you first have to turn on View Side by Side feature.

Macros Group

The Macros Group contains tools used to do a Macro expansion in the workbook like event recording, scripting etc.

Macros Group
Macros

Micro is the recording of each command and action you perform to complete a task. Then whenever you need to carry out that task repeatedly in a spreadsheet you just run the macro. 

This command has three options :

  1. View Macros (Alt+F8) : By using this option, we can see a list of macros we can work with.
  2. Run Macro : By using this option, we can run a macro. Each of the commands you perform will be saved into the macro so that you can play them back again.
  3. Use Relative References: Use relative reference so that macros are recorded with actions relative to the initial selected cells.

You can also join us at QUORA and PINTEREST

About the author

Pooja Rastogi

Leave a Comment