This is the plain text version --

there is an Excel sheet available

(see below).

Product index:

Access,

Excel,

Frontpage,

Outlook,

Photodraw,

Powerpoint,

Publisher, and

Word.

Product: Access 2000

Shortcut KeyFunction
ALT+F11Switch between the Visual Basic Editor and the previous active window
CTRL+'Insert the data from the same field in the previous record
CTRL+:Insert the current time
CTRL+;Insert today's date
CTRL+CCopy
CTRL+ENTERInsert a carriage return in a memo or text field
CTRL+FFind and replace
CTRL+NOpen a new database
CTRL+OOpen an existing database
CTRL+PPrint
CTRL+SSave
CTRL+VPaste
CTRL+ZUndo
ESCUndo the changes you have made to the current field
ESC ESC (press ESC twice)Undo the changes you have made to the current record
F11Display the database window

Product: Excel 2000

Shortcut KeyFunction
CTRL+:Insert the current time
CTRL+;Insert today's date
CTRL+` (single left quotation mark)Alternate between displaying cell values and displaying cell formulas
CTRL+1Display the Format Cells dialog box
CTRL+ASelect all (when you are not entering or editing a formula)
CTRL+AWhen you enter a formula, display the Formula Palette after you type a function name
CTRL+CCopy
CTRL+ENDMove to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottommost used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1
CTRL+ENTERFill the selected cell range with the current entry
CTRL+HOMEMove to the beginning of the worksheet
CTRL+OOpen
CTRL+PPrint
CTRL+SSave
CTRL+SPACEBARSelect the current column
CTRL+VPaste
CTRL+ZUndo
F11 or ALT+F1Create a chart that uses the current range
F5Display the Go To dialog box
F9Calculate all sheets in all open workbooks
SHIFT+F3Paste a function into a formula
SHIFT+F9Calculate the active worksheet
SHIFT+SPACEBARSelect the current row

Product: FrontPage 2000

Shortcut KeyFunction
CTRL+/Display HTML tags
CTRL+BBold
CTRL+CCopy
CTRL+IItalic
CTRL+KCreate a hyperlink
CTRL+NCreate a new page
CTRL+OOpen
CTRL+PPrint
CTRL+SSave
CTRL+SHIFT+BPreview a page in a Web browser
CTRL+TCreate an AutoThumbnail of the selected picture
CTRL+UUnderline
CTRL+VPaste
CTRL+ZUndo
SHIFT+ALT+F11Display the Microsoft Script Editor

Product: Outlook 2000

Shortcut KeyFunction
CTRL+ASelect all
CTRL+BACKSPACEDelete a word
CTRL+CCopy
CTRL+DDelete an e-mail message, contact, calendar item, or task
CTRL+PPrint
CTRL+QMark an e-mail message as read
CTRL+SHIFT+AOpen an appointment
CTRL+SHIFT+BOpen the address book
CTRL+SHIFT+COpen a contact
CTRL+SHIFT+FOpen the Advanced Find dialog box
CTRL+SHIFT+ISwitch to Inbox
CTRL+SHIFT+KOpen a task
CTRL+SHIFT+MOpen an e-mail message
CTRL+SHIFT+OSwitch to Outbox
CTRL+SHIFT+QOpen a meeting request
CTRL+VPaste
CTRL+ZUndo
F11Make the Find a Contact box active
F5 or CTRL+MCheck for new mail

Product: PhotoDraw 2000

Shortcut KeyFunction
CTRL+ASelect all
CTRL+CCopy
CTRL+DDuplicate a selected object
CTRL+DOWN ARROWMove a selected object backward in the picture
CTRL+GGroup two or more selected objects
CTRL+OOpen
CTRL+PPrint
CTRL+SSave
CTRL+TAdd text to a picture
CTRL+UUngroup objects
CTRL+UP ARROWMove a selected object forward in the picture
CTRL+VPaste
CTRL+ZUndo
F11Zoom to background
F2Show or hide a workpane
F3Show or hide the Picture List
RIGHT ARROW or LEFT ARROWNudge the object that is selected on the workspace one unit to the right or left
SHIFT+F10Display a shortcut menu that shows a list of commands relevant to the selected object
SPACEBAR Hide the selection box and resize handles of a selected object
UP ARROW or DOWN ARROWNudge the object that is selected on the workspace one unit up or down

Product: PowerPoint 2000

Shortcut KeyFunction
ALT+SHIFT+LEFT ARROWPromote a paragraph
ALT+SHIFT+RIGHT ARROWDemote a paragraph
CTRL+ASelect all
CTRL+BBold
CTRL+BACKSPACEDelete a word
CTRL+CCopy
CTRL+DMake a duplicate of the current slide
CTRL+EQUAL SIGN (=)Apply subscript formatting
CTRL+FFind
CTRL+GView guides
CTRL+IItalicize
CTRL+KInsert a hyperlink
CTRL+MInsert a new slide
CTRL+OOpen
CTRL+PPrint
CTRL+PLUS SIGN (+)Apply superscript formatting
CTRL+SSave
CTRL+TOpen the Font dialog box
CTRL+VPaste
CTRL+ZUndo
F4 or CTRL+YRepeat your last action
F5Start a slide show
F6Switch to the next pane (clockwise)
SHIFT+F3Capitalize
SHIFT+F6Switch to the previous pane (counterclockwise)

Product: Publisher 2000

Shortcut KeyFunction
ALT+DOWN ARROWNudge down
ALT+LEFT ARROWNudge to the left
ALT+RIGHT ARROWNudge to the right
ALT+UP ARROWNudge up
CTRL+ASelect all text in a text frame, the entire story in connected text frames, or all text in a table cell
CTRL+CCopy
CTRL+KInsert a hyperlink for the selected object on a Web page
CTRL+MMove between the background and the foreground page
CTRL+NCreate a new publication
CTRL+OOpen an existing publication
CTRL+PPrint part or all of a publication
CTRL+SSave changes to a publication
CTRL+SHIFT+CCopy formatting
CTRL+SHIFT+NAdd a page after the current page
CTRL+SHIFT+VPaste formatting
CTRL+SPACEBARReturn character formatting to the current text style
CTRL+TMake transparent or opaque
CTRL+VPaste
CTRL+ZUndo
ENTERBegin a new paragraph
F5Go to page...
F7Check spelling
F9Move between the current page view and actual size view
SHIFT+ENTEREnd one line and begin another without starting a new paragraph

Product: Word 2000

Shortcut KeyFunction
CTRL+ASelect all
CTRL+BBold
CTRL+BACKSPACEDelete a word
CTRL+CCopy
CTRL+ENDGo to the end of the document
CTRL+FFind and replace
CTRL+GGo to page, section, line, etc.
CTRL+HOMEGo to the beginning of the document
CTRL+IItalicize
CTRL+KInsert a hyperlink
CTRL+OOpen
CTRL+PPrint
CTRL+SSave
CTRL+SHIFT+ENDSelect to the end of the document
CTRL+SHIFT+HOMESelect to the beginning of the document
CTRL+VPaste
CTRL+ZUndo
F4 or CTRL+YRepeat your last action
SHIFT+F3Change case
SHIFT+F7Open the thesaurus

Commentary

There's a real spiffy Excel version of the above information available

on this page

on the Microsoft site. In fact, that's where I, um, borrowed the above information from.

I guess reproducing the entire contents of the Excel file goes a bit beyond

"fair use" from a copyright perspective, but the reason I'm doing it

is to make two comments about usability.

1. Why download?

First of all, to use the Microsoft Excel sheet, you have to download it.

That in itself is a weird process, but fortunately, they (Microsoft)

give you really clear instructions about how to download it and set it up

on your hard drive.

The weird part is that first you have to download a

self-extracting executable file, O2kkeys.exe, which weighs in at 93,208 bytes.

When you execute this file, it disgorges an Excel file,

A List of Useful  Office 2000 Shortcut Keys.xls (sic),

which weighs in at 29,104 bytes.

I guess the reason this is a two-step process is that

they couldn't just link to the Excel file directly, because of the propensity

of, ahem, certain browsers to actually try to open up the spreadsheet in the browser

rather than launching Excel. I'm guessing, but I think that

if this Excel file opens in certain browser versions

(although it worked fine in Internet Explorer 4.01), the Excel filters (see below)

that provide the spiffiness might not "work" properly.

Or maybe they just didn't want people to keep hitting their server.

I think it's a lot easier to have a bookmark to a page

like this one where the answers are immediately available.

If people are going to be offline a lot, they can save the HTML file

and bookmark it on their C drive.

2. Why Excel?

Secondly, to use the Microsoft Excel sheet, every time you

want to refer to it, you have to find it, double-click it, and thereby fire up Excel.

I don't know about you, but I'm not one of these people who

keeps Excel running in the background all the time --

I've got better things to waste RAM on.

Also, rumour has it there's an entire flight simulator game

built into Excel -- I sure don't need crap like that

slowing down my computer.

Nevertheless, the spreadsheet is really kind of neat. There are three columns --

Product, Activity, and Shortcut Keys -- each of which has an

Excel filter programmed into a dropdown thingie

which hides all but the item chosen...

so you can select, via the dropdown, a specific Product and a specific Activity,

and then read off on the same line what the keyboard shortcut is.

What is the purpose of this, I wonder? Can it be

just so that you can find stuff without

having to scroll through the spreadsheet? That seems valid, but from a usability

perspective, are those dropdown thingies really

easier to use than scrolling?

Also, the Microsoft download page suggests that you can print off

selected pages for each Product and keep them near your computer.

So this might be

another valid reason. I mean, you could print out this page too,

but it would have all the products on it, not just the one you select for printing.

Conclusion

You know what? Maybe it's me, but a

plain, ordinary HTML web page approach seems a lot simpler

from a usability perspective. And I'm

saying this as a web surfer, a seeker of information,

not as someone who knows how to build a web page -- and I'd like to

think there are people in Microsoft who feel this way too.

I guess in the long run,

everyone must make up his or her own mind about usability.

For those who want to try the Excel sheet,

here's that link to the Microsoft page again --

Office 2000 Document: A List of Useful Shortcut Keys