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.

Author: M.L. Humphrey

M.L. Humphrey is a former securities regulator, registered stockbroker (although only briefly), and consultant on regulatory and risk-related matters for large financial institutions with expertise in the areas of anti-money laundering regulation, mutual funds, and credit rating agencies. Since 2013 M.L. has also been a published author under a variety of pen names and across a variety of subjects and genres. You can contact M.L. at mlhumphreywriter [at] gmail.com.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: