Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Entering Formulas

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Mike Golding
    Posts
    71
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  2. #2
    New Member
    Join Date
    Apr 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Array formula

  4. #4

    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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".

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  7. #7
    New Member
    Join Date
    Apr 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  8. #8
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  9. #9
    Board Regular
    Join Date
    Mar 2002
    Location
    Mike Golding
    Posts
    71
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •