'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel for Mac Missing Keep Destination Formatting in Paste Special
Question details
Users are unable to find or use the Keep Destination Formatting option when pasting data between worksheets.
- Product
- Microsoft Excel
- Device & OS
- macOS
- Scenario
- Copying and pasting data between different worksheets or workbooks while trying to retain the formatting of the destination cells.
- Observed behavior
- The Keep Destination Formatting (or Match Destination Formatting) option is either missing from the Paste Special menu or appears disabled when added to the Quick Access Toolbar.
Check for any pending Microsoft Office updates, as missing features or grayed-out buttons are often resolved in newer builds of Excel for Mac. Also, ensure you have copied valid cell data before attempting to use paste options.
Look for Match Destination Formatting via Paste Options
In Mac versions of Excel, the feature is often named differently and located in the floating paste menu rather than the Paste Special dialog.
Microsoft changed the terminology in certain Mac builds. Instead of 'Keep Destination Formatting', the tool you are looking for is called 'Match Destination Formatting'.
Highlight the cells you want to copy and press Command+C.
Select your destination cell and press Command+V to paste the data.
Look for the small clipboard icon (Paste Options) that appears at the bottom-right of the pasted data and click on it.
Choose 'Match Destination Formatting' from the dropdown menu to apply the destination cell's format to the pasted text.
Use Paste Special Values and Format Manually
If the automated matching option is completely missing or disabled in your macOS build, you can paste the raw values and format them manually.
Create a VBA Macro for Quick Formatting
Automate the process by creating a simple VBA macro that pastes clipboard data as values, effectively mimicking the missing destination formatting tool.
Enjoy a Seamless Spreadsheet Experience on Mac with WPS Office
If missing features and disabled buttons in Excel for Mac are slowing down your workflow, consider switching to WPS Office. It provides robust spreadsheet functionalities, a highly familiar interface, and reliable copy-paste formatting options without the frustrating bugs.
- 1. Download WPS Office: Visit the official WPS Office website and download the macOS installation package.
- 2. Install and Launch: Run the installer, drag WPS Office to your Applications folder, and launch WPS Spreadsheets.
- 3. Open and Edit Safely: Open your existing Excel workbooks and enjoy reliable copy, paste, and formatting features immediately.
Frequently Asked Questions
Why is the Match Destination Formatting option grayed out on my Mac?
This usually occurs due to a limitation or bug in specific builds of Microsoft Office for Mac. It can also happen if the clipboard contains an unsupported data format or if you are attempting to copy between two entirely separate instances of the Excel application.
What is the keyboard shortcut for Match Destination Formatting in Excel for Mac?
There is no default single keyboard shortcut for this exact command on Mac. However, you can press Command+Option+V to open the Paste Special dialog, press 'V' to select Values, and press Enter to paste the text without the source formatting.
Can I add Match Destination Formatting to the Quick Access Toolbar?
Yes, you can customize the Quick Access Toolbar by navigating to Excel Preferences > Ribbon & Toolbar. Search for 'Match Destination Formatting' and click the arrow to add it. Note that in some macOS Excel versions, this button may remain disabled even after adding it, requiring you to use the Paste Options dropdown instead.
