Forum Discussion

4 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver 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_tarler's avatar
    m_tarler
    Bronze 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.

  • Olufemi7's avatar
    Olufemi7
    Iron 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_Eekelen's avatar
    Riny_van_Eekelen
    Platinum 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.