New Logo White mail

Freezing panes in Excel 2007+

By Lisa Griffin, Jun 18 2014 04:24PM

Last week I was training a lady who wanted to know where the freeze panes command lives in Excel 2010 - she knew how to do it in 2003! Well, go to the VIEW TAB and it's there, slightly improved in that there are now built-in options for freezing the top row or left column. To do both at the same time you would need to click under the row/s you want to freeze AND to the right of the columns you want to freeze and then choose the FREEZE PANES command. A great tool for working with big worksheets!