Web Development

Ask something
Discussion Locked

Excel- new worksheet without data

0 helpful
3 replies

by c.webb

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a 2004 sheet with data, formulas and formatting. How can I create a 2005 one, keeping everything except the 2004 data? Paste special doesn't offer this option,

3 replies

by liame

Paste special is the tool... you just need to paste several times.

Just don't paste all, values, all except borders and values and number formats.

Once you have run through the others you should have everything you need to start over.

by unencrypted

Create an Excel template based on the 2004 sheet. To do this, simply remove all the data (leaving the formulas in place) then save as Template.

This discussion is closed to new replies.