Ask Your Question

Can one copy a sheet to a new one and keep column widths & row heights? [closed]

asked 2015-07-02 19:34:54 +0100

MickBee gravatar image

updated 2020-08-11 17:33:54 +0100

Alex Kemp gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-11 17:35:03.612202

1 Answer

Sort by » oldest newest most voted

answered 2015-07-02 21:08:12 +0100

m.a.riosv gravatar image

Drag the sheet tab while press [Ctrl] and you get a copy of the sheet.

edit flag offensive delete link more


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

MickBee gravatar imageMickBee ( 2015-07-03 01:45:45 +0100 )edit

Question Tools

1 follower


Asked: 2015-07-02 19:34:54 +0100

Seen: 3,006 times

Last updated: Jul 02 '15