Powerpoint shortcuts

Here is the official list to learn. The main difference is Option is used instead of ctrl which is a little wierd since there is a CTRL key on modern mac systems:

Help and How-To for Microsoft for Mac Office Products | Mactopia

PowerPoint keyboard shortcuts

Here are the keys ones I useHelp and How-To for Microsoft for Mac Office Products | Mactopia

One character to the left

LEFT ARROW

One character to the right

RIGHT ARROW

One line up

UP ARROW

One line down

DOWN ARROW

To the beginning of a word or one word to the left

OPTION+LEFT ARROW

One word to the right

OPTION+RIGHT ARROW

To the end of a line

⌘+RIGHT ARROW or END

To the beginning of a line

⌘+LEFT ARROW or HOME

To the beginning of a paragraph or up one paragraph

OPTION+UP ARROW

Down one paragraph

OPTION+DOWN ARROW

To the end of a text box

OPTION+END

To the beginning of a text box

OPTION+HOME

Mac Excel function keys

Mac 101: Reclaim your function keys – The Unofficial Apple Weblog (TUAW)

The folks at Bitbox have described the simple steps needed to get some of that old flexibility back. First, launch system preferences and click the “Keyboard” tab. Next, select the “Use all F1, F2 etc. keys as standard function keys” option.

For Excel lovers, this gets you back to using the function keys the right way and also check the System Preferences/Keyboard Shortcuts and turn off F8-F12 in the Dock and Expose section

Mac Excel Shortcuts

It turns out that some of the commands in Mac Excel can’t actually be rebound. For instance, Allison, wants to have these work. Here is the list and how to get them Mac Excel. For Mac Excel 2001 we have a list.

Control + page up. This maps to Ctrl-Right which is find the next empty cell. On a Mac laptop there is no Page Up or Page Down keys, they only have arrow keys, so can’t remap these. Need to use an extended 101 keyboard for this to work. The Mac equivalent is Command-F6 and Command-Shift-F6 to go back a worksheet

The function keys are gotten by typing FN-F1 since the Mac uses the function keys for other things:

F2. This is so strange, with the Mac, it maps to Ctrl-U and there is no way to get F2 for EDIT and need a shortcut. You can get this with Quickeys
F4. This is Command-T on the Mac (“techjive”:http://www.techjive.net/2007/02/02/excel-keystrokes/). The only way to get this to work for Excel is some sort of shortcut. You can get this with Quickeys to map it.
F5. This is the Goto function and it works
F9. Recalc which is CMD-W The main issue is that normally Mac Excel makes F9 their own shortcut, so you have to turn off keyboard shortcuts for Expose.

Ctrl-R.Copy from the cell on left into this cell. This works in Mac Excel and is called the Right function
Ctrl-D. Copy from the cell above down to here.
Alt + =. Not sure what this does but on Mac, Alt keys actually puts in special character
Shift+F2. Insert comment. this works in Mac Excel
Alt+E, S, T. Opens the edit menu, then s choose paste specials and then format. You have to get this with Quickeys
Control + 1. Format Cells. Need to change in the Excel Keyboard Shortcuts since it is select object on the Mac and format cells is command-1.

Alt+I+C. Insert Column. Which I actually do as Ctrl-Space and then Ctrl-+, but you need a key remapper to do this.
Alt+I+R. Insert Row. Same thing, but it is actually Ctrl-Shift-Equal
Control+P. Works this is File/Print
Control+Y. This is redo and is mapped to Command-Y on the Mac, but Control-Y is unassigned, so use Excel to map
Control+Tab. This is next workbook. It works in Mac Excel. Note that Alt-Tab on the PC is Command-Taq on the Mac which you need Quickeys can’t remap

Some of my favorites are

Ctrl-$ for currency format. Works on Mac
Ctrl-% for perfentage. Works on Mac
Ctrl-Shift-Arrow. Select to the rigth

Ctrl-PgUp navigates through worksheets
Ctrl-PgDn navigates through worksheets.
Ctrl-Minus is Delect
Ctrl-Shift-Plus is Insert
Ctrl-* is fill in
Shift-Space selects a row
Ctrl-Plus inserts a row
Ctrl-Minus deletes a row

Four ways to make Mac simpler

Mac 101: Four simple ways to make your Mac more efficient – The Unofficial Apple Weblog (TUAW)

1. Easy access from the dock

I always drag my hard drive and Applications folder into the dock. No need to minimize windows, invoke Expose or, worst of all, shuffle windows around manually to reach the folder or file you want. Just click to reveal a speedy, hierarchical menu.

2. Learn some keyboard shortcuts

Mouse jockeys will balk, but memorizing even a few keyboard shortcuts will save you much time in the long run. For instance, most web browsers will select the address field with Command – L.

Things get even more fun with the Finder. Shift-Option-D brings up the Desktop Folder. Shift-Option-A presents the Applications folder. Command-M minimizes the frontmost window.

Is the dock in your way? Command-Option-D hides it away, and then calls it back. There are many shortcuts to choose from, but find the four or five that address the tasks you perform most often. Sure, it only takes a second to move from the keyboard to your mouse and back again, but seconds add up.

3. Embrace the menu bar

Several applications offer functionality that can be accessed from the menu bar. For instance, you can set your iChat status and even monitor which of your buddies are online without launching the application.

First, launch iChat and select “Preferences” from the iChat menu. Select “Show status in the menu bar” from the General tab. If someone initiates a chat with you, the application will launch in full and ask if you’d like to receive the invitation.

There are others, of course. Initiate a sync (for MobileMe customers) or Time Machine backup, alter display settings, select a wireless network or check the date and time without exiting the program or project you’re woring on. Many third party applications will let you interact with them via the menu bar as well.