Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
qwopzxnm
 
Posts: n/a
Default What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out.


I've seen it posted in a few other threads while browsing the forums but
don't know what it does.


--
qwopzxnm
------------------------------------------------------------------------
qwopzxnm's Profile: http://www.excelforum.com/member.php...o&userid=27557
View this thread: http://www.excelforum.com/showthread...hreadid=477953

  #2   Report Post  
cottage6
 
Posts: n/a
Default What does hitting Ctrl + Shift + Enter to enter a formula do??? H

Hi, the following came right out of Help in Excel. If you open Help and type
in "array formula", you'll get some help on creating and working with array
formulas, as well examples to help explain what an array is.

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.

"qwopzxnm" wrote:


I've seen it posted in a few other threads while browsing the forums but
don't know what it does.


--
qwopzxnm
------------------------------------------------------------------------
qwopzxnm's Profile: http://www.excelforum.com/member.php...o&userid=27557
View this thread: http://www.excelforum.com/showthread...hreadid=477953


  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default What does hitting Ctrl + Shift + Enter to enter a formula do???Help a n00b out.

Chip Pearson has some notes at:

http://www.cpearson.com/excel/array.htm



qwopzxnm wrote:

I've seen it posted in a few other threads while browsing the forums but
don't know what it does.

--
qwopzxnm
------------------------------------------------------------------------
qwopzxnm's Profile: http://www.excelforum.com/member.php...o&userid=27557
View this thread: http://www.excelforum.com/showthread...hreadid=477953


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to enter a null cell value in a formula Using formulas to enter NULL cell values Excel Worksheet Functions 5 December 16th 04 04:29 AM
how to enter a formula using column() function for a range Mike Peter Excel Worksheet Functions 6 December 8th 04 08:11 AM
formula will not enter? Brian Excel Worksheet Functions 1 December 2nd 04 05:50 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 04:13 PM
Can you enter a formula in a cell that auto-inputs calculations a. proactive Excel Worksheet Functions 4 November 9th 04 06:00 AM


All times are GMT +1. The time now is 10:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"