How to add new sheet and retain formulas

**kevphil** · 03-15-2013, 11:23 AM

I have a document which has formulas and content in the cells. I want to duplicate the 'sheet while retaining the same formulas, but without content in the cells, so I can start adding NEW content. This is a spreadsheet for annual expenses. I have one for 2012. Now I want to start a new one for 2013. I don't want to have to re-enter formulas that I already have in the 2012 'sheet. I know there's a (fairly simple) way to do this, but the person who showed me is no longer around.

Thanks for any help!

**Richard Buttrey** · 03-15-2013, 11:32 AM

Hi,

To copy the sheet right click the sheet tab and choose ' Move or Copy' and tick the 'Create a copy' option.
Then on the new sheet hit the F5 (Goto) key, select 'Special' then Constants, and ensure the 'Text' is unticked (otherwise you'll also be selecting headings and column/row label strings), then click OK. All the numeric constant cells will be selected, then just hit the Delete key.