+ Reply to Thread
Results 1 to 5 of 5

Canned Reply - Array Formulas

  1. #1
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Canned Reply - Array Formulas

    Hi,

    Since when did my footer re array formulas - which I've been using for probably 7/8 years - become a canned reply?!

    I'm happy that it's being used - just surprised that I wasn't even consulted!

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,777

    Re: Canned Reply - Array Formulas

    Do you mean this?
    **Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself)
    I noticed someone had swapped the old text we used to use recently, but I’m afraid I don’t know who it was. I am very sorry whoever ‘borrowed’ your wording did not ask first.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Canned Reply - Array Formulas

    Oh, well. It's not like I have copyrights on the phrase!

    Thanks for replying.

    Regards

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,911

    Re: Canned Reply - Array Formulas

    Might want to add a note that some newer versions don't require that?
    Rory

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,777

    Re: Canned Reply - Array Formulas

    Not sure that's really necessary - we don't mention this if it's a newer version of Excel.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Reply button over quick reply is misleading and causing frustration
    By pharmacologist in forum Suggestions for Improvement
    Replies: 2
    Last Post: 10-07-2019, 03:45 PM
  2. Replies: 64
    Last Post: 06-25-2018, 11:18 AM
  3. [SOLVED] Canned Replies: Array Formula statement is inaccurate
    By Tony Valko in forum Suggestions for Improvement
    Replies: 10
    Last Post: 07-20-2015, 10:29 AM
  4. Canned reply links to a photo album
    By ConneXionLost in forum Suggestions for Improvement
    Replies: 5
    Last Post: 07-04-2013, 03:53 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1