You dont say which version you are using but Excel 2k+ has an option on Paste
Special to Paste Column Widths. Alternatively if you copy the entire sheet by
clicking the box above row 1 and to the left of Column A it will paste
everything 'as is'

HTH

Sheila

"Gary" wrote:

How do I copy the header row from one tabbed worksheet such that it will
paste all formats, ESPECIALLY CELL WIDTH, to each tabbed worksheet?