CNTL + SHIFT + ENTER

Houstonwolf

Board Regular
Joined
Jul 28, 2006
Messages
154
Why do some formulas have to be entered with the Control/Shift/Enter combination? What is the criteria or how would you decide if a particular formula required that combination? I don't think I've ever seen an explanation.

Thanks!
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,844
Office Version
  1. 365
Platform
  1. Windows
Check out this topic in Excel help:

"About array formulas and how to enter them"
 

Watch MrExcel Video

Forum statistics

Threads
1,114,041
Messages
5,545,685
Members
410,697
Latest member
srishtijain0708
Top