I have an Excel spreadsheet with multiple worksheet tabs for collecting data… and a final tab with a lot of formulas, to summarize the other tabs for a given date range.
The goal is for the person doing data entry to keep this "master spreadsheet"… and distribute copies of only the summary tab.
You can't simply cut-n-paste the cells from that tab into a separate spreadsheet (or use "Edit->Move or Copy Sheet")… because that will copy over all the formulas. Those formulas will break when opened on another computer that doesn't have master spreadsheet.
On the other hand, using "Edit->Paste Special" and selecting only "Values" has problems too. This approach strips away not only the formulas, but also cell formatting (and there is quite a bit of formatting).
Is there any way to copy over cell values AND cell formatting from one worksheet tab to a separate spreadsheet file? I just want a visually-pleasing snapshot of that summary tab for distributing to other people.
Best Answer
Can you not make a template of the destination "summary" sheet and format it the same as the sheets you're taking the data from? so when you paste-special as values your destination sheet is already formatted and you don't need to copy across the formatting.