Quick Tip: Microsoft Excel: Freeze Panes

Spreadsheets that are dozens of columns wide and hundreds of rows long can be difficult to read. You have to scroll all the way back up to the top to remember what the header said, and then hopefully keep it in mind by the time you get back to the item in question. Thankfully, there’s a way to let the important rows and columns (such as headers) stay in view while you browse your data. I’ll show you how to freeze certain cells in a spreadsheet in this quick tip, so no matter how much data you have, you always know what you’re looking at.

See more quick tips here: Quick Tips for Microsoft Office Applications.