Copy column headings AND formula totals to blank spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

katy - 09 Dec 2007 22:35 GMT

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

Reply to this Message

Gord Dibben - 09 Dec 2007 23:11 GMT

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

>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
[quoted text clipped - 8 lines]
>Thanks so much for any help!!!
>katy

Reply to this Message