Copying all formats from worksheet to worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top