I'd like to share…... SUMPRODUCT

[James Perry]

I keyed in =SUMPRODUCT() on my Mac in a cell and hit Cmd+A and Excel displayed 1048576 which is exactly the number of rows in my Excel worksheet.

 

[Hui]

James

What does Cmd+A do ?

I can't reproduce that on a PC

 

[James Perry]

Hello Hui......on my Mac its the 'command' button on the left hand side of the keyboard.
Cheers

 

[Somendra Misra]

@James Perry

Hi,

When I tried the same on my MAC Excel Version 2011, NOTHING happened . The Cursor kept blinking there.

@Hui

CMD+A is similar to Ctrl+A i.e. select All shortcut on MAC.

Regards,

 

[James Perry]

The Mac i use is-
OS X
Version 10.9.2
It works very well on mine.
Sorry guys.

 

[Somendra Misra]

Mine is also 10.9

Regards,