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 Shortcuts

Here is the official list from Microsoft

The strange things are they are different. For instance F4 is paste whereas in Windows Excel is it change relative to absolute. And F2 is edit cell whereas it is cut text. And again, there is this strangeness that you use the Option key where you use the Ctrl key in windows even though there is a Ctrl key on new Mac keyboards.

Equivalent of Windows Excel F4 key in Excel 2008 for the Mac

Navigating in Excel
Switch between Worksheets fn-CTRL-PageUp/fn-CTRL-PageDown
Switch between Workbooks fn-`
Select entire worksheet Cmd+A
Move to the beginning of the line. fn+left arrow(home)
Go To fn + F5
Move a Sheet/Copy a Sheet Alt-E-M
Change Zoom Sizing Alt-V-Z

Entering and editing data
Complete a cell entry and select…
Delete cell and then get inside the cell DELETE
Delete cell/selection. fn+DELETE
Edit inside a cell (edit cell mode) CTRL+U
Once inside edit cell mode (F2)…
…Start a new line in the same cell. OPTION+CMD+ENTER
…Delete the preceding character. DELETE
…Delete the character to the right of the insertion fn + DELETE
Spell Check. fn + F7
Insert a comment. fn+SHIFT+ F2
Undo the last action. cmd+z
Redo the last action. cmd + y

Selecting, grouping, inserting, and deleting cell
Group Rows or Columns SHIFT+ALT+RIGHT ARROW KEY
Ungroup Rows or Columns SHIFT+ALT+LEFT ARROW KEY
Clear the contents of the selected cells. DELETE
Delete the selected cells. CTRL+MINUS SIGN SAME
Insert blank cells. CTRL+SHIFT+PLUS SIGN SAME

Copying and Pasting Shortcut
Copy, then Paste Special Formats Alt-E+S+T
Copy, then Paste Special Formulas Alt-E+S+F

Formatting Data Shortcut Example
Display the Style dialog box. CMD+SHIFT+L
Display the Format Cells dialog box. CMD+1
CTRL+SHIFT+! 1,254.34
Currency format: 2 decimal places (negative numbers in parentheses): CTRL+SHIFT+$ $1,254.34
Percentage format with no decimal places. CTRL+SHIFT+% 125434%
Exponential number format with two decimal places. CTRL+SHIFT+^ 1.25E+03
Boldface CMD+B
Italicize CMD+I
Underline CMD+U
Strikethrough CMD+SHIFT+_
Apply the outline border to the selected cells. CMD+Option+Arrow Key
Remove the outline border from the selected cells. CMD+Option+Arrow Key

Enter and calculate formulas Shortcut Example
Start a formula. = (equal sign) =F45*G12
In a formula, display the Insert Function dialog box. fn+SHIFT + F3
Recalculate all worksheets in all open workbooks. F9
Anchoring “Fixing” Cells F4 – must be in edit cell mode (CTRL+U) =$F$4*G125
Go to precedent cell(s) CTRL-[

Naming cells, Hyperlinks, inserting time and dat
Name a cell. fn+CMD+F3
Display a drop-down list of the values in the current cALT+DOWN ARROW

What if a player wants to drop?

If someone is playing and they decide they don’t want to play.

# If it is after September 1 there is no refund
# Click on the league
# Choose Edit/Registant and type in their name
# You should find them and click on them
# Now to quick click for participants and seach for that team
# find the person and click on the right arrow to deassign them and press ok
# Got back to Edit/Registrant and type in the name
# Click on financial information for participant
# Click on reject

PowerPoint Shortcuts compatibility

Most people never use a shortcut in PowerPoint, but I learned from the original PowerPoint ninja Gary. It is way faster to be able to navigate by keys than to select. I’m sure Mac PowerPoint doesn’t support most of these. For instance, the key paragraph promote and demote are not, so its another project for Quick Keys or Applescripts to do some keyboard remapping

PowerPoint Keyboard Shorcuts

Change Font CTRL+Shift+F, then use up/down arrow keys, click Enter when done
Change Point Size CTRL+Shift+P, then use up/down arrow keys, click Enter when done
Increase Font Size CTRL+Shift+>
Decrease Font Size CTRL+Shift+<
Bold CTRL+B
Underline CTRL+U
Italic CTRL+I
Superscript ALT+CTRL+Shift+>
Subscript ALT+CTRL+Shift+<
Plain Text CTRL+Shift+Z
Spelling Checker F7
Center Paragraph CTRL+E
Justified Paragraph CTRL+J
Left-Aligned Paragraph CTRL+L
Right-Aligned Paragraph CTRL+R
Change Case Shift+F3 toggles selection through lower case, upper case, initial caps with each press of keys
Create Hyperlink CTRL+K
Deleting and Copying
Delete Character Left Backspace
Delete Word Left CTRL+Backspace
Delete Character Right Delete
Delete Word Right CTRL+Delete
Cut CTRL+X
Copy CTRL+C
Paste CTRL+V
Undo CTRL+Z
Create a copy of the text CTRL+Drag
Navigating in Text Blocks
Character Left Left Arrow
Character Right Right Arrow
Line Up Up Arrow
Line Down Down Arrow
Word Left CTRL+Left Arrow
Word Right CTRL+Right Arrow
End of Line END
Beginning of Line HOME
Paragraph Up CTRL+Up Arrow
Paragraph Down CTRL+Down Arrow
End of Text Block CTRL+END
Start of Text Block CTRL+HOME
Navigating and Working With Objects
To Previous Object TAB
To Next Object Shift+TAB
Select All Objects CTRL+A
Drag and Drop Copy CTRL+Select and Drag
Create a Duplicate Object CTRL+D
Create another Duplicate with same offset as first Duplicate CTRL+D, move new copy to desired location, then use CTRL+D repeatedly to create more copies
Outlining, in All Views
Promote Paragraph ALT+Shift+Left Arrow or
TAB from beginning of Paragraph
Demote Paragraph ALT+Shift+Right Arrow or Shift+TAB from beginning of Paragraph
Move Selected Paragraphs Up ALT+Shift+Up Arrow
Move Selected Paragraphs Down ALT+Shift+Down Arrow
Outlining, in Outline View
Collapse to Titles ALT+Shift+1
Expand Text under a heading ALT+Shift+Plus
Collapse Text Under a Heading ALT+Shift+Minus
Show All Text and Headings ALT+Shift+A
Display Character Formatting Keypad / (numlock off)
Selecting, in Text
Character Right Shift+Right Arrow
Character Left Shift+Left Arrow
End of Word CTRL+Shift+Right Arrow
Beginning of Word CTRL+Shift+Left Arrow
Line Up Shift+Up Arrow
Line Down Shift+Down Arrow
Select All CTRL+A or F2
Select Any Text Drag with left mouse button depressed
Select Word Double-Click
Select Paragraph Triple-Click
Drag and Drop Select and Drag
Drag and Drop Copy CTRL+Select and Drag
Working with Slides and Presentation Files
New Presentation CTRL+N
Open a Presentation CTRL+O, CTRL+F12
Save CTRL+S, F12
Save As F12
Print CTRL+P
Find CTRL+F
Replace CTRL+H
New Slide (menu) CTRL+M
New Slide like last one, no menu Shift+CTRL+M
Exit/Quit CTRL+Q or ALT F4
Move from Title to Text CTRL+Enter
Move from Body text to Title of Next Slide CTRL+Enter
Working with Presentation Windows
Go to Previous Window CTRL+Shift+F6
Go to Next Window CTRL+F6
Size Presentation Window
(Un-Maximize) ALT+F5
Maximize Application Window ALT+F10
Maximize Presentation Window CTRL+F10
Restore Presentation Window to Previous Size CTRL+F5
Put Presentation in its own Window CTRL+F5
Drawing & Formatting
Show/Hide Guides (toggle) CTRL+G
Switch from Normal View to Master View Shift+Click Slide View Button
Group CTRL+Shift+G
Ungroup CTRL+Shift+H
Regroup CTRL+Shift+J
Resize while Maintaining Proportions Shift+Resize
Resize from Center CTRL+Resize
Resize from Center while Maintaining Proportions CTRL+Shift+Resize
Rotate in 15 degree increments Shift+Rotate tool
Rotate from Corner CTRL+Rotate tool
Rotate in 15 degree increments from Corner Shift+CTRL+Rotate tool
Extend Line along same angle Shift+Resize
Make Straight Segment while Using Curve Tool CTRL+ALT+click (using curve tool)
Nudge object one grid unit Arrow Key
Nudge object one pixel CTRL+Arrow Key
Temporarily Release Grid/Guide Snap ALT
Create Multiple Guides CTRL+Drag Guide
Controlling Slides in Slide Show
Go to Slide ENTER
Black/Unblack Screen B or Period
White/Unwhite Screen W or Comma
Show/Hide Pointer A or =
End Show ESC, CTRL+Break, Minus, END
Erase Screen Annotations E
Advance to Hidden Slide H
Advance to Next Slide Mouse Click, Spacebar, N, Right Arrow, Down Arrow, Page Down
Return to Previous Slide Backspace, P, Left Arrow, Up Arrow, Page Up

PC Office Compatibility mode for Mac Office

One of the maddening things about the Mac Office 2004/2008 line is that it is not keystroke compatible with Windows Office. I don’t know why they don’t have a compatibility mode so that for instance Ctrl-+ works (this is insert) or Ctrl– (this is delete) or Shift-Space which is select row, but they don’t. The same with Mac PowerPoint. Ctrl-Right Arrow doesn’t promote. Well, time to go build it. Allison hates it and asked for it, so here is a feature I’ll sell to Microsoft for $20M. Here is the poor man’s way to get keystroke compatibility. (It is way easier than the last time 20 years ago when the analogous feature, 1-2-3 keystroke compatibility was such a big deal for PC Excel. First memo I ever sent up the chain and the memo that should have gotten me fired if Microsoft had been such an extraordinary company back then).

Here is how to do it:

h2. Excel Keystroke Shortcuts

First you need a list of the keystrokes. Amazingly, “Excel”:http://blogs.msdn.com/excel/archive/2006/02/23/538311.aspx has 214 keystroke shortcuts available. It is just for basic editing! So that’s the list that you need. There are some that they are trying to get rid of but everyone needs them. BTW, I’m shooting for Excel 2003 and below compatibility. Excel 2007 of course changed lots of things which I don’t need to fix. Or argue about for that matter.

He has his favorites which are also mine:
* Ctrl + Page Up and Ctrl + Page Down – previous/next worksheet
* Shift + Space – select row
* Ctrl + Space – select column
* Ctrl + 0 – hide column
* Shift + Ctrl + 0 – show column
* Ctrl + 9 – hide row
* Shift + Ctrl + 9 – show row
* Ctrl + ‘ – Copy above cell and edit
* Alt + Down – Open drop-down (auto-complete, filter, pick from list, or validation)
* Ctrl + / – Select Array
* F9 – Calculate
* Shift + F9 – Calculate sheet (in the active workbook)

Then, there are a whole group that relate to selection in Excel – selecting ranges, navigating selection, etc. By way of background, Excel has a few selection “modes” which you can turn on and off. “Extend selection mode”, when turned on, simply expands selection from the active cell when you move around using the mouse or keyboard. “Add selection mode” adds to existing selection when you select cells (using either the mouse or toggling on “Extent selection mode”). These are handy for keyboard-intensive users. Here are some examples.

* F8 – Extend selection mode
* Shift F8 – Add selection mode
* Shift + Backspace – Collapse selection to the active cell
* Ctrl+ Backspace – Show active cell (particularly handy if you have a large range selected and the active cell is off the screen)
* Ctrl + Alt + Left Arrow – Move active cell to previous non-adjacent area within selection (when you have discontinuous ranges selected)
* Ctrl + Alt + Right Arrow – Move active cell to next non-adjacent area within selection (again, when you have discontinuous ranges selected)
* Ctrl + . – rotates the active cell through the corners of a selection
* Enter – move active cell down in a selection
* Shift + Enter – move active cell up in a selection

On to the more esoteric items. Here is one that is less-frequently-used since we added formula tooltips (the tooltips that show the arguments of a formula as you type), but it can still come in handy.

* Shift + Ctrl + A – Insert arguments in formula

And here are a couple of my true favourites which allow you to quickly navigate the “calculation chain” in Excel.

* Ctrl + [ – Select direct precedent cells
* Shift + Ctrl + [ – Select all precedent cells
* Ctrl + ] – Select directly dependent cells
* Shift + Ctrl + ] – Select all dependent cells

There are other lists too like “Official list”:http://office.microsoft.com/en-us/assistance/HP052037811033.aspx and “David Ritchie’s”:http://www.mvps.org/dmcritchie/excel/shortx2k.htm

h2. What are most used

h2. Changing keyboard shortcuts

So how do you change keyboard shortcuts. Well, “macosx.com”:http://macosx.com/forums/mac-os-x-system-mac-software/39064-hidden-key-stroke-short-cuts-ms-excel.html has some tips and also some suggestions:

Hidden Key-stroke short-cuts in MS Excel – macosx.com

Assign a keyboard shortcut

1. On the Tools menu, click Customize.
2. At the bottom of the Customize dialog box, click Keyboard.
3. In the Customize Keyboard dialog box, select a category from the Categories list to see the commands and other items associated with that category.
4. Click the command you want in the list to the right.

Note** If there is currently a keyboard shortcut associated with the command, it is displayed in the Current keys box.
5. Click inside the Press new shortcut key box.
6. Press the key combination you want to use for the command.
7. Click Add.
8. After you have finished assigning all the shortcuts you want, click OK.

Note** If you change your mind now or later, you can reset the shortcuts by clicking Reset All.”

Also, Unsanity has an app to create keyboard shortcuts that you can check out – I haven’t used it yet. I often use QuicKeys – for example, I was so sick of paste special not defualting to unformatted text (what I always seem to want to do) that I created a QuicKeys shortcut for this that I use in Word, Excel and Mail.”

Excel Keystrokes

I use these every time I’m in Excel.

* ctrl-Space – select column
* shift-Space – select row
* ctrl-Arrow Key – depending on which arrow key you hit, it will move the cursor along a series of cells*
* ctrl-Page Up, ctrl-Page Down – cycles through worksheets
* ctrl-Home – selects A1 on the current worksheet

h2. Mac Excel shortcuts

BTW, it turns out that Mac Excel has many identical ones, but they use the Command key instead of the CTRL key. How dumb since the CTRL key isn’t used at all by Mac Excel. Here are some:

XL2001: Shortcut Keys Available in Excel 2001 for Mac (Part 1)

Start a formula Cell, Formula bar = (Equal sign)
Move one character up, down, left, or right Cells, Text boxes ARROW KEYS
Move between options in the active pop-up menu or between some options in a group of options Dialog boxes ARROW KEYS
Move one cell in a given direction Sheets ARROW KEYS
Move around the page when zoomed in (in Print Preview) Print Preview ARROW KEYS
Calculate all sheets in all open workbooks Workbooks COMMAND+= (Equal sign)
Resize cell and show the formula instead of the resulting value. If the cell does not contain a formula, show the value. Options, Display Formula COMMAND+~ (Tilde)
Display the Cells command (Format menu) Workbook COMMAND+1
Select the entire worksheet Worksheet COMMAND+A
Apply or remove bold formatting Cells, Text Boxes, Chart objects, Chart items COMMAND+B
Copy the selection Cell, Range, Object COMMAND+C
Move the selected field into the Column area PivotTable Wizard – Layout dialog box COMMAND+C
Move the selected field into the Data area PivotTable Wizard – Layout dialog box COMMAND+D
Align center Cells, Text boxes COMMAND+E
Display the Find command (Edit menu) Excel COMMAND+F
Switch to the next workbook window Workbook window COMMAND+F6
Display the Replace command (Edit menu) Excel COMMAND+H
Apply or remove italic formatting Cells, Text Boxes, Chart objects, Chart items COMMAND+I
Insert a hyperlink Cell COMMAND+K
Aligns the selection to the left Cells, Text boxes COMMAND+L
Display the PivotTable Field dialog box PivotTable Wizard – Layout dialog box COMMAND+L
Move one word to the left Text box COMMAND+LEFT ARROW
Indent Cell, Range COMMAND+M
Create a new workbook Excel COMMAND+N
Open an existing file Excel COMMAND+O
Remove all borders Cell, Range COMMAND+OPTION+- (Hyphen)
Apply the outline border Cell, Range COMMAND+OPTION+0 (Zero)
Apply/remove the bottom outline border Cell, Range COMMAND+OPTION+DOWN ARROW
Apply/remove the left outline border Cell, Range COMMAND+OPTION+LEFT ARROW
Apply/remove the right outline border Cell, Range COMMAND+OPTION+RIGHT ARROW
Apply/remove the top outline border Cell, Range COMMAND+OPTION+UP ARROW
Display the Print command (File menu) Workbook, Help window COMMAND+P
Move the selected field into the Page area PivotTable Wizard – Layout dialog box COMMAND+P
Quit Excel COMMAND+Q
Aligns the selection to the right Cells, Text boxes COMMAND+R
Move the selected field into the Row area PivotTable Wizard – Layout dialog box COMMAND+R
Move one word to the right Text box COMMAND+RIGHT ARROW
Save Workbook COMMAND+S
Decrease font size Workbook COMMAND+SHIFT+,
Increase font size Cells, Text boxes COMMAND+SHIFT+.
Apply or remove strikethrough formatting Cells, Text boxes COMMAND+SHIFT+- (Hyphen)
Add or remove outline on text Cell, Range COMMAND+SHIFT+D
Switch to the previous workbook window Workbook window COMMAND+SHIFT+F6
Display the Style command (Format menu) Workbook COMMAND+SHIFT+L
Select or unselect one word to the left Cells, Text boxes COMMAND+SHIFT+LEFT ARROW
Unindent (remove indent) Cells, Text boxes COMMAND+SHIFT+M
Select all cells that contain comments Worksheet COMMAND+SHIFT+O
Select or unselect one word to the right Cells, Text boxes COMMAND+SHIFT+RIGHT ARROW
Insert the AutoSum formula Cell, Range COMMAND+SHIFT+T
Display the Paste Special dialog box after Copy command Cell, Range COMMAND+SHIFT+V
Add or remove shadow on text Cell, Range COMMAND+SHIFT+W
Select only visible cells in the current selection Range COMMAND+SHIFT+Z
Toggle cell reference relative or absolute Range COMMAND+T
Select a Help topic from the topics that are displayed by the Office Assistant Assistant Help balloon COMMAND+Topic number (where 1 is the first topic, 2 is the second, and so on)
Apply or remove underline formatting Cells, Text boxes COMMAND+U
Paste the selection Excel COMMAND+V
Close the active workbook window Windows and dialog boxes COMMAND+W
Cut the selection Cell, Range, Object COMMAND+X
Repeat the last action Workbook COMMAND+Y
Undo the last selection Excel COMMAND+Z

h3. What is not right

In Mac Excel 2008, some keys are there and others are missing. Here’s a list of the common ones I use and their status:

Shift-Space. Select Row. It’s there
Ctrl-Space. Select Column. It’s there
Ctrl-Shift-=. Insert. Not there. Can add with the Tools/Customize Keyboard.

Finding a coach and Removing a coach from a team

This really shouldn’t be this hard, but to find an existing coach from a team you have to:

# Click on the league you want (e.g., 2008 Fall Rec)
# On the Quick Clicks in the top left of the screen, look for Find Participant
# Click on Coache and type in the last name
# You will see all the teams that person has ever coached.
# Click on the last season and you will see the coaches form
# In the middle of the coaches page there is a hot link under _Current Team Assignment_ which points to the team page
# Click on the team page to see who they coach

If you want to remove a coach, choose from Quick Clicks, assign coach

# From there, you can see on the left coaches current assigned.
# to remove the coach, select his name and then click the right arrow to move him to available