Microsoft Excel - Easily Check A Range Selection's Dimensions (Excel 97/2000/2001/2002)


Judging a range's size can be a challenge, particularly if the range extends beyond one viewable screen's worth of worksheet real estate. Fortunately, there's an easy way to tell how many rows and columns you've selected. When you select a range, the Name box next to the Formula bar displays its dimensions as long as you have the mouse button pressed. For example, the Name box displays 5R x 7C when the selected range is five rows by seven columns. This can be handy for situations that require you to select a specifically sized range, such as certain copy/paste scenarios, transposing data, or creating array formulas.

Go back