troubleshooting Question

Paste Special - Match Destination Formatting

Avatar of Betsy Rempel
Betsy Rempel asked on
Microsoft ExcelMicrosoft Office
2 Comments1 Solution525 ViewsLast Modified:
I'm a grant writer, and I frequently export data from a grants tracking database into Excel. I have to reformat the sheet so that I can share the report with colleagues. I don't want to have to reformat the data each time I export. I set up a template, which has the headers I want for each column, and I formatted the cells which will contain numbers to a specific accounting format (no dollar sign and 0 decimal places), and in another column, I formatted the cells to present data as a percentage instead of decimal. When I cut and paste from the exported file to the template, it uses the source formatting. I want to match the destination formatting, but that option isn't included in Paste Special if I right click in the template file. I put the Match Destination Formatting icon into the Quick Access bar, but it is greyed when I try to paste, so I can't use it. The icon is active when I first open Excel, it greys out when I select cut. I've attached a file with two tabs - the exported data and the template. Any ideas of how to move the exported data into the template and match the destination formatting?  Thanks!
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros