General discussion


Excel- new worksheet without data

By c.webb ·
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,

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Paste special...

by LiamE In reply to Excel- new worksheet with ...

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.

Collapse -

Replay -Excel- new worksheet without data

by sreejith_15 In reply to Excel- new worksheet with ...

Hi ,

Do open with 2005 Sheet.

Collapse -


by unencrypted In reply to Excel- new worksheet with ...

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.

Related Discussions

Related Forums