Ms excel 250 keyboards shortcuts

Page 1

250 MS-Excel Keyboard Shortcuts Main Category Dialog Box Dialog Box Dialog Box Dialog Box Dialog Box Dialog Box Dialog Box Dialog Box Entering Data Entering Data Entering Data Entering Data Entering Data Entering Data Entering Data File File File File File File File File File File File File File File File File File File Format Format Format Format Format Format Format Format Format

Shortcut key Alt+F8 Alt+’ Ctrl+1 Shift+Ctrl+F+F Ctrl+Alt+V Ctrl+T Ctrl+Shift+F Esc Ctrl+shift+: Ctrl+’ Ctrl+: Ctrl+; Ctrl+R Ctrl+Y Ctrl+Delete Shift+F11 Shift+F12 Ctrl+F12 Ctrl+Shift+F12 Alt+Shift+F2 Ctrl+P Ctrl+S Ctrl W F12 Ctrl+F2 Page Up Page Down Left Arrow Right Arrow Up Arrow Down Arrow Tab Enter Ctrl+X Ctrl+Shift+~ Ctrl+Shift+# Ctrl+Shift+$ Ctrl+Shift+% Ctrl+Shift+^ Ctrl++ Ctrl+Ctrl+2


Format Format Format Format Format Format Format Format Format Format Format Format Format Format Format Format Format Format Formulas Formulas Formulas Formulas Formulas Formulas Formulas Formulas Formulas Formulas Formulas Formulas Formulas Formulas Formulas Formulas Formulas General General General General General General General General General General General General

