Excel Reference - Keyboard Shortcuts continued

(Page 6 of 6 )

Table 4-14. Manipulating shortcut menus

Key	Action
Shift-F10	Display the shortcut menu for the selected item.
Alt-Space	Display the Excel control menu.
Down arrow	When a menu is open, select the next command.
Up arrow	When a menu is open, select the previous command.
Left arrow	Select the menu to the left; in a submenu, switch between the main menu and submenu.
Right arrow	Select the menu to the right; in a submenu, switch between the main menu and submenu.
Home	Select the first command on the open menu.
End	Select the last command on the open menu.
Esc	Close the open menu. In a submenu, close the submenu but keep the menu open.

Table 4-15. Create and manipulate charts

Key	Action
F11 or Alt-F1	Create a chart using the data in the current range.
Ctrl-Page Down	Select the next sheet in the workbook.
Ctrl-Page Up	Select the previous sheet in the workbook.
Down Arrow	Select the previous group of elements in a chart.
Up Arrow	Select the next group of elements in a chart.
Right Arrow	Select the next element in a group.
Left Arrow	Select the previous element in a group.

Table 4-16. Work with macros

Key	Action
Alt-F8	Open the Macro dialog box.
Alt-F11	Open the Visual Basic Editor.
Ctrl-F11	Insert a Microsoft Excel 4.0 macro sheet.

Table 4-17. Display and hide items in a PivotTable

Key	Action
Up arrow	Select the previous item in the range.
Down arrow	Select the next item in the range.
Right arrow	For an item that has lower-level items available, display the lower-level items.
Left arrow	For an item that has lower-level items displayed, hide the lower-level items.
Home	Select the first visible item in the list.
End	Select the last visible item in the list.
Enter	Close the list and display the selected items.
Space	Check, double-check, or clear a checkbox in a list. Double-check selects both an item and all of its lower-level items.
Tab	Switch among the list, the OK button, and the Cancel button.

Table 4-18. Smart Tags

Key	Action
Alt-Shift-F10	Display the menu or message for a Smart Tag. If more thanone Smart Tag is present, move to the next Smart Tag and display its menu or message.
Down arrow	Select the next item in a Smart Tag menu.
Up arrow	Select the previous item in a Smart Tag menu.
Enter	Perform the action for the selected item in the Smart Tag menu.
Esc	Close the Smart Tag menu or message without taking action.

DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

Comments On: Excel Reference

· This article is an excerpt from the book "Excel 2007 Pocket Guide, Second Edition,"...   >>> Post your comment now!

Buy this book...

This article is excerpted from chapter four of the Excel 2007 Pocket Guide, Second Edition, written by Curtis Frye (O'Reilly; ISBN: 0596514522). Copyright © 2007 O'Reilly Media, Inc. Check it out today at your favorite bookstore. Buy this book now.