Excel 2003 (for a change)

[THECORBYLOON]

I've used Excel 2003 to create a facing sheet and altered the width and heights of various cells. The cells contain names, DOB, NI No (the usual stuff) and I need a facing sheet for each person. I can insert worksheets and copy the format by selecting all worksheets but what I want to do is copy and paste the format onto the different pages on the same worksheet. If I try to do that, the format changes so is there another way?

Any help will be rewarded by payment of �10

(some parts of this may or may not be truthful)

[Yorkie580]

This site may help....

http://j-walk.com/ss/excel/usertips/index.htm

[THECORBYLOON]

Thanks for that but it looks like all I have to do is make sure I highlight the numbered portion as well as the cells. Not sure if it's clear what I mean)

Thanks again.