Entering array formulas

[GeorgeWi]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

What is the key stroke combination to indicate that a formula is an array formula?

 

[CyberTaz]

Hi George;

Command+return is what you're looking for.

Just so you know, almost all keyboard operation is covered in Excel Help.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[dloranz]

I am using OS X 10.5.7 and Excel 12.2.0 (updated to 12.2.1) on a MacBook Pro.
(My version of Office is labeled "Student Version".)

cmd+enter does not work for me. (It did in the pre-2008 version of Excel.)
In the 2008 version cmd+return just advances the highlighted section. For
example, I highlight B2:B20 and hit cmd+return. Result is that B21:B40
become highlighted.

I'm trying to get FREQUENCY to work in 2008.

Thank you very much.
- Dan

 

[Bob Greenblatt]

I am using OS X 10.5.7 and Excel 12.2.0 (updated to 12.2.1) on a MacBook Pro.
(My version of Office is labeled "Student Version".)

cmd+enter does not work for me. (It did in the pre-2008 version of Excel.)
In the 2008 version cmd+return just advances the highlighted section. For
example, I highlight B2:B20 and hit cmd+return. Result is that B21:B40
become highlighted.

I'm trying to get FREQUENCY to work in 2008.

Thank you very much.
- Dan

To enter an array formula, press command-shift-enter.