Erase data, preserve formula's

I have a an excel file with 12 worksheets for the financial year and an
additional worksheet for yearly totals.

I need to get a blank copy of this and was wondering if anyone knew a
way to delete all the user inputted data while keeping the formatting
and formula's intact.

Any help is much appreciated.


-- 
urbanfox
------------------------------------------------------------------------
urbanfox's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=22826
View this thread: http://www.excelforum.com/showthread.php?threadid=519004

0
3/4/2006 5:16:17 PM
excel 39879 articles. 2 followers. Follow

3 Replies
533 Views

Similar Articles

[PageSpeed] 42

Hi

Hit F5 and select Special and then Constants. You can then decide whether to 
keep certain bits or not.
Make a backup before you start!!

Andy.

"urbanfox" <urbanfox.245nva_1141492801.1352@excelforum-nospam.com> wrote in 
message news:urbanfox.245nva_1141492801.1352@excelforum-nospam.com...
>
> I have a an excel file with 12 worksheets for the financial year and an
> additional worksheet for yearly totals.
>
> I need to get a blank copy of this and was wondering if anyone knew a
> way to delete all the user inputted data while keeping the formatting
> and formula's intact.
>
> Any help is much appreciated.
>
>
> -- 
> urbanfox
> ------------------------------------------------------------------------
> urbanfox's Profile: 
> http://www.excelforum.com/member.php?action=getinfo&userid=22826
> View this thread: http://www.excelforum.com/showthread.php?threadid=519004
> 


0
Andy
3/4/2006 5:24:02 PM
The special button is greyed for me.


-- 
urbanfox
------------------------------------------------------------------------
urbanfox's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=22826
View this thread: http://www.excelforum.com/showthread.php?threadid=519004

0
3/4/2006 9:14:15 PM
Is your sheet/workbook protected?

Andy.

"urbanfox" <urbanfox.245yqy_1141506900.9035@excelforum-nospam.com> wrote in 
message news:urbanfox.245yqy_1141506900.9035@excelforum-nospam.com...
>
> The special button is greyed for me.
>
>
> -- 
> urbanfox
> ------------------------------------------------------------------------
> urbanfox's Profile: 
> http://www.excelforum.com/member.php?action=getinfo&userid=22826
> View this thread: http://www.excelforum.com/showthread.php?threadid=519004
> 


0
Andy
3/4/2006 9:24:36 PM
Reply:

Similar Artilces: