- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -

Count Rows and Columns in Excel

When you’re highlighting entire rows or columns in MS Excel the program will let you know how many have been selected as you go.


But, have you ever noticed that you can’t get that same information when you’re highlighting a range of cells?

I mean, we often need just a partial row and column and that handy-dandy little counter doesn’t appear in those instances.

What to do, what to do… manually count?

Let’s hope not since that’s not really feasible in a lot of cases… So now what?

Well, while you may not have noticed it, Excel is letting you know just how many rows and columns are involved in your selection.

The catch is that you just have to know where and when to look.

Next time you highlight a range of cells take a look in the Name Box (left of the Formula bar).


As long as you still hold down the mouse button (or shift key for those who select cells with the keyboard) the Name Box will display the number of rows and columns involved.

This is one of those super-easy tricks – it’s absolutely nothing new to learn – just pointing out information that Excel was providing to you. (Although, I’ve got to say, that it does seem like a “sneaky” way of giving information – but whatever works.)

So just remember, when you release the button the information disappears so be sure to look before you let go!