« Dropbox, Skydrive and Google Drive: a Quick Comparison | Main | Spring Cleaning For Your SCLS Email Accounts »

Freezing panes in Excel

I made peace with a monster spreadsheet recently with this tip to freeze the header row and column at the same time to keep them both visible while scrolling.

Place the cursor in a cell below and to the right of the row and column you want to freeze, then select View > Freeze Panes > Freeze Panes.

Screen shot of selecting Freeze Panes in Excel

The header row and column stay frozen on screen alongside those far out cells after scrolling.

Screen shot of frozen panes after scrolling in Excel

Thanks to Kerri for teaching me this tip just when I needed it!


Feed You can follow this conversation by subscribing to the comment feed for this post.

Post a comment