Clair knows how to create a copy of her worksheet, but she needs to create a copy that uses only static values, not values based on formulas.
Clair wonders if there is a quick way to make a copy (perhaps with a macro) that maintains all formatting and column widths, but has all formulas replaced with their results. For the work John does this would be very helpful in sending out worksheets to individuals outside her company
This task is rather easy to accomplish, with or without a macro. If you want to do it without a macro, follow these steps:
.
That's it. Your newly created worksheet doesn't contain any formulas, only the results of the formulas in the original worksheet.
This can also be performed with a macro
Microsoft Accredited IT Training Provider
Microsoft Certified Training Materials
IT Training Courses delivered by Microsoft Accredited Facilitators
Microsoft MOS Test Centre London
No comments:
Post a Comment