Copy column headings AND formula totals to blank spreadsheet

[katy]

Hi Everyone! I apologize that this was likely asked before but could
someone show me how I can copy my 'column headings, column widths and totals
formula' to a blank spreadsheet tab? I have set up budget spreadsheet where
I input my receipts to keep track of monthly expenditures.

Could someone explain how to copy the column headings, the column widths,
AND the formulas of each column to a blank spreadsheet tab so each month
will contain the 'same headings, same column widths and the same formula for
each column'?

Thanks so much for any help!!!
katy

 

[Gord Dibben]

Assuming you already have a sheet that is formatted as you wish.

Right-click on the sheet tab and "move or copy". Select "create a copy" and ok.

With this copied sheet active, F5>Special>Constants.

Deselect "Text" and ok

Edit>Clear Contents which clears data but leaves formulas. You will probably
get errors where your formulas are depending whether or not you have trapped for
errors.

If you need more sheets just copy this one a few times before starting to pound
new data into it.


Gord Dibben MS Excel MVP