What are your favorite keyboard short cuts?

[xld]

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

Must be an Oz thing

 

[arkusM]

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.

IMO, Microsoft is a **** poor job at the Office's for Mac. (ive had a couple). I have used other programs on both platforms with little noticable differences, but Excel is terriable to use cross platform.

BTW, I am a Mac user at home and PC at work.

Cheers.

 

[caringsharingbristolbilly]

IMO, Microsoft is a **** poor job at the Office's for Mac. (ive had a couple). I have used other programs on both platforms with little noticable differences, but Excel is terriable to use cross platform.

BTW, I am a Mac user at home and PC at work.

Cheers.

Yeah, I've found the same. I was using Neo Office and Open Office beforehand but was getting frustrated trying to share documents between Open Office Writer and Word - it couldn't translate the graphics effectively. So, I bought Mac:Office 2008 through work for £8. Word is fine, but Excel almost seems to be deliberately obtuse to make you want to buy Windows instead (which, for me at least, ain't gonna happen). And don't even get me started on the lack of VBA support.

Thanks for your link, Boller - really handy! I've not investigated many of the shortcuts in OSX yet (I'm quite new) but that list will be really handy...

 

[BC...]

Alt+D+F+F - toggle autofilters
Alt+E+S+V - paste values
Alt+E+S+V+E - paste values transposed

 

[Sandeep Warrier]

F4 - repeat last action... works a charm when I need to get a lot of formatting done.

Select range.. F2 + Ctrl + Enter... works like Ctrl+D but without formatting.

Alt+;
Alt+E+S+V

Ctrl+Shift+P... selects font size in formatting toolbar
Alt and then Ctrl+Tab.... cycles thru various toolbars

Alt+D+P... Pivot Table Wizard
Alt+W+F... Freeze/Unfreeze panes...
Alt+I+N+D... Define Name

etc
etc
etc


For anyone using ASAP Utilities...
Alt+A+T+E - remove leading, trailing and excessive spaces
Alt+A+R+E - empty duplicates in selection (leave 1st value)

 

[jeffreybrown]

Can anybody tell me what the shortcut is to have Excel copy a formula in a format that will work in VBA. I remember using it before but just can't remember what or how. Something about while on a cell with a formula, select F2 to enter the editing and then select another shortcut, hit enter and paste the results into VBA. Just can't remenber this one...but I remember it was helpful...!

 

[SydneyGeek]

Start the recorder
Select the cell
F2 then Tab
Stop the recorder

Denis

 

[jeffreybrown]

Thanks Denis...I guess I was missing a very important step...yes of course the record.

Many thanks,

 

[Ron Coderre]

I use many of the keyboard shortcuts already listed...
but, I don't think I've seen this one mentioned yet.

Note: it takes a tiny bit of set-up.

I jealously guard my Windows taskbar real estate and don't want any of
it wasted with the Quick Launch toolbar. If you're a keyboard person
(like I am), use this to open up to 10 of your favorite apps instantly:

• Rename the START menu items you use most so they begin with a number.
(Right click on the item...select Rename)

Here are some of mine:
0_Windows Explorer
1_Email
2_MS Access
3_Excel
4_Word
5_Internet Explorer

Now...to open any one of those programs...
• Press START then press the digit

eg Press START then Press 3... to open Excel (on my PC)

As long as no other start menu items begin with the same character,
the app will start immediately. Otherwise, each time you press the digit,
the next app with that number will be selected. Press ENTER for the one you want.

 

[Ron Coderre]

Darn...that 10 minute editing limit is annoying.
It's WINDOW key (Not START)....Digit key