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 very much. That achieves around 50%. It certainly is solving the column width issue but the row heights are all the default single line. Surely it is possible to just copy and paste with the formatting.
Can't believe that MS overlooked something this basic but may be I am wrong.
The default single line row height is what I and many other users prefer. However, you can always select the range and click on Format, Cells, and select Wrap from the appropriate tab.
Again, many thanks. Unfortunately, Office 2000 does not offer previews of what the Paste Special options.
I will play around to find the solution, so that the next time, I will have forgotten it. However, after spending too much time on this, I have the column widths correct so will fix the row heights individually. As I said, not a large spreadsheet but would be nice to know how it should be done.
I don't know if Excel 2000 has a Paste Special option to fix the row heights, however, if you use the Format Cells option I mentioned, that should fix those. One alternative that is possible is to create a macro that will copy the sheet and preserve the existing row heights.