Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is freeze panes in Microsoft Excel ?

user-image
Question added by jhangeer bazmi , Computer Instructor and Operator , Imran Computer College Millat Chowk
Date Posted: 2017/03/15
Firas Shahadi
by Firas Shahadi , Training And Development Director , Muhayal Assir National Hospital

Freeze Panel is a great way to keep number of rows or number of columns or both visible while you are scrolling up and down, to left or right of the sheet.

 

But you can use it out-of-box uses :)

I am usually using them when designing a dashboard to freeze big range of cells, so the user can not leave this range. :)

 

thank you for the question

 

Razzi Haider Zaidi
by Razzi Haider Zaidi , Accountant , Batala General Trading LLC

If you want to view some of the cells (rows or column) continuously on the sheet while scrolling down (specially in long sheets) then you  use to freeze pane to freeze those rose or columns so they won't get scrolled up/down or right/left. It is convenient while analyzing and entering data in the sheet.

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.