Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

What does Ctrl+Shift+Enter do?

0 views
Skip to first unread message

Jerzy

unread,
Oct 4, 2003, 10:33:52 PM10/4/03
to
What does Ctrl+Shift+Enter do, when you use it in a
formula?

StarTrek an beyond

unread,
Oct 4, 2003, 11:09:38 PM10/4/03
to
This is found in the HELP file.

CTRL+SHIFT+ENTER Enter a formula as an array formula

About array formulas and how to enter them
An array formula can perform multiple calculations and then return either a
single result or multiple results. Array formulas act on two or more sets of
values known as array arguments. Each array argument must have the same
number of rows and columns. You create array formulas in the same way that
you create other formulas, except you press CTRL+SHIFT+ENTER to enter the
formula.


"Jerzy" <Driv...@cox.net> wrote in message
news:0a2501c38ae9$1de02df0$a401...@phx.gbl...

Chip Pearson

unread,
Oct 5, 2003, 9:20:22 AM10/5/03
to
Jerzy,

Ctrl+Shift+Enter enters the formula as an array formula. See
http://www.cpearson.com/excel/array.htm for an introduction to array
formulas.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com ch...@cpearson.com

"Jerzy" <Driv...@cox.net> wrote in message
news:0a2501c38ae9$1de02df0$a401...@phx.gbl...

0 new messages