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.