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.

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.

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.

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.