ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to copy sheets keeping defined column widths (https://www.excelbanter.com/excel-worksheet-functions/8802-how-copy-sheets-keeping-defined-column-widths.html)

garpavco

how to copy sheets keeping defined column widths
 
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,
--
Cliff

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

"garpavco" wrote:

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,
--
Cliff



All times are GMT +1. The time now is 02:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com