[1L]

>> Cell heights are automatically and randomly expanded or compressed whenever I paste cut or copied cells.<<

This isn't a bug. Do Edit/Paste Special/Text (or unformatted text, as the case may be).

>>Fonts seem to change on their own as well during similar operations. <<

Never had this happen that I recall. Can you give me a specific example?

>>And when I try to set the font back to what it was, it doesn't take (I'll save the spreadsheet, only to find the wrong font when I open it again).<<

Again, never had this happen personally. Did it happen once or it is a regular occurance? Does it happen like this all the time, or just on selected sheets?

What version are you using?

I think Word is one of the most buggy pieces of software being sold commercially, but I don't think the same of Excel. I can't remember one bug I've ever experienced with the program, and I've used it practically to its limits.

[LIConFem]

I'm using Excel 2003.

"This isn't a bug. Do Edit/Paste Special/Text (or unformatted text, as the case may be). "

Yeah, it is a bug. It's even listed on the MS Office support site as such.

">>Fonts seem to change on their own as well during similar operations. "

Sure. I copied a group of about 10 rows, created a new worksheet and pasted them to it. The font size was suddenly 16 point, rather than 8. Tried to change it... didn't work. As for whether this is a regular occurance, all I can tell you is that it has happened to me at least twice.

Yes, Word is pretty horrible as well, especially the table functions.

[savedbygrace]

A company I do work for has an Excel spreadsheet this is used as a template to produce price quotes for their clients. Several of the columns contain formulae to calculate prices and dealer profit, etc. (The dealer pricing and profit columns are hidden from print, naturally.)

If you start adding items with their associated pricing as you go, then later need to rearrange the items in a logical order, the formulae and the fonts get messed up. There appears to be no useful method to do this, other than selective cell copy/move that takes forever. No easy and simple way to do this in Excel. It is a royal pain in the backside.