Ask Your Question

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

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

MickBee 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 close merge delete

1 Answer

Sort by » oldest newest most voted

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

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 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 2,581 times

Last updated: Jul 02 '15