Copying all formats from worksheet to worksheet

G

Gary

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?
 
S

Sheila D

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
 
Top