Entering Formulas

Mike E Golding · Apr 25th, 2002, 09:14 PM

Hi'
Can someone please explain to me the reason for using Ctrl + Shift + Enter when entering certain formulas? Thanks

prida · Apr 25th, 2002, 09:19 PM

Hey, I know this one. If you select a range of cells, enter data into the active cell, then press ctrl-shift-enter, the data will be entered into the entire range of selected cells at once.

Tom Schreiner · Apr 25th, 2002, 09:52 PM

Array formula

Anonymoss · Apr 25th, 2002, 10:04 PM

Quote:

On 2002-04-25 20:19, prida wrote:
Hey, I know this one. If you select a range of cells, enter data into the active cell, then press ctrl-shift-enter, the data will be entered into the entire range of selected cells at once.

So what's the difference between that and Ctrl+Enter?

Mark W. · Apr 26th, 2002, 08:00 AM

Quote:

On 2002-04-25 20:14, Mike E Golding wrote:
Hi'
Can someone please explain to me the reason for using Ctrl + Shift + Enter when entering certain formulas? Thanks

See the Excel Help Index topic for "About array formulas and how to enter them".

Mark W. · Apr 26th, 2002, 08:11 AM

Quote:

On 2002-04-25 21:04, Anonymoss wrote:

So what's the difference between that and Ctrl+Enter?

Control+Enter is when you want to enter a formula that produces a single value into a selection of more than one cell.

Control+Shift+Enter is used to enter an array formula which either returns a set of values (e.g., {=TREND({2;3},,{3;4})}) in a contiguous cell range or a formula whose arguments are an array, but returns a single value into single cell (e.g., {=AVERAGE(IF(D1:D3,D1:D3))}).

BTW, since an array formula entered into a cell range becomes "indivisible" (i.e., attempts to clear one of the cells in the range will produce a "You cannot change part of an array" message) Control+Enter can be used to undo an array formula.

[ This Message was edited by: Mark W. on 2002-04-26 07:14 ]

prida · Apr 26th, 2002, 08:13 AM

Anonymoss--
No difference. Array formulas is the answer. My bad.

Mark W. · Apr 26th, 2002, 08:15 AM

Quote:

On 2002-04-26 07:13, prida wrote:
Anonymoss--
No difference. Array formulas is the answer. My bad.

Big difference! See my reply posting above.

Mike E Golding · Apr 26th, 2002, 08:32 AM

Thanks for all the replies. Very satifying. Hope I can return all the help given.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 25th, 2002, 09:14 PM	#1
Mike E Golding Board Regular Join Date: Mar 2002 Location: Mike Golding Posts: 71	Hi' Can someone please explain to me the reason for using Ctrl + Shift + Enter when entering certain formulas? Thanks

Apr 25th, 2002, 09:19 PM	#2
prida New Member Join Date: Apr 2002 Posts: 8	Hey, I know this one. If you select a range of cells, enter data into the active cell, then press ctrl-shift-enter, the data will be entered into the entire range of selected cells at once.

Apr 25th, 2002, 09:52 PM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Array formula

Apr 26th, 2002, 08:13 AM	#7
prida New Member Join Date: Apr 2002 Posts: 8	Anonymoss-- No difference. Array formulas is the answer. My bad.

Apr 26th, 2002, 08:32 AM	#9
Mike E Golding Board Regular Join Date: Mar 2002 Location: Mike Golding Posts: 71	Thanks for all the replies. Very satifying. Hope I can return all the help given.