MS-Excel (View)

VIEW TAB IN MS EXCEL

Normal View: This option is used to normally show the selected worksheet.

Page Layout View: This view type is used to view the excel sheet as it will appear after print out and also used to view see where pages begin and end along with header and footer contents.

Page Break Preview: This option is used to show only those area which filled with data items and by using this option, we can also change the page size.

Custom Views: This option is used to add the selected number of cells with name, which require visiting just after a short while (time).

Full Screen: This option is used to show selected worksheet in full-screen mode.

Ruler: This option is used to show and hide the ruler bars and it will only activate when page view set in "Page Layout" view.

Gridlines: This option is used to show and hide the gridlines only in the selected worksheet.

Formula Bar: This option is used to show and hide the formula and formula bar is used to edit selected text and formula.

Headings: This option is used to show and hide the Row and Column headings.

Zoom: This tool is used to change zoom size of the selected worksheet.

Zoom to Selection: This tool is used to zoom only selected cells.

New Window: This option is used to create a clone window for presently working window and after creating clone window any modify in one workbook will also affect the second workbook.

Arrange All: This option is used to open all active excel window on one screen.

Freeze Panes: This option is used to freeze the selected number of columns or First Row or First Column and after the freeze, only a portion of the visible while the rest of the sheet scrolls.

Split: This option is used to split the current window into four resizable panes.

Hide: This option is used to hide the current workbook.

Unhide: This option is used to show an already hidden workbook.

View Side by Side: This option is used to show two workbooks side by side.

Save Workspace: This option is used to combine multiple already saved workbook in one unit.

Switch Window: This option is used to show names of all already opened excel files to immediately switch to another file from the current file.

Macro: This option is used to create and run an already existing macro. By using macro we can record common repetitive tasks and formulas and get it again in any worksheet by run macro.

HOME