Latest

6/recent/ticker-posts

Header Ads Widget

Get Job Vacancy Notice, Download Syllabus and More Job Related.

Freeze Pane in Excel

ADVERTISEMENT
ADVERTISEMENT

More Stuff


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

ADVERTISEMENT
If You are going to Post a Comment, Please keep in mind that all comments are moderated and only comments that are relevant to the post topic will published. Let's have a meaningful conversation relevant to the post topic. THANK YOU. Check privacy policy HERE .

Post a Comment

0 Comments