Menu
Helen Bradley - MS Office Tips, Tricks and Tutorials I'm a lifestyle journalist and I've been writing about office productivity software for a long time. Here you'll find handy hints, tips, tricks, techniques and tutorials on using software as diverse as Excel, Word, PowerPoint, Outlook, Access and Publisher from Microsoft and other applications that I love. My publishing credits include PC Magazine, Windows XP mag, CNet, PC User mag, SmallbusinessComputing.com, Winplanet and Sydney Morning Herald.
When pasting large data tables from your web browser into an Excel file you’ll probably be displeased to find that they do not match the formatting of the worksheet. By default Excel will paste the data with the formatting it used on the source web page instead. This is rarely useful, since it’s very unlikely the web page had formatting that is compatible with your document.
Hello, I have Microsoft Excel 2016 on a Mac. Is there a keyboard shortcut to use paste and match destination formatting? If there isn't one, could I possibly set one up? Thanks again. Word for Mac: How to set 'Match Destination Formatting' as default paste? There is a way to navigate the menus of Word and just set 'Match Destination Formatting' as the default. Then it applies to control-v and right-click-paste too. I set the mac system's command-v to 'Paste and Match Style' but it didn't work for word.
As you can see in the image above, using the source formatting can result in the inclusion of links, improper font and font size, and a number of other formatting issues. To make Excel paste the data with destination formatting (i.e. The formatting of the destination Excel worksheet), you’ll need to add a special command to your quick access toolbar. To do this, select File Options Quick Access Toolbar. Above the left column, select the Choose commands from dropdown and choose All Commands.
Scroll down the list and find Paste and Match Destination Formatting. Select it and click Add, then OK. Now whenever you wish to paste web data into Excel, click the Paste and Match Destination Formatting button in the Quick Access Toolbar instead of using the standard paste tool. This will result in the data being automatically formatted to match the look of the rest of your worksheet.
I don't believe there is a way to change the default. However, what I've found very convenient is to add the 'Paste Formulas' button (which will automatically keep the destination formatting) to the Quick Access Toolbar. To do this:. right click on the Quick Access Toolbar (the area in the top left with the Save, Undo and Redo buttons). click 'Customize Quick Access Toolbar.' . in the 'Choose commands from:' dropdown menu, select 'All Commands'.
![Default match destination formatting excel 2011 for mac mac Default match destination formatting excel 2011 for mac mac](https://d2d42mpnbqmzj3.cloudfront.net/images/stories/doc-excel/always-match-destination-formatting/xdoc-match-destination-formatting-3.png.pagespeed.ic.lqEi19G5IZ.png)
scroll down to 'Paste Formulas' and double click on it. click OK Now when you copy a cell or range, you can just use Alt+4 (assuming the new button is the fourth in the Quick Access Toolbar) to paste wherever you want and keep the destination formatting. According to the, there is no 'paste-matching-destination-theme', although you could paste just the values or formulas. Similar to the instructions found, you could add a macro to override the CTRL+V behaviour. Paste with ctrl+ V then hit ctrl to open a one key menu with formatting options. By default the letter is V to set the pasted information to the destination cell's former/proper formatting. A little weird that the ctrl+ V and ctrl, then V have such disparate effects, but nonetheless to past and keep the destination formatting: Copy cell or range of cells, paste to new locations using ctrl+ V like you would to move the source formatting, then hit ctrl then V to select a change from the current source formatting into the destination formatting.
Ctrl+ V, then ctrl, then V. A much quicker method than point and click.