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!
Example-Worksheets.xlsx
ASKER CERTIFIED SOLUTION
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