Copying Excel
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
What if the Hokey Cokey IS what it's all about?