Entering array formulas

G

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?
 
C

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
 
D

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
 
B

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
Click to expand...
To enter an array formula, press command-shift-enter.
 
Top