Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
garpavco
 
Posts: n/a
Default 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
  #2   Report Post  
Bart Schouw
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy COLUMN from 1 worksheet to another (in a different workbook) DavidB Excel Discussion (Misc queries) 3 January 15th 05 02:47 PM
Linking sheets when sorting row and column data Sean 3DD Excel Worksheet Functions 0 January 5th 05 12:21 PM
Vary the column widths for different rows Marty Excel Discussion (Misc queries) 2 January 4th 05 11:08 PM
how to copy 2350 hyperlink full paths to any column in a worksheet ? kontiki Excel Discussion (Misc queries) 4 December 10th 04 10:00 PM
getting data from 2 excel sheets automatically pinar Excel Worksheet Functions 0 November 9th 04 11:47 AM


All times are GMT +1. The time now is 07:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"