how to copy sheets keeping defined column widths

G

garpavco

probably something simple; however, in an attempt to increase the size of my
spreadsheet, i've copied an existing worksheet to another, blank worksheet.
But, when the new sheet pastes, i find myself having to re-size the widths
every time. is there something i'm missing, or do i just have to re-size each
& every copy?
sincerely,
 
B

Bart Schouw

Garpavco try copying by selecting the whole sheet by clicking the upperleft
cell of the sheet (the one above and left of A1). Then also row and column
are selected and by that also their formats.

Good luck
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two columns followed by single page-width column on same page 0
Copying Portions of Data 0
Column widths in Excel 2013 16
Copy columns, but not hidden ones 3
Unable to set the desired column width for a table with merged cells 0
Unable to set the desired column width for a table with merged cells 0
protect sheet but column width changes 1
Cannot paste column data from one worksheet to another 2

Top