Ms excel view tab

 

 

EXCEL VIEW TAB

Normal ::- The Normal tab in the View tab in Microsoft Excel is the default view of a worksheet. It shows the worksheet as it will appear on the screen, with all of the cells and formatting visible. You can use the Normal view to enter data, format cells, and create formulas.

Page Layout ::- The Page Layout view in the View tab in Microsoft Excel is a view that shows the worksheet as it will appear when it is printed. This view includes the page breaks, margins, and headers and footers.

Page Break Preview ::- The Page Break Preview in the View tab in Microsoft Excel is a view that shows the worksheet as it will appear when it is printed, including the page breaks. The page breaks are dotted lines that indicate where the worksheet will be divided into pages when it is printed.

Custom views ::- A custom view in Microsoft Excel is a saved view of a worksheet that includes specific display and print settings.

Full Screen ::- Full screen in MS Excel View tab is a view that hides the ribbon, tabs, and status bar, so you can see more of your worksheet.

Ruler ::- Ruler in MS Excel View tab is a horizontal and vertical bar that shows the width and height of columns and rows.

Formula Bar ::- Formula bar in MS Excel View tab is a bar below the ribbon that displays the selected cell's content and displays the cell address of the selected cell on the left side.

Gridlines ::- Gridlines in MS Excel View tab are faint lines that divide cells from each other.

Headings ::- Headings in MS Excel View tab are the row and column labels that identify the data in a worksheet.

Message Bar ::- The Message Bar in MS Excel View tab is a bar that displays security alerts, workflow tasks, server document information, and policy messages.

Zoom ::- The Message Bar in MS Excel View tab is a bar that displays security alerts, workflow tasks, server document information, and policy messages.

100% ::- 100% in MS Excel View tab is the default zoom level, which displays the worksheet at its actual size.

Zoom to Selection ::- Zoom to Selection in MS Excel View tab is a feature that zooms the worksheet so that the selected cells fill the entire window. This allows you to focus on a particular area of the worksheet without having to scroll.

New Window ::- New window in MS Excel View tab is a feature that opens a new window of the same workbook. This allows you to view different parts of the workbook at the same time.

Arrange All ::- Arrange All in MS Excel View tab is a feature that arranges all open workbook windows in a specific way. This allows you to view multiple workbooks at the same time.

Freeze Panes ::- Freeze panes in MS Excel View tab is a feature that keeps certain rows and columns visible when you scroll through a worksheet.

Split ::- Split in MS Excel View tab is a feature that divides the worksheet into multiple panes. This allows you to view different parts of the worksheet at the same time.

Hide ::- Hide in MS Excel View tab is a feature that hides selected rows, columns, or worksheets from view.

Unhide ::- Unhide in MS Excel View tab is a feature that unhide hidden rows, columns, or worksheets.

View Side by Side ::- View side by side in MS Excel View tab is a feature that allows you to view two or more worksheets side by side in the same window. This is useful for comparing data between worksheets or for working on multiple worksheets at the same time.

Synchronous Scrolling ::- Synchronous scrolling in MS Excel View tab is a feature that allows you to scroll through two or more worksheets at the same time. This is useful for comparing data between worksheets or for working on multiple worksheets at the same time.

Reset Window Position ::- Reset Window Position in MS Excel View Tab is a feature that resets the position of two or more worksheets that are being viewed side by side so that they share the screen equally.

Save Workspace ::- The Save Workspace command in the View tab of MS Excel allows you to save the current configuration of all open and arranged workbook windows in a workspace file.

Switch Windows ::- The Switch Macros command in the View tab of MS Excel is a shortcut to the Macros dialog box. The Macros dialog box allows you to view, run, record, and edit macros.

Macros ::- A macro in MS Excel is a sequence of commands that can be recorded and played back later. Macros can be used to automate repetitive tasks, such as formatting cells, entering data, or running calculations.