Tip #088 – Excel

Excel : Freezing

If you have a long spreadsheet where the headings keep scrolling up and out of sight – you should turn on the FREEZE PANES function.


It’s been greatly improved since 2003 – especially if you have a “clean” spreadsheet (one where the first row (#1) is headings and all subsequent rows are records of data…basically a database-type spreadsheet.


Full tip: Excel tip