Copying A Workbook Format

  • Thread starter Thread starter FLtan1
  • Start date Start date
F

FLtan1

Hi All !

I have a workbook that has multiple columns and multiple
rows. Many of the columns include formulas.

Is there a way to copy the workbook format including the
formulas and column headings but NOT the data in the
rows/columns.

I have tried highlighting and deleting the cell contents
and saving the workbook under another name. It keeps the
column headings, but I lose the formulas.

Thanks to anyone who is able to solve this dilemna
 
You can copy the worksheet. Edit|Move or Copy Sheet to copy the whole sheet.

Then on the new sheet:
ctrl-A to select all the cells
Edit|Goto Special|Constants
then hit the delete key to clear contents.

But if you have headers that you want to keep, just select the range (say rows
3:xxxx and columns B:IV) and do the edit|goto stuff.
 
Back
Top