Complete Guide to View Menu in MS Excel

In Microsoft Excel, the View menu is used to change how a workbook is displayed, manage multiple windows, freeze rows/columns, adjust page layout, and prepare sheets for printing. In this blog, we will explore each option under the View Menu in detail.

View Menu

 Window Group

1. New Window

• Creates a duplicate copy of the workbook in a new window.

2. Arrange All

• Arranges multiple workbooks on the same screen for easy comparison.

3. Split

• Splits the workbook into multiple panes for easier navigation and editing.

4. Hide

• Temporarily hides the current workbook window.

5. Unhide

• Displays a workbook that was hidden using the Hide option.

6. Switch Window

• Allows switching between multiple open workbooks.

Freeze Panes

 Freeze Panes

Freeze Panes is used to lock specific rows or columns so that they remain visible while scrolling.

Options:

1. Freeze Panes—Freezes both rows above and columns to the left of the selected cell.

2. Freeze Top Row—Freezes only the top row.

3. Freeze First Column – Freezes only the first column.

4. Unfreeze Panes—Removes all frozen rows and columns.

Page Layout 

 Page Layout View

• Displays the worksheet in page format.

• Normal View—Displays the worksheet in its regular format.

Page set up     

Page Setup (under Page Layout Menu → Page Setup)

1. Margins—Sets extra spacing on the top, bottom, left, and right of the page.

2. Orientation—Sets page direction as vertical (portrait) or horizontal (landscape).

3. Size – Selects page size (e.g., A4, Letter).

4. Print Area—Defines the specific area of the sheet to print.

5. Breaks—Inserts or removes page breaks.

6. Background—Adds an image as the sheet background.

7. Print Titles –

   • Row to Repeat at Top – Prints a specific row at the top of every page.

   • Columns to Repeat at Left—Prints a specific column on the left of every page.

   • Page Order—Decides the order of printing:

     • (A) Down, then Over

     • (B) Over, then Down

Scale to Fit

 Scale to Fit

• Used to increase or decrease row/column size so that all data fits within a page.

Sheet option 

 Sheet Options

1. Gridlines – View and print gridlines on the worksheet.

2. Headings – View and print row and column headings.

Note: Gridlines print across the entire page. If you want borders only for your data, use the Border option instead.

Cell Styles 

Cell Styles (Home → Cell Styles)

• Apply different built-in styles to cells for better formatting and presentation.

View menu in hindi blog

Thanks to ChatGPT

Thanks To Google