+ Reply to Thread
Page 1 of 3 1 2 3 LastLast
Results 1 to 15 of 32

Right Click context recently changed by MS Update - Can I reverse?

  1. #1
    Registered User
    Join Date
    12-31-2019
    Location
    Indiana, USA
    MS-Off Ver
    Excel for Office 365 16.0.12325.20194 (64 bit)
    Posts
    1

    Right Click context recently changed by MS Update - Can I reverse?

    A recent MS Update appears to have changed the context menu in Excel 365. Right clicking a cell used to bring up a menu that had a box at the too with various format tools including Format Painter that I use frequently. That box now has much fewer choices which do not include Format Painter. Can this be fixed / changed?

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365 Insiders
    Posts
    11,298

    Re: Right Click context recently changed by MS Update - Can I reverse?

    Bump.___________
    Dave

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2019 (Win 10 - Work) & 365 Subscription Insider (Win 10 - Home)
    Posts
    35,343

    Re: Right Click context recently changed by MS Update - Can I reverse?

    I don't see any changes in recent updates. What have you updated from?

    When I first copy a cell, all of the paste and paste special (including paste format) options are there when I next right-click. I don't think that I have ever seen Format Painter on a right-click context menu in Office 365, but then I have never needed it because of the other paste options. To use Format Painter, click on the call to be copied, then on the Format Painter icon on the Home ribbon, then on the cell to be copied to.
    Attached Images Attached Images
    Last edited by AliGW; 01-03-2020 at 02:58 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365 Insiders
    Posts
    11,298

    Re: Right Click context recently changed by MS Update - Can I reverse?

    I don't recall format painter either.

    The option for merge and center (unmerge) is gone. I have used that one often to unmerge cells.

    I don't recall which update it occurred in.

    Edit BTW no I don't know of a way. I am following this thread because I want the answer, too.
    Last edited by FlameRetired; 01-03-2020 at 03:34 AM. Reason: added thought

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    6,170

    Re: Right Click context recently changed by MS Update - Can I reverse?

    I still get the format box, complete with Format painter & Merge & Center with 365
    Attached Images Attached Images

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2019 (Win 10 - Work) & 365 Subscription Insider (Win 10 - Home)
    Posts
    35,343

    Re: Right Click context recently changed by MS Update - Can I reverse?

    That's the Paste Format icon, not the Format Painter - not quite the same thing. The Paste Format icon also appears in my screenshot.

  7. #7
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2016 primarily
    Posts
    3,960

    Re: Right Click context recently changed by MS Update - Can I reverse?

    If you're talking about the mini toolbar at the top, then File - Options, General section, check the 'Show mini toolbar on selection' option.
    Rory
    Days when we raged, we flew off the page
    Such damage was done

  8. #8
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    6,170

    Re: Right Click context recently changed by MS Update - Can I reverse?

    Quote Originally Posted by AliGW View Post
    That's the Paste Format icon, not the Format Painter - not quite the same thing. The Paste Format icon also appears in my screenshot.
    The Format Painter is the paintbrush icon in the mini toolbar at the top.

    Quote Originally Posted by rorya View Post
    If you're talking about the mini toolbar at the top, then File - Options, General section, check the 'Show mini toolbar on selection' option.
    Checking, or unchecking that option makes no change for me when right clicking a cell.

  9. #9
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2016 primarily
    Posts
    3,960

    Re: Right Click context recently changed by MS Update - Can I reverse?

    It doesn't for me either, but I don't have the problem and it's the only setting related to that toolbar, so I took a guess.

    Although, re-reading the original post, it seems the toolbar is still there, just with fewer options.
    Last edited by rorya; 01-03-2020 at 10:10 AM.

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2019 (Win 10 - Work) & 365 Subscription Insider (Win 10 - Home)
    Posts
    35,343

    Re: Right Click context recently changed by MS Update - Can I reverse?

    Quote Originally Posted by Fluff13 View Post
    The Format Painter is the paintbrush icon in the mini toolbar at the top.
    [Just being pedantic, but ...]

    Your screen shot shows two icons: the one with the paintbrush is keep source formatting, the other is match destination formatting: https://support.office.com/en-us/art...c-42e8f83ffe71

    The format painter icon only appears on the Home ribbon: https://wmfexcel.files.wordpress.com...at-painter.png

    [/End pedantry]


  11. #11
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2016 primarily
    Posts
    3,960

    Re: Right Click context recently changed by MS Update - Can I reverse?

    You're looking at the wrong thing. Fluff's screenshot includes the mini toolbar above the context menu, and the bottom right icon on that is indeed the Format Painter.

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2019 (Win 10 - Work) & 365 Subscription Insider (Win 10 - Home)
    Posts
    35,343

    Re: Right Click context recently changed by MS Update - Can I reverse?

    Ooh, yes - I'm sorry, I didn't spot that! That menu box still appears for me, but with no format painter.

  13. #13
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    6,170

    Re: Right Click context recently changed by MS Update - Can I reverse?

    Maybe the OP is seeing this, which you get if you're in edit mode.
    Attached Images Attached Images

  14. #14
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    6,170

    Re: Right Click context recently changed by MS Update - Can I reverse?

    Quote Originally Posted by AliGW View Post
    That menu box still appears for me, but with no format painter.
    Is that with 365 or 2019?

  15. #15
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2019 (Win 10 - Work) & 365 Subscription Insider (Win 10 - Home)
    Posts
    35,343

    Re: Right Click context recently changed by MS Update - Can I reverse?

    No, I think he's seeing the same as me. I wonder if this is an insider issue? Dave and I are both on the insider programme - are you?

+ Reply to Thread
Page 1 of 3 1 2 3 LastLast

Thread Information

Users Browsing this Thread

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

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