General discussion

Locked

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.

3 total posts (Page 1 of 1)  
| 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 -

Template

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.

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums