Microsoft Excel shortcut keys Shortcut Keys Description F2 Edit the selected cell. F5 Goto a specific cell.

For example, C6. F7 Spell check selected text and/or document. Create chart. F11 Ctrl + Shift + ; Ctrl + ; Alt + Shift + F1 Shift + F3 Enter the current time. Enter the current date. Insert New Worksheet. Open the Excel formula window.

Ctrl + F Ctrl + A Ctrl + B Ctrl + I Ctrl + K Ctrl + U Ctrl + 5 Ctrl + P Ctrl + F9 Ctrl + F10 Ctrl + tab Ctrl + Page up Ctrl + Page down Alt + = Ctrl + ' Ctrl + Shift + ! Ctrl + Space Shift + Space Shift + F10 CTRL+ARROW CTRL+SHIFT+ARROW SHIFT+ARROW Alt or F10 ALT + Spacebar

Bring up search box. Select all contents of the worksheet. Bold highlighted selection. Italic highlighted selection. Insert link. Underline highlighted selection. Strikethrough highlighted selection. Bring up the print dialog box to begin printing. Minimize current window. Maximize currently selected window. Switch between open workbooks / windows. Move between Excel work sheets in the same Excel document. Move between Excel work sheets in the same Excel document. Create a formula to sum all of the above cells Insert the value of the above cell into cell currently selected. Format number in comma format. Select entire column. Select entire row. Show a Shortcut menu Move between 1st n last data cell Move between 1st n last data cell and select the text Select the text Make a menu bar active Show the Program icon menu

CTrl + R

to copy the same text in the next cell

CTRL+C CTRL+X CTRL+V CTRL+Z CTRL+A

Ctrl + Shift + $ Ctrl + Shift + # Ctrl + Shift + % Ctrl + Shift + ^ Ctrl + Shift + @ Ctrl + Arrow key

(Copy) (Cut) (Paste) (Undo) (Select all)

Format number in currency format. Format number in date format. Format number in percentage format. Format number in scientific format. Format number in time format. Move to next section of text.

keyboard short cuts

CTRL+C (Copy)

CTRL+X (Cut) CTRL+V (Paste) CTRL+Z (Undo) CTRL+A (Select all) CRTL+B Bold highlighted selection. CRTL+I Italics highlighted selection. CTRL+K Insert link CTRL+U Underline highlighted selection. 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) 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+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) 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)

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)

Microsoft Internet Explorer navigation

CTRL+B (Open the Organize Favorites dialog box) CTRL+E (Open the Search bar) CTRL+F/CTRL+K(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) CTRL+T (Open a new window in the same browser)

Keyboard shortcuts
Command Add Bookmark Windows Ctrl+D Backspace Alt+<Back Bookmarks Caret Browsing Close Tab Close Window Complete .com Address2 Complete .net Address2 Complete .org Address Copy Cut Decrease Text Size Delete Delete Individual Form AutoComplete Entry DOM Inspector Downloads Find Again Find As You Type Link Find As You Type Text Find Previous Find in This Page
2

