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

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.

Cloud Computing

Well, “Igncap”:http://igncap.com is nearly fully in the cloud. Our Exchange server is hosted (thank you “Applix”:http://applix.com) which is the main thing. Our fax service is as well (thank you “Metrohispeed”:http://metrohispeed.com) and is conferencing (thank you “FreeAudioConferencing.com”:http://freeaudioconferencing.com), as it our external website/blog (thank you “WordPress”:http://wordpress.com and “BlueHost”:http://bluehost.com) and intranet/wiki (thank you “Wikka Wiki”:http://wikkawiki.org) so what is next:

* “File and Backup by Egnyte”:http://egnyte.com. We are on a 15 day trial, but if you have 100Mbps or higher, then this might really work. It’s a server that let’s you back things up and have scratch storage. Right now, we have a pair of terabyte TimeCapsules, so it isn’t really too bad. In combination with TimeMachine, we’ve got a decent solution. We’ll give this a try.
* “Phone by Fonality”:http://fonality.com. The main issue is that We still have to buy a box for our IP PBX which is too bad. Maybe we’ll find another service that is all in the cloud in the next few years. . Fonality is kind of the right idea, but the box isn’t user configurable and they only work support 8-5PM. So really unacceptable for enterprise level. Trying “Pingtel”:http://pingtel.com next. Our trunks out are handled by “Broadvox”:http://broadvox.com.
* “Word Processing, Spreadsheets and Presentations”:http://google.com. We are still using Mac Office, but maybe google apps will change all that someday soon.

All of this is really thanks to “Cogent”:http://cogentco.com, which we’ll love or curse if the Internet is unrealiable.

Font common to Mac and Windows

“Ampsoft”:http://www.ampsoft.net/webdesign-l/WindowsMacFonts.html explains what “browser safe fonts” are available. These are fonts that are both on Windows and the “Macintosh”:http://en.wikipedia.org/wiki/List_of_fonts_in_Mac_OS_X. “Codestyle.org”:http://www.codestyle.org/css/font-family/sampler-CombinedResults.shtml has a study of what fonts are available on how many computers. Also, if you love typography, check out “Typowiki”:http://typophile.com/typowiki.

You can also be a little more aggressive and assume that Microsoft Office is installed and so are its “fonts”:http://support.microsoft.com/kb/837463. These add some good ones like Bell MT, Franklin Gothic Book, Gill Sans MT, Century Schoolbook

There are not a large number of them that are common. Of these, the one I miss the most is for the san serif family. Namely, “Optima”:http://typophile.com/node/15685? which was also designed by Zapf in 1958 and then updated to Optima nova in 2002. It is on 87.60% of all Macs but only 3.58% of all Windows machines according to “Codestyle.org”:http://www.codestyle.org/css/font-family/sampler-CombinedResultsFull.shtml

For serif fonts:

Palatino or Palatino Linotype. The clone is called Book Antiqua and is available on the Mac if you’ve installed Microsoft Mac Office. This was designed by Hermann Zapf in the 1940s. 97.1% of all Windows machines have it. There was widespread cloning of Palatino according to “Typowiki”:http://typophile.com/node/16864? and there has been a family, so first there was Palatino in the 1950s, then Palatino Linotype which used OpenType and then in 2003, Palatino nova

For sans serif fonts:

Lucida Sans Unicode or Lucida Grande. “Wikipedia”:http://en.wikipedia.org/wiki/Lucida_Grande says it is a humanist sans-serif font by Charles Bigelow and Kris Holmes. It is very similar to “Lucida Sans Unicode”:http://en.wikipedia.org/wiki/Lucida_Sans_Unicode also designed by Bigelow & Holmes in 1993. 93.48% of all Windows machines have it. 91.25% of Macs. It is a large font which could be an issue.

Trebuchet MS. This is in both Windows (95.29%) and Mac (92.7%). It was developed in 1996 as a machine readable sans serif face. “Trebuchet”:http://en.wikipedia.org/wiki/Trebuchet_MS is the deffault font for Windows XP title bars. According to “Microsoft”:http://www.microsoft.com/typography/fonts/font.aspx?FID=2&FNAME=Trebuchet%20MS it was created along with Verdana and Georgia to be screen readable. Trebuchet is supposed to be energetic (whatever that means.

Verdana. Both Mac (94.12%) and Windows. (97.14%). “Wikipedia”:http://en.wikipedia.org/wiki/Verdana says it is like Frutiger and designed to be readable at small sizes. According to “Microsoft”:http://www.microsoft.com/typography/fonts/font.aspx?FID=1&FNAME=Verdana it resembles Frutiger and also the typeface found in the London Underground. .

Tahoma. Both Windwos (96.09%) and Mac. “Designed”:http://en.wikipedia.org/wiki/Tahoma_(typeface) in 1994 for Windows 95, it is very similar to Verdana but is narrower and with a tighter spacing. It is the default screen font on Windows 2000/XP/2003 and also Facebook. With OS X v10.5, it is not bundled with Macintoshes

Mac Office 2008 somewhat faster

This corresponds to what I’ve seen, you’d expect that Office 2008 being a native Intel application would be much faster than Office 2004 which is PowerPC and runs in emulation on Intel. Well, the results are a little confusing. It is faster, but not much in many things:

| | Excel Open | Word Scroll | Entourage Download |
| 2004 | 0:25sec | 1:04 sec. | 1:29 sec |
| 2008 | 0:23 sec | 0:51 sec. | 0:49 sec |

So don’t upgrade to Office 2008 for speed. Also there is a new SP1 which is supposed to fix some of the many stability issues on Office 2008. Good luck. I think I’m staying on 2004 for now.