What are your favorite keyboard short cuts?

[RobMatthews]

I remembered another that i really like: while editing a formula, and the cursor is within a cell address, F4 scrolls thru various guises of absolute/relativity. (I think that's the right term...) That is, it puts $signs in various locations through the address. Nice and quick.

 

[Oorang]

Yah but you have to be careful with hotkeying relativity. If you accidentally hold down shift at the same time you could find yourself years from where you started!

 

[RobMatthews]

Yah but you have to be careful with hotkeying relativity. If you accidentally hold down shift at the same time you could find yourself years from where you started!

I don't follow you...?

 

[tbeards]

Yes, I use the F4 key ALL the time to lock down the entire cell, column or row!

 

[caringsharingbristolbilly]

Hi everyone - great thread! I'd never heard of F9 before, so that's proving a godsend already! Btw, for whoever said you have to ESC to get out of it, Ctrl+z does the same, so you can stay 'in' the formula to check more stuff out.

I've just bought Office:Mac to use at home, and I've been mortified by how few keyboard shortcuts there are in there. Out of interest, does anyone know of a list of Windows shortcuts and their Mac equivalents (if applicable)? That's something I'd love to read because Excel:Mac seems a bit cumbersome in comparison...

Thanks!
CSBBB.

 

[Oorang]

I don't follow you...?

Space/time joke (apparently not a funny one either).

 

[xld]

Space/time joke (apparently not a funny one either).

It made me laugh!

 

[Boller]

Out of interest, does anyone know of a list of Windows shortcuts and their Mac equivalents (if applicable)? That's something I'd love to read because Excel:Mac seems a bit cumbersome in comparison...

Have a look at :-

http://www.xvsxp.com/misc/keyboard.php

Mac must surely have a comprehensive listing of keyboard shortcuts in the Help file (like windows does).

 

[Domski]

Space/time joke (apparently not a funny one either).

I had to read it twice but it did make me chuckle

 

[RobMatthews]

Space/time joke (apparently not a funny one either).

Ok, see NOW i'm chuckling like a crazy woman with cats in the supermarket, wearing 4 skirts.