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.
There are five groups in View tab in Excel :
- Workbook Views Group
- Show/Hide Group
- Zoom Group
- Window Group
- 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.
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.
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
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.
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
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 :
- View Macros (Alt+F8) : By using this option, we can see a list of macros we can work with.
- 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.
- Use Relative References: Use relative reference so that macros are recorded with actions relative to the initial selected cells.