Forum Discussion
row count in status bar
Hi
is there a way to show only row or column count in status bar? here it is showing count of total no of cells=10 selected. is it possible to show row count = 5 and column count = 2 separately?
4 Replies
- JKPieterseSilver Contributor
Depending on the size of your selection, Excel either displays the number of rows and columns of your selection in the Name box :
or as a small tooltip on the bottom right of your selection:
- m_tarlerBronze Contributor
As noted by others, no excel does not include those options for the status bar. I also wish they would and you can send a suggestion using the HELP -> Feedback button or from the excel feedback forum
and in fact went there and did a search that suggestion is already there so I suggest you go there, register if needed and up-vote that suggestion:
On another note, in case you didn't know already you can get that information when highlighting areas from the pop-up that shows to the bottom right of the area:
however, i'm not positive how to get that pop-up to show. It appears the range needs to be 'big enough' and go 'off the screen' to force the sheet to scroll, but once it shows up you can reduce the size and the pop-up will stay and show you the rows and columns on smaller areas.
- Olufemi7Iron Contributor
Hello SP3990,
No, this is not possible in Microsoft Excel.
The Status Bar only shows summary calculations for the selected cells such as Count, Numerical Count, Sum, Average, Min, and Max. It calculates the total number of selected cells, not separate row and column counts.
There is no built-in option to display row count and column count separately in the Status Bar.
If needed, you can use formulas instead
=ROWS(A1:B5)
=COLUMNS(A1:B5)Microsoft Support reference
View summary data on the status bar
https://support.microsoft.com/en-us/office/view-summary-data-on-the-status-bar-f42a3ae1-3786-4294-a433-1b36a1c17ebb - Riny_van_EekelenPlatinum Contributor
As you have noticed, the status bar displays the statistics of all cells selected. Besides Count and Average you can show Sum, Numerical Count, Min and Max. Right-click on the status bar and you see all the elements that can be displayed in it. An analysis by column and counting columns in the selection are not available.