Keyboard functions

2 views
Skip to first unread message

jopla

unread,
Aug 16, 2003, 2:10:13 PM8/16/03
to
I have noticed from reading entries, there are a lot of
cool keyboard combinations that produce excellent results,
control+semi-colon enters the date, etc.

Is there a list of these combo keystrokes.

Thanks.

Chip Pearson

unread,
Aug 16, 2003, 2:14:40 PM8/16/03
to
See www.cpearson.com/excel/shortcuts.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com ch...@cpearson.com

"jopla" <jop...@comcast.net> wrote in message
news:019201c36421$a3362980$a101...@phx.gbl...

Gord Dibben

unread,
Aug 16, 2003, 2:35:31 PM8/16/03
to
Help>Index "shortcut". Select Keyboard Shortcuts.

Gord Dibben Excel MVP XL2002

David McRitchie

unread,
Aug 17, 2003, 9:52:44 PM8/17/03
to
Hi jopla,
May be more than you wanted but I do have an interest in shortcuts
and their documentation or seemingly lack of documentation, or scattered
documentation.

Keyboard Shortcuts
Microsoft programs, especially in MS Office, you can find the shortcuts in
HELP by looking for "Keyboard Shortcuts" in the index.
[shortcuts also appears to work but "keyboard shortcuts" is what's documented]

IE, OE have decent HELP functions for keyboard shortcuts. Excel is too scattered to
see at one time, most packages are poor at showing Function keys (PFK) in HELP,
and what you can do with cursor / mouse.

Another poorly documented area in HELP is right-click (context) menus, which is not
too critical since like the menus you can at least see them.

Sizes below should be showing HTML code + Graphics

------------
EXCEL
-------------
Shortcut Keys in Excel 2000 (Excel Vers. 9)
** http://www.mvps.org/dmcritchie/excel/shortx2k.htm ** (107.8KB / 28 pages)

topics: shortcut, mykeys, winkey, rclick, cursor, HELP, accessibility, related, more
(right-click context menus: worksheet, menu bar, status bar, navigation arrows,
scroll bar, row header, column header, title bar)

A table by Key and auxiliary key(s) can be found in Chip Pearson's
Keyboard Shortcuts
http://www.cpearson.com/excel/KeyboardShortcuts.htm (161KB / 2 pages)

For VBE Shortcuts
VBA Editor Shortcut Keys
* http://www.cpearson.com/excel/vbashortcutkeys.htm (39KB / 3 pages)

-----------------------------------
INTERNET EXPLORER
----------------------------------

For Internet Explorer
IE6 -- Internet Explorer 6.0
http://www.mvps.org/dmcritchie/excel/ie6.htm (29.7KB / 6 pages)

Internet Explorer keyboard shortcuts
http://www.mvps.org/dmcritchie/excel/shortie6.htm (10,2KB / 4 pages)

Internet Explorer Right-Click Menus
http://www.mvps.org/dmcritchie/excel/shortie6.htm (29.1KB / 5 pages)

right-click shortcuts that came with IE -- Gloria Kraemer
Right Clicking in Internet Explorer = Get the Right Click
* http://www.glokraemer.com/lets/riteclick.htm (156KB / 3 pages)
-- right click on page
-- right click on a link

--------------------------------
OUTLOOK EXPRESS
--------------------------------

For Outlook Express
Outlook Express 5.0 through 6.0
http://www.mvps.org/dmcritchie/exce/oe6.htm#oekeys (60KB / 19 pages)

Outlook Express keyboard shortcuts
http://www.mvps.org/dmcritchie/excel/oe6short.htm (5 KB / 2 pages)

--------------------------------
EXPLORER
--------------------------------

For Explorer (you have to expand them)
Serenity Windows 98 Customising Explorer and the Start Menu
http://www.mvps.org/serenitymacros/explorer.html (69KB / 12 pages)
-- use Ctrl+ key to expand more than one topic

--------------------------
EXCEL HELP
--------------------------

The following has nothing to do with shortcuts but is definitely something
to download for your Excel References
Excel Function Dictionary « by Peter Noneley,
(276 KB zip file expands to 1221 KB file download either)
http://homepage.ntlworld.com/noneley (web page 9.6KB / 1 page)

Tutorials (links to) can be found on my main Excel page
Excel -- My Excel Pages -- David McRitchie
http://www.mvps.org/dmcritchie/excel/excel.htm#tutorials (114KB / 18 pages)


---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"jopla" <jop...@comcast.net> wrote in message news:019201c36421$a3362980$a101...@phx.gbl...

Reply all
Reply to author
Forward
0 new messages