What ho one and all,

Getting my knickers in s twist regarding copying some information within Excel.

I have a small, two worksheet spreadsheet, and wish to add a third worksheet. This third worksheet will have sheets one and two, copied into one worksheet and then I will alter it. Seems easy, but I guess I am doing something wrong.

If I highlight and Cnt+C the data in w/s one, move to w/s three and paste, all the information is copied but none of the formatting. Whilst there is not a lot of information, I really don't want to have to set column and row heights / widths individually.

Surely there is a way to copy from one to the other that includes format data. Paste Special is not doing it. I don't image it makes any difference but I am using Office 2000.

Thanks

Rex