Macintosh Cmd+D Backspace Cmd+[ Cmd+<Cmd+B F7 Cmd+W Cmd+F4 Cmd+Shift+W Option+F4 Cmd+Return Shift+Return Cmd+Shift+Return Cmd+C Cmd+X Cmd+Del Shift+Del Cmd+Shift+I Cmd+J Cmd+G F3 ' / Cmd+Shift+G Shift+F3 Cmd+F Shift+Backspace Cmd+] Cmd+-> Down Up PageDown PageUp End Home Cmd+? Cmd+H

Ctrl+B Ctrl+I F7 Ctrl+W Ctrl+F4 Ctrl+Shift+W Alt+F4 Ctrl+Enter Shift+Enter Ctrl+Shift+Enter Ctrl+C Ctrl+X Ctrl+Del Shift+Del Ctrl+Shift+I Ctrl+J Ctrl+G F3 ' / Ctrl+Shift+G Shift+F3 Ctrl+F Shift+Backspace Alt+->

Forward Go Down One Line Go Up One Line Go Down One Page Go Up One Page Go to Bottom of Page Go to Top of Page Full Screen Help History

Down Up PageDown PageUp End Home F11 F1 Ctrl+H

Home Page Increase Text Size Move to Next Frame Move to Previous Frame New Tab Next Tab New Window Open File Open Link Open Link in New Tab Open Link in New Window Open Address in New Tab2 Page Info Page Source Paste Previous Tab Print Redo Reload Reload (override cache) Restore Text Size Save Page As Save Link Target As Select All

Alt+Home Ctrl++ F6 Shift+F6 Ctrl+T Ctrl+Tab Ctrl+PageDown Ctrl+N Ctrl+O Enter Ctrl+Enter Shift+Enter Alt+Enter Ctrl+U Ctrl+V Ctrl+Shift+Tab Ctrl+PageUp Ctrl+P Ctrl+Shift+Z Ctrl+Y F5 Ctrl+R Ctrl+F5 Ctrl+Shift+R Ctrl+0 Ctrl+S Alt+Enter Ctrl+A Ctrl+L Alt+D Down Up Ctrl+Down Ctrl+Up Ctrl+[1 to 8] Ctrl+9 Esc Spacebar Ctrl+Z

Option+Home Cmd++ F6 Shift+F6 Cmd+T Ctrl+Tab Ctrl+PageDown Cmd+N Cmd+O Return Cmd+Return Shift+Return Option+Return Cmd+I Cmd+U Cmd+V Ctrl+Shift+Tab Ctrl+PageUp Cmd+P Cmd+Shift+Z F5 Cmd+R Cmd+F5 Cmd+Shift+R Cmd+0 Cmd+S Option+Return Cmd+A

Select Location Bar Select Next Auto-Complete entry in text field Select Previous Auto-Complete entry in text field Select Next Search Engine in Search bar Select Previous Search Engine in Search bar Select Tab [1 to 8] Select Last Tab Stop Toggle Checkbox Undo

Cmd+L Down Up Cmd+Down Cmd+Up Cmd+[1 to 8] Cmd+9 Esc Spacebar Cmd+Z

Web Search
1

Ctrl+K

Cmd+K

In Linux, you must perform additional configuration to enable this shortcut. In the Location bar, type about:config, and press This shortcut only works in the Location bar.

Mouse shortcuts
Command Back Close Tab1 Decrease text size Forward Increase Text Size New Tab Open in Background Tab2 Open in Foreground Tab2 Open in New Window Paste URL and Go1 Reload (override cache) Save Page As Scroll line by line Windows Shift+Scroll down Middle-click on tab Crtl+Scroll up Shift+Scroll up Ctrl+Scroll down Double-Click on Tab Bar Ctrl+click Middle-click Ctrl+Shift+click Shift+Middle-click Shift+click Middle-click on Tab Shift+Reload button Alt+click Alt+Scroll Macintosh Option+Scroll down Middle-click on tab Crtl+Scroll up Option+Scroll up Ctrl+Scroll down Double-Click on Tab Bar Cmd+click Middle-click Cmd+Shift+click Shift+Middle-click Shift+click Middle-click on Tab Shift+Reload button Option+click N/A

Linux Ctrl+D Backspace1 Alt+<Ctrl+[ Ctrl+B F7 Ctrl+W Ctrl+F4 Ctrl+Shift+W Alt+F4 Ctrl+Enter Shift+Enter Ctrl+Shift+Enter Ctrl+C Ctrl+X Ctrl+Del Shift+Del Ctrl+Shift+I Ctrl+Y Ctrl+G F3 ' / Ctrl+Shift+G Shift+F3 Ctrl+F Shift+Backspace1 Alt+-> Ctrl+] Down Up PageDown PageUp End Home F11 F1 Ctrl+H

Alt+Home Ctrl++ F6 Shift+F6 Ctrl+T Ctrl+Tab Ctrl+PageDown Ctrl+N Ctrl+O Enter Ctrl+Enter Shift+Enter Alt+Enter Ctrl+I Ctrl+U Ctrl+V Ctrl+Shift+Tab Ctrl+PageUp Ctrl+P Ctrl+Shift+Z Ctrl+Y F5 Ctrl+R Ctrl+F5 Ctrl+Shift+R Ctrl+0 Ctrl+S Alt+Enter Ctrl+A Ctrl+L Alt+D Down Up Ctrl+Down Ctrl+Up Alt+[1 to 8] Alt+9 Esc Spacebar Ctrl+Z

Ctrl+K Ctrl+J

e Location bar, type about:config, and press Enter. In the resulting page, search for the preference browser.backspace_action. Double-click

Linux Shift+Scroll down Middle-click on tab Crtl+Scroll up Shift+Scroll up Ctrl+Scroll down Double-Click on Tab Bar Ctrl+click Middle-click Ctrl+Shift+click Shift+Middle-click Shift+click Middle-click on Tab Shift+Reload button Alt+click Alt

backspace_action. Double-click it, and set the value to 0.