+ Reply to Thread
Results 1 to 4 of 4

Shortcut for Paste & Match Destination in Excel 365

  1. #1
    Registered User
    Join Date
    02-01-2016
    Location
    Evesham, England
    MS-Off Ver
    365
    Posts
    43

    Shortcut for Paste & Match Destination in Excel 365

    Can anybody tell me why Excel 365 has more clicks to accomplish a task than Excel 2013? For example, I always copy bits of information from an email and paste it into Excel. I used to just have a little shortcut icon on my Quick Access Toolbar that I would click once. Job done! Now, I have to click to select Paste options and then click again to choose which one. Or I have to Ctrl+V and Ctrl again to then click to make a selection. Why has this changed? All I want is one of the paste options as an icon on my Quick Access Toolbar. All you can add now is the whole Paste Special group. Does anybody know how to single out the one option I need and keep it as a single click icon?

    Surely it's not progress to have 2 or more clicks for a job instead of just 1! Or maybe all my Googling just hasn't come across the right answer yet. I really hope somebody here can help.

    Thank you all

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,913

    Re: Shortcut for Paste & Match Destination in Excel 365

    Nothing has changed. It's never was a default quick access toolbar menu.

    It was probably added by someone (IT or yourself).

    Go to Quick Access Toolbar -> More Commands -> All Commands and scroll down to Paste section, you should find the action you want there.
    Move it over to right (add).
    1.JPG

    You will see it outlined in white when it's available (i.e. when you copy data from outside of Excel)
    2019-08-19 13_41_19-Book1 - Excel.jpg
    Last edited by CK76; 08-19-2019 at 01:43 PM. Reason: Added screenshots.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    02-01-2016
    Location
    Evesham, England
    MS-Off Ver
    365
    Posts
    43

    Re: Shortcut for Paste & Match Destination in Excel 365

    Thank you for your quick reply. I knew it was never default, I had added it myself. I obviously didn't look properly and hadn't selected to view All Commands. I've found it now. THANK YOU

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,913

    Re: Shortcut for Paste & Match Destination in Excel 365

    You are welcome

    If answer is satisfactory, please mark the thread as solved using thread tools found at top of your initial post.

+ 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. [SOLVED] VLOOKUP paste all data from that row to destination if match [easy for most]
    By lougs7 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-24-2017, 03:20 PM
  2. Cgange default paste to match destination formatting
    By Gareth1000 in forum Excel General
    Replies: 1
    Last Post: 12-01-2016, 11:28 AM
  3. Copy from static destination & paste to dynamic destination
    By Marbleking in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-31-2015, 09:31 AM
  4. [SOLVED] Paste in "match destination format" macro code
    By Hopelesslylost in forum Excel General
    Replies: 6
    Last Post: 12-05-2012, 01:57 PM
  5. Excel VBA Paste Special - replace contents of destination cells
    By Sam via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2012, 12:44 PM
  6. [SOLVED] paste options - set default to match destination formatting
    By Amy in forum Excel General
    Replies: 1
    Last Post: 06-20-2006, 02:45 AM
  7. Replies: 1
    Last Post: 04-17-2006, 05:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1