| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Column width
I have created a blank form which I need to copy to Sheet 2,3,4..., in a Workbook. When I copy the original sheet the formating (column width) returns to the Excel default width. What am I missing? Bob M. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Column width
After you pasted, right click, select paste special, tick Column Widths, and
OK out. -- Hth Kassie Kasselman Change xxx to hotmail "robert morris" wrote: I have created a blank form which I need to copy to Sheet 2,3,4..., in a Workbook. When I copy the original sheet the formating (column width) returns to the Excel default width. What am I missing? Bob M. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Column width
Kassie, Thank you, Thank you, Thank you. Bob M. "Kassie" wrote: After you pasted, right click, select paste special, tick Column Widths, and OK out. -- Hth Kassie Kasselman Change xxx to hotmail "robert morris" wrote: I have created a blank form which I need to copy to Sheet 2,3,4..., in a Workbook. When I copy the original sheet the formating (column width) returns to the Excel default width. What am I missing? Bob M. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Column width
Glad I could help!
Kassie Kasselman Change xxx to hotmail "robert morris" wrote: Kassie, Thank you, Thank you, Thank you. Bob M. "Kassie" wrote: After you pasted, right click, select paste special, tick Column Widths, and OK out. -- Hth Kassie Kasselman Change xxx to hotmail "robert morris" wrote: I have created a blank form which I need to copy to Sheet 2,3,4..., in a Workbook. When I copy the original sheet the formating (column width) returns to the Excel default width. What am I missing? Bob M. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy column width along with data?? | Excel Discussion (Misc queries) | |||
| how do I create multiple column width in the same column in excel | Excel Discussion (Misc queries) | |||
| How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
| copy formats column width & row heights between Excel WORKSHEETS? | Excel Discussion (Misc queries) | |||
| Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Linear Mode
