User Login

Help Community Login:

Counting Rows and Columns in MS Excel

missb's picture
missb
Banned Member (Way To Go!)
Relationship Status:
Single & Not Looking
Joined: 01/16/2009
Posts: 3109
Drops: 3812
Mood: Weird

When you're highlighting entire rows or columns in MS Excel that don't start from the top, Excel actually will let you know how many have been selected as you go. Notice 9R in the image below, indicates 9 rows have been selected.

If you're trying to get the same information when you highlight a range of cells, you don't get the results the same way. However it does let you know how many rows and columns are in your selection.

Just highlight the range that you want (rows & columns) and look in the name box, which is to the left of the formula bar. It tells you right there how many rows & columns you have chosen, 11 rows and 5 columns in this example. As long as you're holding down the mouse button you will see this, as soon as you release it, this information will disappear.


I Averaged: 0 | 0 votes


Read More ...





Who's New

metaclippingpath's picture
Generalocee's picture
emma agro's picture
DarkkDdream's picture
Larisabrownb's picture
conor13's picture
MeadeDorianx's picture
Emilylowes's picture
Emmaythomson's picture
Chair's picture
Financial's picture
Red bud's picture
DonnaStella123's picture
WenrichFeugene's picture
Weissert's picture
facebook codes exploits tips tricks Phrozen Crew
All contents ©Copyright GeekDrop™ 2009-2024
TOS | Privacy Policy