Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What is freeze panes in Microsoft Excel ?

user-image
Question ajoutée par jhangeer bazmi , Freelance Graphics Designer
Date de publication: 2017/03/15
Firas Shahadi
par Firas Shahadi , Human Resources Director , SAUDI UNION

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
par 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