Results 1 to 66 of 66

Array formula doesn't work (CTRL+SHIFT+ENTER)

Threaded View

  1. 02-03-2016, 09:14 AM #11
    PROBLEM SOLVER
    PROBLEM SOLVER is offline
    Registered User
    Join Date
    02-03-2016
    Location
    Ireland
    MS-Off Ver
    2013
    Posts
    1

    Re: Array formula doesn't work (CTRL+SHIFT+ENTER)

    Yes this problem is a pain. But really the solution is quite easy. You are told to enter control + shift + enter
    however what you have to do is 1. Place your cursor in the field where your array formula is located
    2. Now press f2 + control + shift + enter
    Your formula will now become an array formula and will have {} surrounding it.
    Last edited by PROBLEM SOLVER; 02-05-2016 at 10:43 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Multiple Array Formula & CTRL+SHIFT+ENTER
    By makingtrails in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-30-2014, 09:54 PM
  2. With VBA Enter Ctrl Shift Enter For Array Formula
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-17-2013, 09:02 AM
  3. Array Formula: Ctrl+Shift+Enter does not work
    By georgroth in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-30-2013, 12:15 PM
  4. Array Formula: CTRL+SHIFT+ENTER?
    By WebKill in forum Excel General
    Replies: 2
    Last Post: 05-27-2011, 01:56 PM
  5. Confirming array formula (CTRL+SHIFT+ENTER) doesn't work
    By Vbort44 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2008, 07:18 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1