ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I automatically count the number of cells highlighted (https://www.excelbanter.com/excel-discussion-misc-queries/97995-how-do-i-automatically-count-number-cells-highlighted.html)

Ferd

How do I automatically count the number of cells highlighted
 
I have Office 2003 Professional installed

Damon

How do I automatically count the number of cells highlighted
 

Hi Ferd,

When you highlight a set of cells you will see their sum appear on the grey
bottom border of your excel window. Sum is the default option. Right click
on the border, and you can change it to give you the count of number of cells
highlighted (or other options like average value, minimum cell value in the
selection, etc).

Cheers,
Damon

"Ferd" wrote:

I have Office 2003 Professional installed


Damon

How do I automatically count the number of cells highlighted
 
hi

"Damon" wrote:


Hi Ferd,

When you highlight a set of cells you will see their sum appear on the grey
bottom border of your excel window. Sum is the default option. Right click
on the border, and you can change it to give you the count of number of cells
highlighted (or other options like average value, minimum cell value in the
selection, etc).

Cheers,
Damon

"Ferd" wrote:

I have Office 2003 Professional installed



All times are GMT +1. The time now is 03:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com