I'm using Excel 2000. If I have a cell with contents "=C4+D4" (w/o quotes, of course) the spreadsheet shows a value (say 7). If I select the cell and copy it, I get a cell whose content is "7" (again, no quotes). That is to say, Cntrl-C and Cntrl-V is not copying and pasting the formula, it's copying pasting the value computed by the formula. It wasn't always like this - copying formulas used to work, and I have no idea what's changed. I even tried unintalling and reinstalling Office 2000 but the problem remains.
Selecting the cell and then dragging the little box in the corner works for contigous blocks (thanks for the tip), but the general problem of copying formulae remains.
Any thoughts on this?