Freeze Pane in Excel - SANGITAB

Latest

Blog For All

Freeze Pane in Excel

You can view two areas of a worksheet and lock rows or columns in one area by freezing or splitting panes (pane: A portion of the document window bounded by and separated from other portions by vertical or horizontal bars.)
When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet.

To Top Rows Freeze Pane

Freeze Pane in Excel


1. Go to Views Tab
2. Click on Freeze panes arrow icon
3. Click on freeze Top Row

Freeze Pane in Excel

To freeze fix Rows

Freeze Pane in Excel



To freeze selected rows first select the rows which you want to freeze and

1. Go to Views Tab
2. Click on Freeze panes arrow icon
3. Click Freeze Panes

Freeze Pane in Excel

TO Freeze First Column

1. Go to Views Tab
2. Click on Freeze panes arrow icon
3. Click on Freeze First Column

TO Unfreeze Panes

Freeze Pane in Excel

1. Go to Views Tab
2. Click on Freeze panes arrow icon
3. Click On Unfreeze Panes

Freeze Pane in Excel

Check These Also


No comments:

Post a Comment

Dear Readers,

Great !! You've decided to leave comment for us. Let's make meaningful conversation by adding your name.

Please note that,

Comments deemed to be spam or questionable spam, including profanity and containing language or concepts that could be deemed offensive will be deleted.
Including a link to relevant content is permitted, but comments should be relevant to the post topic.