Copying all formats from worksheet to worksheet
 

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?

Copying all formats from worksheet to worksheet
 

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?