excel freeze pane

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel freeze pane

Excel freeze pane

resolvedResolved · Medium Priority · Version 2003

Peter has attended:
Excel Introduction course

Excel freeze pane

how do you make a freeze pane

RE: Excel freeze pane

If you go to Window and Freeze Panes then it will freeze the first row and a few columns. If you scroll down or across these will always be set. If you have a list of 5000 rows and you are on row 3904 then you might want to see what the values relate to and you can because the headings are still visible. If you want just the headings to freeze then click on the little rectangle just above the right hand scroll bar and drag it onto the sheet just below the column headings. This will freeze them


 

Excel tip:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

View all Excel hints and tips


Server loaded in 0.08 secs.