Topics in this Post
show
View Tab in Microsoft Excel

View Tab in Microsoft Excel is use for changing the sheet layouts, show/hide viewing contents, zoom in/out sheet, arranging and adding multiple window and record a macro etc. Ribbon of View Tab is divided in to multiple sections with the name Workbook Views, Show/Hide, Zoom, Window and Macros. The detailed explanation about View Tab in Microsoft Excel is given below.
Workbook Views
- Normal Layout – This is by default layout view of the worksheet. This layout is use for creating database.
- Page Layout – This layout distribute the sheet in to multiple pages.
- Page Break Preview – This layout display the pages with page numbers and pages break lines.
- Custom Views – This option allows to saving multiple area of sheet with names, so that we can jump anywhere in sheet or whole workbook using the custom views.
- Full Screen – This option is use to view the worksheet in full screen mode.
Show/Hide
- Ruler – This option is use to show or hide the ruler.
- Gridlines – This option is use to show or hide the gridlines. It is use to display row and column lines on a worksheet to make content easier to read.
- Message bar – This option show or hide Message bar.
- Formula Bar – This option use to show or hide formula bar.
- Headings – This option is use to show or hide worksheet headings (Column and Row numbers).
Zoom
- Zoom – This option is use to set the zoom level for the worksheet according to the preset size or custom size.
- 100% Zoom – This option set the 100% zoom level of the sheet.
- Zoom to Selection – This option zooms as much as the worksheet area is selected.
Window
- New Window – This option insert a new window of the current active workbook.
- Arrange All – This option arranges the multiple workbooks side by side on the screen.
- Split – This option splits the current workbook in to two parts, so that user can view different section of the workbook at the same time.
- Hide – Using this option we can hide the current workbook window.
- Unhide – Using this option we can unhide the window window.
- View Side by Side – This option is use to view two workbooks side by side, so that we can compare their data.
- Synchronous Scrolling – This option synchronize the scrolling of two Workbooks, so that they scroll together.
- Reset Window Position – This option reset the window position of the workbooks being compared side by side; so that they share the screen equally.
- Save Workspace – This option is use to save the current layout of all workbooks window as a workspace, so that it can be restored later.
- Switch Window – This option switches the current workbook in another opened workbook window.
Macros
- Macros – Macro is a function that works with excel vba. This option record a macro and run a recorded macro. Macro is a program in View Tab in MS Excel, that is use to record a work including mouse actions and keystrokes. Macro feature is a most useful for repeatable work. If any work in excel we repeat time to time, we can record it using macro and run when it require.