General keyboard shortcuts

• / CTRL+C (Copy)
• / CTRL+X (Cut)
• / CTRL+V (Paste)
• / CTRL+Z (Undo)
• / DELETE (Delete)
• / SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin)
• / CTRL while dragging an item (Copy the selected item)
• / CTRL+SHIFT while dragging an item (Create a shortcut to the selected item)
• / F2 key (Rename the selected item)
• / CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word)
• / CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word)
• / CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph)
• / CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph)
• / CTRL+SHIFT with any of the arrow keys (Highlight a block of text)
• / SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document)
• / CTRL+A (Select all)
• / F3 key (Search for a file or a folder)
• / ALT+ENTER (View the properties for the selected item)
• / ALT+F4 (Close the active item, or quit the active program)
• / ALT+ENTER (Display the properties of the selected object)
• / ALT+SPACEBAR (Open the shortcut menu for the active window)
• / CTRL+F4 (Close the active document in programs that enable you to have multiple documents open simultaneously)
• / ALT+TAB (Switch between the open items)
• / ALT+ESC (Cycle through items in the order that they had been opened)
• / F6 key (Cycle through the screen elements in a window or on the desktop)
• / F4 key (Display the Address bar list in My Computer or Windows Explorer)
• / SHIFT+F10 (Display the shortcut menu for the selected item)
• / ALT+SPACEBAR (Display the System menu for the active window)
• / CTRL+ESC (Display the Start menu)
• / ALT+Underlined letter in a menu name (Display the corresponding menu)
• / Underlined letter in a command name on an open menu (Perform the corresponding command)
• / F10 key (Activate the menu bar in the active program)
• / RIGHT ARROW (Open the next menu to the right, or open a submenu)
• / LEFT ARROW (Open the next menu to the left, or close a submenu)
• / F5 key (Update the active window)
• / BACKSPACE (View the folder one level up in My Computer or Windows Explorer)
• / ESC (Cancel the current task)
• / SHIFT when you insert a CD-ROM into the CD-ROM drive (Prevent the CD-ROM from automatically playing)
• / CTRL+SHIFT+ESC (Open Task Manager)
/ Back to the top

Dialog box keyboard shortcuts

If you press SHIFT+F8 in extended selection list boxes, you enable extended selection mode. In this mode, you can use an arrow key to move a cursor without changing the selection. You can press CTRL+SPACEBAR or SHIFT+SPACEBAR to adjust the selection. To cancel extended selection mode, press SHIFT+F8 again. Extended selection mode cancels itself when you move the focus to another control.

• / CTRL+TAB (Move forward through the tabs)
• / CTRL+SHIFT+TAB (Move backward through the tabs)
• / TAB (Move forward through the options)
• / SHIFT+TAB (Move backward through the options)
• / ALT+Underlined letter (Perform the corresponding command or select the corresponding option)
• / ENTER (Perform the command for the active option or button)
• / SPACEBAR (Select or clear the check box if the active option is a check box)
• / Arrow keys (Select a button if the active option is a group of option buttons)
• / F1 key (Display Help)
• / F4 key (Display the items in the active list)
• / BACKSPACE (Open a folder one level up if a folder is selected in the Save As or Open dialog box)
/ Back to the top

Microsoft natural keyboard shortcuts

• / Windows Logo (Display or hide the Start menu)
• / Windows Logo+BREAK (Display the System Properties dialog box)
• / Windows Logo+D (Display the desktop)
• / Windows Logo+M (Minimize all of the windows)
• / Windows Logo+SHIFT+M (Restore the minimized windows)
• / Windows Logo+E (Open My Computer)
• / Windows Logo+F (Search for a file or a folder)
• / CTRL+Windows Logo+F (Search for computers)
• / Windows Logo+F1 (Display Windows Help)
• / Windows Logo+ L (Lock the keyboard)
• / Windows Logo+R (Open the Run dialog box)
• / Windows Logo+U (Open Utility Manager)
/ Back to the top

Accessibility keyboard shortcuts

• / Right SHIFT for eight seconds (Switch FilterKeys either on or off)
• / Left ALT+left SHIFT+PRINT SCREEN (Switch High Contrast either on or off)
• / Left ALT+left SHIFT+NUM LOCK (Switch the MouseKeys either on or off)
• / SHIFT five times (Switch the StickyKeys either on or off)
• / NUM LOCK for five seconds (Switch the ToggleKeys either on or off)
• / Windows Logo +U (Open Utility Manager)
/ Back to the top

Windows Explorer keyboard shortcuts

• / END (Display the bottom of the active window)
• / HOME (Display the top of the active window)
• / NUM LOCK+Asterisk sign (*) (Display all of the subfolders that are under the selected folder)
• / NUM LOCK+Plus sign (+) (Display the contents of the selected folder)
• / NUM LOCK+Minus sign (-) (Collapse the selected folder)
• / LEFT ARROW (Collapse the current selection if it is expanded, or select the parent folder)
• / RIGHT ARROW (Display the current selection if it is collapsed, or select the first subfolder)
/ Back to the top

Shortcut keys for Character Map

After you double-click a character on the grid of characters, you can move through the grid by using the keyboard shortcuts:

• / RIGHT ARROW (Move to the right or to the beginning of the next line)
• / LEFT ARROW (Move to the left or to the end of the previous line)
• / UP ARROW (Move up one row)
• / DOWN ARROW (Move down one row)
• / PAGE UP (Move up one screen at a time)
• / PAGE DOWN (Move down one screen at a time)
• / HOME (Move to the beginning of the line)
• / END (Move to the end of the line)
• / CTRL+HOME (Move to the first character)
• / CTRL+END (Move to the last character)
• / SPACEBAR (Switch between Enlarged and Normal mode when a character is selected)
/ Back to the top

Microsoft Management Console (MMC) main window keyboard shortcuts

• / CTRL+O (Open a saved console)
• / CTRL+N (Open a new console)
• / CTRL+S (Save the open console)
• / CTRL+M (Add or remove a console item)
• / CTRL+W (Open a new window)
• / F5 key (Update the content of all console windows)
• / ALT+SPACEBAR (Display the MMC window menu)
• / ALT+F4 (Close the console)
• / ALT+A (Display the Action menu)
• / ALT+V (Display the View menu)
• / ALT+F (Display the File menu)
• / ALT+O (Display the Favorites menu)
/ Back to the top

MMC console window keyboard shortcuts

• / CTRL+P (Print the current page or active pane)
• / ALT+Minus sign (-) (Display the window menu for the active console window)
• / SHIFT+F10 (Display the Action shortcut menu for the selected item)
• / F1 key (Open the Help topic, if any, for the selected item)
• / F5 key (Update the content of all console windows)
• / CTRL+F10 (Maximize the active console window)
• / CTRL+F5 (Restore the active console window)
• / ALT+ENTER (Display the Properties dialog box, if any, for the selected item)
• / F2 key (Rename the selected item)
• / CTRL+F4 (Close the active console window. When a console has only one console window, this shortcut closes the console)
/ Back to the top

Remote desktop connection navigation

• / CTRL+ALT+END (Open the Microsoft Windows NT Security dialog box)
• / ALT+PAGE UP (Switch between programs from left to right)
• / ALT+PAGE DOWN (Switch between programs from right to left)
• / ALT+INSERT (Cycle through the programs in most recently used order)
• / ALT+HOME (Display the Start menu)
• / CTRL+ALT+BREAK (Switch the client computer between a window and a full screen)
• / ALT+DELETE (Display the Windows menu)
• / CTRL+ALT+Minus sign (-) (Place a snapshot of the entire client window area on the Terminal server clipboard and provide the same functionality as pressing ALT+PRINT SCREEN on a local computer.)
• / CTRL+ALT+Plus sign (+) (Place a snapshot of the active window in the client on the Terminal server clipboard and provide the same functionality as pressing PRINT SCREEN on a local computer.)
/ Back to the top

Microsoft Internet Explorer navigation

• / CTRL+B (Open the Organize Favorites dialog box)
• / CTRL+E (Open the Search bar)
• / CTRL+F (Start the Find utility)
• / CTRL+H (Open the History bar)
• / CTRL+I (Open the Favorites bar)
• / CTRL+L (Open the Open dialog box)
• / CTRL+N (Start another instance of the browser with the same Web address)
• / CTRL+O (Open the Open dialog box, the same as CTRL+L)
• / CTRL+P (Open the Print dialog box)
• / CTRL+R (Update the current Web page)
• / CTRL+W (Close the current window)

Keys for moving and scrolling in a worksheet or workbook (Excel)

Arrow keys:Move one cell up, down, left, or right

CTRL+arrow: keyMove to the edge of the current data region

HOME:Move to the beginning of the row

CTRL+HOME:Move to the beginning of the worksheet

CTRL+END:Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1

PAGE DOWN:Move down one screen

PAGE UP:Move up one screen

ALT+PAGE DOWN:Move one screen to the right

ALT+PAGE UP:Move one screen to the left

CTRL+PAGE DOWN:Move to the next sheet in the workbook

CTRL+PAGE UP:Move to the previous sheet in the workbook

CTRL+F6 or CTRL+TAB:Move to the next workbook or window

CTRL+SHIFT+F6 or CTRL+SHIFT+TAB:Move to the previous workbook or window

F6:Move to the next pane in a workbook that has been split

SHIFT+F6:Move to the previous pane in a workbook that has been split

CTRL+BACKSPACE:Scroll to display the active cell

F5:Display the GoTo dialog box

SHIFT+F5:Display the Find dialog box

SHIFT+F4:Repeat the last Find action (same as FindNext)

TAB:Move between unlocked cells on a protected worksheet

Keys for moving in a worksheet with End mode on

END:Turn End mode on or off

END,arrow key:Move by one block of data within a row or column

END, HOME:Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1

END, ENTER: Move to the last cell to the right in the current row that is not blank; unavailable if you have selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command)

Keys for moving in a worksheet with SCROLL LOCK on

SCROLL LOCK:Turn SCROLL LOCK on or off

HOME:Move to the cell in the upper-left corner of the window

