Results 1 to 9 of 9

Thread: exiting array formula evaluation mode
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2011
    Posts
    1,414
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default exiting array formula evaluation mode

    To see the evaluation of an array formula, one can highlight the array formula and hit F9. Hitting ESC should exit the evaluation mode and go back to display the array formula. It has happened to me a few times that ESC doesn't show the array formula. I was stuck in the evaluation mode. Any way out?
    Excel 2010, Windows 10

  2. #2
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,422
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: exiting array formula evaluation mode

    Hi,

    You can test Ctrl Z

    Hope this will help

  3. #3
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    40,976
    Post Thanks / Like
    Mentioned
    90 Post(s)
    Tagged
    21 Thread(s)

    Default Re: exiting array formula evaluation mode

    I have not experienced that or know what might cause it. If it happens, does clicking the 'X' formula bar button to the left of the formula bar take you back out?
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the # key in the Reply window
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  4. #4
    Board Regular
    Join Date
    Jun 2011
    Posts
    1,414
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: exiting array formula evaluation mode

    Ctrl-Z doesn't work. Clicking "X" doesn't work.

    OK. Sorry for the misinformation. Undo works to get the array formula back.
    Last edited by yky; Aug 26th, 2019 at 11:03 AM.
    Excel 2010, Windows 10

  5. #5
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,422
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: exiting array formula evaluation mode

    Thanks for the info

  6. #6
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,276
    Post Thanks / Like
    Mentioned
    471 Post(s)
    Tagged
    47 Thread(s)

    Default Re: exiting array formula evaluation mode

    Ctrl Z works for me, but you may need to do it a few times, depending on what other changes you made
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  7. #7
    Board Regular
    Join Date
    Jun 2011
    Posts
    1,414
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: exiting array formula evaluation mode

    This is how I get into trouble.

    Select an array formula or a portion of it, hit F9 to display the evaluation, copy the evaluation, select a cell and paste the evaluation.

    This way, when going back to the formula bar, I have found no way of getting the array formula back except doing undo. However, undo erases the pasted evaluation. So, the net result is just a waste of time.

    To paste evaluation, after copying, one needs to hit ESC or Ctrl-Z to get the array formula back first and then paste. Otherwise, you either lose the pasted evaluation or the array formula. Can't have both of them at the same time.
    Excel 2010, Windows 10

  8. #8
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    40,976
    Post Thanks / Like
    Mentioned
    90 Post(s)
    Tagged
    21 Thread(s)

    Default Re: exiting array formula evaluation mode

    OK, post 1 didn't mention anything about copy - leave cell - paste - return to cell so I certainly thought the issue was a different one.

    In any case, this is the simple solution for you isn't it?
    Quote Originally Posted by yky View Post
    To paste evaluation, after copying, one needs to hit ESC or Ctrl-Z to get the array formula back first and then paste.
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the # key in the Reply window
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  9. #9
    Board Regular
    Join Date
    Jun 2011
    Posts
    1,414
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: exiting array formula evaluation mode

    Yes. Need to make a habit of hitting ESC or Ctrl-Z before pasting.
    Excel 2010, Windows 10

Some videos you may like

User Tag List

Tags for this Thread

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
  •