Freeze Pane in Excel




Follow SANGITAB Blog With Bloglovin

To Get Regular Updates on Facebook

Like Our Facebook Page

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


Follow

More From Our Site:

No comments


About Us | HTML to XML Converter | Webmail Service | Nepali Unicode | Advertise | TC & Privacy Policy | Contact Us | DMCA.com Protection Status