Ask Your Question

MickBee's profile - activity

2015-08-19 04:49:38 +0100 received badge  Famous Question (source)
2015-08-19 04:49:38 +0100 received badge  Notable Question (source)
2015-07-03 10:55:55 +0100 received badge  Popular Question (source)
2015-07-03 01:45:45 +0100 commented answer Can one copy a sheet to a new one and keep column widths & row heights?

Thank you - It's going to save me a lot of time. (Just a pity it's not obvious in the Help section.)

2015-07-03 01:44:32 +0100 received badge  Scholar (source)
2015-07-02 19:34:54 +0100 asked a question Can one copy a sheet to a new one and keep column widths & row heights?

I use a spreadsheet for monthly records, with different column widths & row heights. When I select the whole sheet and try to copy it to a new sheet (either using Paste or Paste Special) the column widths & row heights revert to standard and have to be adjusted individually.

Is there a way of copying the sheet formats so that the new sheet is an identical copy of the original?