Suddenly lost Copy Formula Above Keyboard shortcut

[Tommy737]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I always used Command ' (appostrophe) to copy the formula in the cell above. Today I suddenly get the time. I do not see how to reset this.
Please help

Thanks

 

[JE McGimpsey]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I always used Command ' (appostrophe) to copy the formula in the cell above.
Today I suddenly get the time. I do not see how to reset this.

Are you sure you're not typing CMD-; (the default keyboard shortcut for
inserting the time)?

 

[Guest]

Yes I am. CMD= gives me the date as does Control' (apostrophe)
CMD'
I just discovered that the culprit is Spellcatcher. If I change the input method to the US Flag I get the formula in the cell above.
Strange. I post on the Spellcatcher forum. Thanks

 

[Guest]

When I press command apostrophe it gives me the absolute formula above, I thought it would give me a relative formula. i.e. if I had A1+A2 in A3 and moved to B3 it should give me B1+B2, shouldn't it?

 

[CyberTaz]

Think of Cmd+' as the "ditto/duplicate command" - it inserts the same
content as what is in the cell above. IOW, it duplicates the above entry
which will be exactly the same content. It isn't a matter of absolute
reference because there is no "copying" involved.

The keystrokes you're looking for are CONTROL+D to fill down or CONTROL+R to
fill right. There are also fill left & fill up commands in the Edit> Fill
menu. They don't have default keystrokes but you can add them if you choose.

BTW: You can select an entire range of cells, enter the formula in the
first, then use the appropriate fill command rather than having to go from
cell to cell. Don't forget about the Fill Handle - it's a real handy feature
unless you're 99.9% anti-mouse

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Guest]

Thanks Bob.
I was just looking for an easy way to avoid selecting two cells: the one above and the current one.
I'll see what Spellcatcher has to say.

 

[CyberTaz]

You don't have to select 2 cells... Type your formula into the one cell,
press return, then key Ctrl+D or Ctrl+R it works as I understood you to
want. I only mentioned the additional info because many times there may be
several columns/rows which a formula need be copied to - doing it one cell
at a time as you work your way through 50 cells is hardly efficient if you
can copy it to all 50 at once, non?

Regards |:>)
Bob Jones
[MVP] Office:Mac