Forum Discussion
trying to dulicate with differant data
I made an beautiful table with all the formulas and formatting I wanted. Now my sister wants me to do the same thing but with different values but same parameters. how do I copy everything in my table except the values?
3 Replies
- Highlight your area, copy, when you paste, right click and select Formula.
All that does is duplicate the formulas not the formating and header
Formatting is the easiest part, use Format Painter for that (select entire table, click on Format Painter and apply to another table).
I'm not sure about formulas - when you copy mix of values and formulas and when Paste->Formulas it inserts values from first table (not calculated ones) as well. Tthe single value is also the formula after all.