END:Move to the cell in the lower-right corner of the window

UP ARROW or DOWN ARROW:Scroll one row up or down

LEFT ARROW or RIGHT ARROW:Scroll one column left or right

Tip When you use scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL LOCK turned off, your selection moves the distance you scroll. If you want to preserve your selection while you scroll through the worksheet, turn on SCROLL LOCK first.

Keys for previewing and printing a document

CTRL+P or CTRL+SHIFT+F12:Display the Print dialog box

Work in print preview

Arrow keys:Move around the page when zoomed in

PAGE UP or PAGE DOWN:Move by one page when zoomed out

CTRL+UP ARROW or CTRL+LEFT ARROW:Move to the first page when zoomed out

CTRL+DOWN ARROW or CTRL+RIGHT ARROW:Move to the last page when zoomed out

Keys for working with worksheets, charts, and macros

SHIFT+F11 or ALT+SHIFT+F1: Insert a new worksheet

F11 or ALT+F1:Create a chart that uses the current range

ALT+F8:Display the Macro dialog box

ALT+F11:Display the Visual Basic Editor

CTRL+F11:Insert a Microsoft Excel 4.0 macro sheet

CTRL+PAGE DOWN:Move to the next sheet in the workbook

CTRL+PAGE UP:Move to the previous sheet in the workbook

SHIFT+CTRL+PAGE DOWN:Select the current and next sheet in the workbook

SHIFT+CTRL+PAGE UP:Select the current and previous sheet in the workbook

Keys for entering data on a worksheet

ENTER:Complete a cell entry and move down in the selection

ALT+ENTER:Start a new line in the same cell

CTRL+ENTER:Fill the selected cell range with the current entry

SHIFT+ENTER:Complete a cell entry and move up in the selection

TAB:Complete a cell entry and move to the right in the selection

SHIFT+TAB:Complete a cell entry and move to the left in the selection

ESC:Cancel a cell entry

BACKSPACE:Delete the character to the left of the insertion point, or delete the selection

DELETE:Delete the character to the right of the insertion point, or delete the selection

CTRL+DELETE:Delete text to the end of the line

Arrow keys:Move one character up, down, left, or right

HOME:Move to the beginning of the line

F4 or CTRL+Y:Repeat the last action

SHIFT+F2:Edit a cell comment

CTRL+SHIFT+F3:Create names from row and column labels

CTRL+D:Fill down

CTRL+R:Fill to the right

CTRL+F3:Define a name

Keys for working in cells or the formula bar

BACKSPACE:Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents

ENTER:Complete a cell entry

CTRL+SHIFT+ENTER:Enter a formula as an array formula

ESC:Cancel an entry in the cell or formula bar

CTRL+A:Display the Formula Palette after you type a function name in a formula

CTRL+SHIFT+A:Insert the argument names and parentheses for a function after you type a function name in a formula

CTRL+K:Insert a hyperlink

ENTER (in a cell with a hyperlink): Activate a hyperlink

F2:Edit the active cell and position the insertion point at the end of the line

F3:Paste a defined name into a formula

SHIFT+F3:Paste a function into a formula

F9:Calculate all sheets in all open workbooks

CTRL+ALT+F9:Calculate all sheets in the active workbook

SHIFT+F9:Calculate the active worksheet

= (equal sign):Start a formula

ALT+= (equal sign):Insert the AutoSum formula

CTRL+; (semicolon):Enter the date

CTRL+SHIFT+: (colon):Enter the time

CTRL+SHIFT+" (quotation mark):Copy the value from the cell above the active cell into the cell or the formula bar

CTRL+` (single left quotation mark):Alternate between displaying cell values and displaying cell formulas

CTRL+' (apostrophe):Copy a formula from the cell above the active cell into the cell or the formula bar

ALT+DOWN ARROW:Display the AutoComplete list

Keys for formatting data

ALT+' (apostrophe):Display the Style dialog box

CTRL+1:Display the Format Cells dialog box

CTRL+SHIFT+~:Apply the General number format

CTRL+SHIFT+$:Apply the Currency format with two decimal places (negative numbers appear in parentheses)

CTRL+SHIFT+%:Apply the Percentage format with no decimal places

CTRL+SHIFT+^:Apply the Exponential number format with two decimal places

CTRL+SHIFT+#:Apply the Date format with the day, month, and year

CTRL+SHIFT+@:Apply the Time format with the hour and minute, and indicate A.M. or P.M.

CTRL+SHIFT+!:Apply the Number format with two decimal places, thousands separator, and minus sign (–) for negative values

CTRL+SHIFT+&:Apply the outline border

CTRL+SHIFT+_:Remove outline borders

CTRL+B:Apply or remove bold formatting

CTRL+I:Apply or remove italic formatting

CTRL+U:Apply or remove an underline

CTRL+5:Apply or remove strikethrough formatting

CTRL+9:Hide rows

CTRL+SHIFT+( (opening parenthesis):Unhide rows

CTRL+0 (zero):Hide columns

CTRL+SHIFT+) (closing parenthesis):Unhide columns

Keys for editing data