Lock or Unlock Columns or Rows In Excel

My AMS keywords are showing me that people are searching on Amazon for how to lock or unlock columns in Excel.

First, a retail site like Amazon is not the best place to do a how-to sort of search. It’s just too granular a question. You want to use Google or Bing or something for that kind of question. But putting that aside…

What those people are probably searching for is how to freeze or unfreeze panes. That’s how you keep a top row or left-hand column (or both or more than one) always visible as you scroll through your data.

So. In case someone needs that…First, you can get the ebook of Excel Tips and Tricks for free on all major retailers. It covers freeze panes at a very basic level along with a number of other little tips and tricks to make using Excel easier.

Also, I have a video up on this, too, on YouTube:

Enjoy. Freeze panes is a lifesaver if you don’t already know it.