Ctrl+3 Ctrl+4 Ctrl+6 Alt+Enter Shift+Ctrl+F Shift+Ctrl+P Ctrl+B Ctrl+U Ctrl+V Ctrl+Shift+! Shift+F2 Ctrl+I Ctrl + Shift + 1 Ctrl + Shift + 4 Ctrl + Shift + 3 Ctrl + Shift + 5 Ctrl + Shift + 6 Ctrl + Shift + 2 F4 Ctrl+Alt+F9 Ctrl+Alt+Shift+F9 Ctrl+F3 Ctrl+Shift+F3 Alt+= Ctrl+` Ctrl+Shift+A Ctrl+' F3 F9 Shift+F3 Ctrl+Shift+F2 Ctrl+Shift+F8 Ctrl+Shift+F9 Ctrl+Shift+Enter Ctrl+Shift+U Alt+Down arrow Ctrl+8 Alt or F10 Ctrl+K Ctrl+Z F11 Shift Shift+F4 Shift+F5 Alt+F1 F1 F5


General General General General General General General General General General General General General General General General General General General General General General General General General Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys

F7 F10 Shift+F7 Shift+F8 Shift+F9 Shift+F10 Ctrl+F4 Ctrl+F10 Alt+F4 Alt+F6 Alt+F11 Alt+Spacebar Alt+BackSpace Ctrl+E Ctrl+G Ctrl+H Ctrl+J Ctrl+L Ctrl+Tab Ctrl+Shift+I Ctrl+Shift+J Ctrl+F1 Alt+Shift+Right Arrow Alt+Shift+Right Arrow Ctrl+Shift+L Alt+O+C+A Alt+O+C+W Alt+O+R+A Alt+O+R+E Alt+D+P Alt+H, AL Alt+H, AR Alt+H- AC Alt+H, AT Alt+H, AM Alt+H- AB Alt+H, W Alt+H, H Alt+H, FC Alt+H, FS Alt+H, MM Alt+H, MU Alt+H, MC Alt+H, MA Alt+H, M Alt+H, FF Alt+H, FS


Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Hot Keys Navigate Navigate Navigate Navigate Navigate Navigate Navigate Navigate Navigate Navigate Navigate Navigate Navigate Navigate Navigate Navigate Navigate Navigate Navigate Navigate Navigate Navigate Navigate Selection

Alt+H, FP Alt+Y, R Al+M, N Alt+A,VV Alt+N,V Alt+N,T Alt+N, C Alt+N, B Alt+N, O Alt+N, N Alt+N, A11 Alt+N, SD Alt+N, Q Alt+N, D Alt+F, N Alt+F, O Alt+F, S Alt+F, A Alt+F, H Alt+F, E Alt+F, C Alt+F, D Alt+F, T Ctrl+F7 Ctrl+Shift+_ Ctrl+5 Shift+F6 F6 Home End Shift+Left Arrow Shift+Right Arrow Shift+Up Arrow Shift+Down Arrow Shift+Tab Ctrl+Shift+Arrow Key Alt+Tab Ctrl+Home Ctrl+End Ctrl+Page Up Ctrl+Page Down Ctrl+Left Arrow Ctrl+Right Arrow Ctrl+Up Arrow Ctrl+Down Arrow Shift+Enter Ctrl+Shift+&


Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Selection Window Keys Window Keys Window Keys Window Keys Window Keys Window Keys Window Keys Window Keys

Ctrl+Shift+* Ctrl+9 Ctrl+0 Ctrl+Shift+( Ctrl+Shift+) Ctrl+Enter Shift+Spacebar CTRL+/ CTRL+SHIFT+O CTRL+\ CTRL+SHIFT+| CTRL+[ CTRL+SHIFT+{ CTRL+] CTRL+SHIFT+} ALT+; SHIFT+BACKSPACE CTRL+SHIFT+SPACEBAR Ctrl+Alt+L Ctrl+C Ctrl+D Ctrl+" F2 F8 Insert Delete BackSpace Shift+Insert Shift+Home Shift+End Shift+Page Up Shift+Page Down Ctrl+A Ctrl+F Ctrl+Insert Ctrl+Spacebar Ctrl+BackSpace Shift+Delete Ctrl+Shift+Arrow key WK WK+R WK+M Shift+WK+M WK+F1 WK+E WK+F WK+D


Window Keys Window Keys Window Keys Window Keys Window Keys Window Keys Window Keys Window Keys Window Keys Window Keys Workbook Workbook Workbook Workbook Workbook Workbook Workbook Workbook Workbook Workbook

Ctrl+WK+F Ctrl+WK+Tab WK+Tab WK+L WK+P WK+C WK+V WK+K WK+I WK+A Ctrl+F5 Ctrl+F6 Shift+Ctrl+F6 Ctrl+F9 Ctrl+F11 Ctrl+Shift+F6 Alt+Shift+F1 Ctrl+O Shift+Ctrl+Tab Ctrl+N


board Shortcuts Description Macro dialog box To open format style dialog box Format cells dialog box To open the Font tab in Format cells dialog box To displays the "Paste Special" dialog box To display the Create Table dialog box To display the Format cells dialog box Cancel the Command and close dialog box To insert current time Fill the above formula in down To insert current time To insert current date To fill the right To redo the last action To delete to end of word To insert new worksheet To save the file To open the file To give the print To save the file To print the file To save the file To close the file To Save as the file To print the file Go to page up Go to page down Go to left Go to right Go to up Go to down Indent Go to new line To cut the value To convert into general format To convert into date format To convert into currency format To convert into percent format To convert into expontential format To insert the row To delete the row To make font Bold


To make font Italic To underline the Font To show/hide objects the View To Start the new line in same cell To open the Font tab in Format cells dialog box To open the Font tab in Format cells dialog box To make font Bold To underline the font To paste the data To comma format To edit cell comment To make the font Italic To format number in comma format. To format number in currency format. To format number in date format. To format number in percentage format. To format number in scientific format. To format number in time format. To repeat the last action To calculate the worksheet in all open workbook To rechecks dependent formula To define the name To create the names in row and column Sum Function To display formula To insert the argument names into formula To copy formula from cell above To paste name into formula To evaluate the part of formula To paste function into formula To go to last position To step out To clear all breakpoints To Enter the Formula as an Array formula Toggle Expand or Collapse formula bar To display Auto complete list To toggle outline symbols To activate menubar To add the hyperlink To undo the last action To create the Chart Hold down shift for additional functions To find next Find the value To insert chart To open Excel help To open 'Go To' dialog box


To open spell checker dialog box To activate menubar To view object To add selection Quick watch To Show right click menu To close the window To activate menubar To close VBA To switch between last 2 windows To open VBE Go to system menu To undo the last action To Export module Display 'Go to Dialog" box Replace the value List Properties/Methods Show Call Stack Go to cycle windows To Edit Parameter Info To Edit List Constants To display or hide the ribbons To Group Rows or Columns Ungroup Rows or Columns To Add/Remove the filter To Adjust Column Width to Fit the Content To Adjust Column Width to Specific Value To Adjust Row Height to Fit the Content To Adjust Row Height to Specific Value To Open Pivot Table wizard Align Left Align Right Align Cight Align Top Align Middle Align Bottom To wrap the text Highlight Cell (change cell backgroudn color) Font Color Font Size Merge Cells - Merge Merge Cells - Unmerge Merge Cells - Merge and Center Merge Cells - Merge Across To merge the text To change the font style To change the font size


Fomat painter To record macro To Open dialog box of Name Manager To open Data Validation dialog box To insert the Pivot Table To insert the Table To insert Column chart To insert Bar chart To insert Stock, Surface and Radar chart To insert Line Chart To insert Area Chart To insert Combo Chart To insert Pie Chart To insert Scatter Chart To open new worksheet To open the file To save the file To Save as the file To share the file To export the file To close the file To check the account To open the Excel options To move window To remove the outline border around selected cell To apply/remove strike through formatting To move previous pane To move next pane Move to beginning of line Move to end of line Extend selection left side Extend selection right side Extend selection up side Extend selection down side Outdent Extend the selection of cells to the last nonblank cell in the same column or row as the active cell. Move to cycle applications Top Of Module End Of Module Go to top of current procedure in another sheet Go to top of current procedure in another sheet Move one word to left Move one word to right Go to up till the blank cell Go to down till the blank cell Enter to Move up To place the outline border around selected cell


To insert current time To hide rows To hide columns To unhide rows To unhide columns To fill the selected cell range with the current entry To select the entire row To select the array containing the active cell. To select all cells that contain comments. To select the cells that don't match the formula To select the cells that don't match the formula To select cells directly referenced by formulas in the selection. To select cells directly/indirectly referenced by formulas To select cells contain formulas directly reference the selection To select cells directly/indirectly referenced by formulas To select the visible cells in the current selection. To select only active cell To select the entire worksheet To reapply the filter and sort on the current range To copy the selected values To fill down To fill down To edit active cell To extend selection mode Toggle insert mode To delete the selected values To delete previous entry To paste the data Select from start of line Select till end of line Select to top of module Select to end of module To select all data without blanks Find the value To copy the selected values Select the complete row Go to delete to start of word To cut the selection To select the data from first active cell to last active cell To start the menu Run dialog box Minimize all Undo minimize all To help To open Window Explorer To find files or folder To minimize all open windows and display the desktop


To Find Computer To Quick launch toolbar Cycle through taskbar buttons To log off windows To start print manager To open Control Panel To start Clipboard To open keyboard properties dialog box To open mouse properties dialog box To start accessibility options XL, Restore window size Next workbook window Previous workbook window To minimize workbook To open VBE For Previous Window To open new worksheet To open workbook To activate previous workbook To create new workook





active cell.


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.