MS-Excel 2007 Shortcut keys

CTRL+1	Displays the Format Cells dialog box.
CTRL+2	Applies or removes bold formatting.
CTRL+3	Applies or removes italic formatting.
CTRL 4	Applies or removes underlining in Microsoft Excel.
CTRL+5	Applies or removes strikethrough.
CTRL+6	Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
CTRL+8	Displays or hides the outline symbols.
CTRL+9	Hides the selected rows.
CTRL 0	Hides the selected columns in Microsoft Excel.
CTRL+A	Selects the entire worksheet. If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the current region and its summary rows. Pressing CTRL+A a third time selects the entire worksheet. When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box. CTRL+SHFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.
CTRL+B	Applies or removes bold formatting.
CTRL+C	Copies the selected cells. CTRL+C followed by another CTRL+C displays the Clipboard.
CTRL+D	Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
CTRL+F	Displays the Find and Replace dialog box, with the Find tab selected. SHFT+F5 also displays this tab, while SHFT+F4 repeats the last Find action. CTRL+SHFT+F opens the Format Cells dialog box with the Font tab selected.
CTRL+G	Displays the Go To dialog box. F5 also displays this dialog box.
CTRL+H	Displays the Find and Replace dialog box, with the Replace tab selected.
CTRL I	Applies or removes italic formatting in Microsoft Excel.
CTRL+K	Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
CTRL+N	Creates a new, blank workbook.
CTRL O	Displays the Open dialog box to open or find a file. CTRL SHFT O selects all cells that contain comments in Microsoft Excel.
CTRL+P	Displays the Print dialog box. CTRL+SHFT+P opens the Format Cells dialog box with the Font tab selected.
CTRL+R	Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
CTRL+S	Saves the active file with its current file name, location, and file format.
CTRL T	Displays the Create Table dialog box in Microsoft Excel.
CTRL+U	Applies or removes underlining. CTRL+SHFT+U switches between expanding and collapsing of the formula bar.
CTRL+V	Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents.
CTRL+W	Closes the selected workbook window.
CTRL+X	Cuts the selected cells.
CTRL Y	Repeats the last command or action, if possible in Microsoft Excel.
CTRL+Z	Uses the Undo command to reverse the last command or to delete the last entry that you typed. CTRL+SHFT+Z uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.

MS-Word 2007 Shortcut keys

File Operations

Some of the most common operations used in Office include opening, closing, saving, and printing. Because these operations are used so commonly, using the keyboard shortcuts can simplify and speed up your work. The following table provides the action and the shortcut key command needed to perform each action.

	Action	Key Command
	Open a file	[Ctrl] + [O]
	Close a file	[Ctrl] + [W]
	Save a file	[Ctrl] + [S]
	Print a file	[Ctrl] + [P]

Edit Operations

Editing operations such as cut, copy, paste, and check spelling are also used frequently. Rather than spending time searching the Ribbon, command tabs, or Quick menus for these editing options, you can save time using the shortcut key operations.

	Action	Key Command
	Cut	[Ctrl] + [X]
	Copy	[Ctrl] + [C]
	Paste	[Ctrl] + [V]
	Check spelling	[F7]

Selecting Text

In order to format text, it must be selected. You can select the appropriate text with shortcut keys rather than highlighting using the mouse. These key commands allow you to select as much or as little text as you need.

	Action	Key Command
	Select all	[Ctrl] + [A]
	Select one character to the right	[Shift] + [Right Arrow]
	Select one character to the left	[Shift] + [Left Arrow]
	Select to the beginning of a word	[Control] + [Shift] + [Left Arrow]
	Select to the end of a word	[Control] + [Shift] + [Right Arrow]
	Select to the end of the line	[Shift] + [End]
	Select to the beginning of the line	[Shift] + [Home]
	Select one line down	[Shift] + [Down Arrow]
	Select one line up	[Shift] + [Up Arrow]
	Select to the end of the paragraph	[Ctrl] + [Shift] + [Down Arrow]
	Select to the beginning of the paragraph	[Ctrl] + [Shift] + [Up Arrow]
	Select one screen down	[Shift] + [Page Down]
	Select one screen up	[Shift] + [Page Up]
	Select to the beginning of the document	[Ctrl] + [Shift] + [Home]
	Select to the end of the document	[Ctrl] + [Shift] + [End]

