Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
KMHarpe
 
Posts: n/a
Default Can someone please explain array formulas to me?

I know you're supposed to use Ctrl-Shift-Enter, but when do you do this, do
you enter it before or after the formula? do you hit Ctrl-Shift, and then
enter? Help! Thanks!
  #2   Report Post  
Biff
 
Posts: n/a
Default

Hi!

Type the formula then while holding down the CTRL and SHIFT keys, hit ENTER

Biff

"KMHarpe" wrote in message
...
I know you're supposed to use Ctrl-Shift-Enter, but when do you do this, do
you enter it before or after the formula? do you hit Ctrl-Shift, and then
enter? Help! Thanks!



  #3   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

KM,

Ctrl, Shift and Alt are modifiers. You're modifying the Enter key in this
case, so you must have Ctrl and Shift down when you press Enter.
--
Earl Kiosterud
www.smokeylake.com

"KMHarpe" wrote in message
...
I know you're supposed to use Ctrl-Shift-Enter, but when do you do this, do
you enter it before or after the formula? do you hit Ctrl-Shift, and then
enter? Help! Thanks!



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
array formulas R.VENKATARAMAN Excel Worksheet Functions 7 June 16th 05 10:25 PM
Cannot copy or move array entered formulas ... shared workbk JimDerDog Excel Worksheet Functions 0 May 26th 05 04:17 PM
Array formulas SimonT Excel Worksheet Functions 1 February 10th 05 06:54 AM
Problem with Array Formulas and ISNUMBER Henrik Excel Worksheet Functions 1 February 10th 05 12:31 AM
Using wild card characters in array formulas PJB Shark Excel Worksheet Functions 3 January 19th 05 03:09 PM


All times are GMT +1. The time now is 11:42 PM.

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

About Us

"It's about Microsoft Excel"