Keep portion of your sheet Visible using Freeze Panes


Suppose you have large worksheet with having more than 100 rows and column heading on Top. Now when you scroll down the worksheet, column heading or Titles get disappear. To keep heading rows visible, you can use Freeze Pane feature.

Let's see one example:

Here we want to freeze first row which is having column heading or Titles.

To do this, Go To View-> Freeze Panes-> Freeze Top row

Now Top row with titles are freezed. To Check scroll cursor in below image. Titles will remain visible while scrolling through the rest of the worksheet.

1,045 total views, 1 views today

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>