Undo and Redo Options

When making quick adjustments to your document, you may want to undo or redo the most recent action(s) performed. These keyboard shortcuts can save you time by not forcing you to use the mouse to access these options on the Ribbon.

	Action	Key Command
	Undo previous action	[Ctrl] + [Z]
	Redo previous action	[Ctrl] + [Y]
	Cancel any action	[Esc]

Current File Navigation

Depending on your editing style, you may find navigating through your currently opened document via keyboard shortcuts to be the fastest and easiest. For example, if you want to be at the top of the next page, you can simply press two keys instead of scrolling through the page with the mouse.

	Action	Key Command
	Move one character to the left	[Left Arrow]
	Move one character to the right	[Right Arrow]
	Move one word to the left	[Ctrl] + [Left Arrow]
	Move one word to the right	[Ctrl] + [Right Arrow]
	Move one paragraph up	[Ctrl] + [Up Arrow]
	Move one paragraph down	[Ctrl] + [Down Arrow]
	Move up one line	[Up Arrow]
	Move down one line	[Down Arrow]
	Move to the end of one line	[End]
	Move to the beginning of one line	[Home]
	Move one screen up	[Page Up]
	Move one screen down	[Page Down]
	Move to the top of the next page	[Ctrl] + [Page Down]
	Move to the top of the previous page	[Ctrl] + [Page Up]
	Move to the end of the document	[Ctrl] + [End]
	Move to the beginning of the document	[Ctrl] + [Home]

File Navigation

Using keyboard shortcuts, you can open and navigate through files from the Open dialog box.

1. To open a file, press [Ctrl] + [O]
   The Open dialog box appears.

2. To move through major sections of the dialog box (e.g., text boxes, pull-down menus, and buttons), press [Tab]
   A new section is selected each time [Tab] is pressed.

3. Navigate through each individual section by pressing the [Left Arrow], [Right Arrow], [Up Arrow], or [Down Arrow] keys

4. When your file is found or the appropriate option is set, press [Enter] from any area of the dialog box

5. To cancel an operation and close the dialog box, press [Esc]
   NOTE: No changes will be made to your document if [Esc] is pressed.

Opening Quick Menus

Right clicking the mouse opens a Quick menu of commonly used menu options. Using keyboard shortcuts, however, you may select or place the insertion point within the object and open the Quick menu without clicking the mouse at all. Once the Quick menu appears, use the arrow keys to navigate through the menu options.

1. Place the insertion point within the desired text or select the desired object

2. To open the appropriate Quick menu, press [Shift] + [F10]
   The Quick menu appears.
   NOTE: Some keyboards have one key you can press to access the Quick menu from any application.
   

3. To highlight the appropriate Quick menu option, press the [Up Arrow], [Down Arrow], [Left Arrow], or [Right Arrow] keys

4. To select a menu option, once it is highlighted, press [Enter]
   The menu action is applied and the Quick menu disappears.

Navigating Through a Quick Menu

While there are fewer menus available in Office 2007, navigating through them without using the mouse is still easy and convenient.

	Action	Key Command
	Scroll down one menu option	[Down Arrow]
	Scroll up one menu option	[Up Arrow]
	Open a submenu of options	[Right Arrow]
	Exit a submenu of options	[Left Arrow]
	Apply a selected menu option	[Enter]
	Exit the menu	[Esc]

Using the Command Tabs

You can view the options on a command tab (e.g., Write, Insert) quickly using keyboard shortcuts. Each command tab has specialized options for formatting your document, called groups. Once the groups for a command tab appear, you can select the formatting option of your choice or use additional key commands to make selections within the groups.

NOTE: Some keyboard shortcuts will vary between Office programs. To learn more about viewing the keyboard shortcuts, see The Office 2007 Environment.

Opening the Tabs

	Action	Key Command
	Open the OFFICE BUTTON	[Alt] + [F]
	Open the Home tab	[Alt] + [H]
	Open the View tab	[Alt] + [W]
	Open the Insert tab	[Alt] + [N]
	Open the Page Layout tab	[Alt] + [P]
	Open the References tab	[Alt] + [S]
	Open the Review tab	[Alt] + [R]
	Open the Help menu	[F1]

Navigating Through Groups on the Command Tab

Each group in the command tab is assigned a shortcut letter for quick access to that group. When you select a group using the shortcut letter, you then see more letters for the individual options within that group.

For example, to make a word bold in Word:

1. Select the text you would like bolded by using the Selecting Text shortcut keys

2. To open the Home tab, press [Alt] + [H]
   NOTES:
   The Home tab is selected.
   Groups within the Home tab are labeled with a shortcut letter.
   Options within the groups are labeled with a shortcut letter.

3. To make your selected text bold, press [1]
   The selected text is now bolded, and the labels are turned off. Pressing these letters will now simply type them into the document.

4. To turn the labels back on, repeat steps 1-4

Remove the OEM link from the Start Menu

In many cases, an OEM (Original Equipment Manufacture) machine will have a link in the start menu that will either open a folder, web page or launch an application. If you find this feature to be annoying and have no intensions of using this link, you can hide this link from the Start Menu. Here's how:

1. Click the Start button
2. Right click the top of the Start menu
3. A "Properties" button should appear. Click the Properties button.

Note: If more than a Properties button should appear, then you are right clicking a program within the Start Menu.

4. Click the Start Menu tab
5. Select the Customize button
6. Choose the Advanced tab
7. In the Start Menu items list, uncheck the entry titled: Manufacturer Link
8. Click OK, then OK again.

In some cases, I have seen that the Manufacturer Link does not appear in the Start Menu Items list. If this is your case, you will need to edit the Windows Registry to enable the Start Menu Items list option. Before editing the Registry, be sure to save a backup copy to a file.

How to backup the Windows Registry

Enable the Start Menu item list option:

1. Go to Start>> Run. Type in: regedit [Enter] or click OK.
2. Navigate to following registry key:

HKEY_LOCAL_MACHINE\Software\Microsoft \Windows\CurrentVersion\Explorer\StartMenu\StartPanel\ShowOEMLink

3. Click the "ShowOEMLink" entry once to empty its contents in the right pane.
4. Double click the entry titled: NoOEMLinkINstalled
5. Change its value from "1" to "0"
6. Exit the Windows Registry Editor and restart Windows

The Manufacturer Link should now be viewable in the "Start Menu Items" dialog. Now you can uncheck this item to hide it from the Start Menu.

Change the command prompt startup directory

By default, when you open a command prompt window (Start>> Run. Type in: cmd [Enter]), it opens to the default user profile directory (see fig #1). Changing this setting requires a registry change. Be sure to make a backup copy before making any changes.

How to change the startup directory:

1. Go to Start>> Run. Type in: regedit [Enter] or click OK.
2. Navigate to the following registry key:

HKEY_CURRENT_USER\Software\Microsoft\Command Processor
3. Single click the entry titled: Command Processor to empty its contents in to the right pane.
4. In the right pane, double click the entry titled: Autorun
5. Double click the Autorun entry.
6. Place the actual path that you would like the command prompt to start at in to the "Value data:" text box.
7. Exit the Windows Registry.

Example: To set the Startup Directory at: C:\Windows, enter CD /d C:\Windows in the Value data text box.

Note: If the Autorun entry is not present, create a new string. Here's how:

1. Right click an empty area of the right pane.
2. Select New>> String value
3. Name the new string value: Autorun
4. Continue with Step #5 above.

MS-Excel Shortcuts

Keyboard Shortcut	Result in Excel 2000 - General
F1 Key	Help
F2 Key	Edit current Cell
F5 Key	Goto
F7 Key	Spell Check
F12 Key	Save file as
CTRL and A	Select entire worksheet.
CTRL and B	Toggle Bold Text.
CTRL and C	Copies the item or items selected to the Clipboard and can be pasted using CTRL and V.
CTRL and F	Displays the Find dialog box.
CTRL and H	Displays the Replace dialog box.
CTRL and I	Toggles Italic Text.
CTRL and N	New File.
CTRL and O	Open File.
CTRL and P	Print.
CTRL and S	Save File.
CTRL and U	Toggles Underlined Text.
CTRL and V	Paste the contents of the clipboard.
CTRL and X	Cut the selected item.
CTRL and Y	Redo the last undone action
CTRL and Z	Undoes the last action.
CTRL and 1	Displays Format Cells Dialogue Box
CTRL and 5	Toggles Strikethrough Text

---

---

Keyboard Shortcut	Result in Excel 2000 - Formulas
ALT and =	Autosum
ALT and F8	Macros
CTRL and ;	Insert Current Date
CTRL and :	Insert Current Time

---

---

Keyboard Shortcut	Result in Excel 2000 - Movement
Left Arrow	One Cell Left (also SHIFT and TAB)
Right Arrow	One Cell Right (also TAB)
Up Arrow	One Cell Up
Down Arrow	One Cell Down
Home	Go to End of row
CTRL and left Arrow	Go to End of Column
CTRL and Home	Go to Top of Worksheet (A1)
CTRL and End	Go to End of Worksheet
CTRL and PAGE-DOWN	Go to Next Worksheet

---

---

Keyboard Shortcut	Result in Excel 2000 - Cell Selection
CTRL and Spacebar	Select the entire Column
SHIFT and Spacebar	Select the entire Row
CTRL and A	Select Entire Worksheet
SHIFT and Left Cursor	Select all cells to the left of the active one
SHIFT and Right Cursor	Select all cells to the right of the active one

MS-Word Shorcuts

Keyboard Shortcut	Result in Microsoft Word
CTRL and A	Selects all in the current document.
CTRL and B	Bold text.
CTRL and C	Copies the item or text to the Clipboard and can be pasted using CTRL and V.
CTRL and D	Displays the Font dialogue box.
CTRL and E	Centre Alignment.
CTRL and F	Displays the Find dialog box, to search the current document.
CTRL and G	Displays the Go to dialog box, to go to a specific location in the current document.
CTRL and H	Displays the Replace dialogue box.
CTRL and I	Italic text.
CTRL and J	Full Justification.
CTRL and K	Create Hyperlink
CTRL and L	Left Alignment
CTRL and M	Tab
CTRL and N	Creates a new document.
CTRL and O	Displays the Open File dialogue box.
CTRL and P	Displays the Print dialog box.
CTRL and R	Right Alignment.
CTRL and S	Displays the Save dialog box.
CTRL and U	Underline text
CTRL and V	Pastes the copied item or text from the Clipboard into the current position in the document.
CTRL and X	Cuts the item or text selected to the Clipboard.
CTRL and Y	Redo the last undone action.
CTRL and Z	Undoes the last action.
CTRL and ENTER	Insert Page Break.
CTRL and F2	Show Print preview.
CTRL and F4	Closes the active document window.
CTRL and F6	Opens the next document window.

---

---

Keyboard Shortcut	Result in Microsoft Word
F1 key	Get help or use the Office assistant.
SHIFT and F1 Key	Context sensitive help.
F2 Key	Move text or image.
SHIFT and F2 Key	Copy Text.
F3 Key	Insert an autotext entry.
SHIFT and F3 Key	Change the case of the selected text.
F4 Key	Perform last action again.
SHIFT and F4 Key	Perform a Find or Go to action again.
F5 Key	Displays the Go to dialogue box, from here you can also Find and Replace.
SHIFT and F5 Key	Move to a previous revision.
F6 Key	Go to the next frame or pane.
SHIFT and F6 Key	Go to the previous frame or pane.
F7 Key	Launch the Spell checker.
SHIFT and F7 Key	Launch the Thesaurus.
F8 Key	Extend the current selection.
SHIFT and F8 Key	Shrink the current selection.
F9 Key	Update the selected fields.
SHIFT and F9 Key	Switch between a field code and it's result.
F10 Key	Activate the menu bar.
SHIFT and F10 Key	Display a Shortcut Menu. Same as right clicking.
F11 Key	Go to the next field.
SHIFT and F11 Key	Go to the previous field.
F12 Key	Save file As, equivalent to tools menu.
SHIFT and F12 Key	Save document, equivalent to tools menu.