{"id":98377,"date":"2021-07-19T09:00:15","date_gmt":"2021-07-19T03:30:15","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=98377"},"modified":"2021-07-15T20:10:31","modified_gmt":"2021-07-15T14:40:31","slug":"excel-shortcut-keyboard-keys","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/excel-shortcut-keyboard-keys\/","title":{"rendered":"Excel Keyboard Shortcuts"},"content":{"rendered":"

In Microsoft Excel, there are various keyboard shortcuts that help the user speed up the work. As there are many shortcuts, the user can’t remember or memorize all the keyword combos. Each user’s needs vary in everyday life and remembering the required shortcut keys would be widely helpful to the excel users. In this article, we will cover the complete list of shortcut keys in excel.<\/p>\n

Excel General Program Shortcut Keys<\/h3>\n

The shortcut keys in the below table provide the shortcut keys to move around and switch between the worksheets and workbooks. This table comprises basic activity keyboard shortcuts in excel.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Shortcut Key<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
Ctrl+N<\/span><\/td>\nTo create a new workbook<\/span><\/td>\n<\/tr>\n
Ctrl+O<\/span><\/td>\nTo open an existing workbook<\/span><\/td>\n<\/tr>\n
Ctrl+S<\/span><\/td>\nTo save a workbook<\/span><\/td>\n<\/tr>\n
F12\u00a0<\/span><\/td>\nTo open the Save As dialog box<\/span><\/td>\n<\/tr>\n
Ctrl+W\u00a0<\/span><\/td>\nTo close a workbook<\/span><\/td>\n<\/tr>\n
Ctrl+F4\u00a0<\/span><\/td>\nTo close Excel<\/span><\/td>\n<\/tr>\n
Ctrl+Z\u00a0<\/span><\/td>\nTo undo an action<\/span><\/td>\n<\/tr>\n
Ctrl+Y<\/span><\/td>\nTo redo an action<\/span><\/td>\n<\/tr>\n
Ctrl+F2\u00a0<\/span><\/td>\nTo switch to Print Preview<\/span><\/td>\n<\/tr>\n
F1\u00a0<\/span><\/td>\nTo open the Help pane<\/span><\/td>\n<\/tr>\n
F7\u00a0<\/span><\/td>\nTo check spelling<\/span><\/td>\n<\/tr>\n
Shift+F11\u00a0<\/span><\/td>\nTo insert a new worksheet<\/span><\/td>\n<\/tr>\n
Alt+Q<\/span><\/td>\nHelps you to navigate to go to the \u201cTell me what you want to do\u201d box.<\/span><\/td>\n<\/tr>\n
F9\u00a0<\/span><\/td>\nTo calculate all worksheets in all open workbooks<\/span><\/td>\n<\/tr>\n
Alt or F10\u00a0<\/span><\/td>\nHelps you turn key tips on or off.<\/span><\/td>\n<\/tr>\n
Shift+F9\u00a0<\/span><\/td>\nTo calculate active worksheets<\/span><\/td>\n<\/tr>\n
F4<\/span><\/td>\nTo repeat the last command or action.<\/span><\/td>\n<\/tr>\n
Ctrl+Shift+U\u00a0<\/span><\/td>\nTo expand or collapse the formula bar<\/span><\/td>\n<\/tr>\n
Ctrl+F9\u00a0<\/span><\/td>\nTo minimize the workbook window<\/span><\/td>\n<\/tr>\n
Alt+F<\/span><\/td>\nTo open the File tab menu<\/span><\/td>\n<\/tr>\n
Alt+H<\/span><\/td>\nTo go to the Home tab<\/span><\/td>\n<\/tr>\n
Alt+N<\/span><\/td>\nTo open the insert tab<\/span><\/td>\n<\/tr>\n
Alt+P<\/span><\/td>\nTo go to the Page Layout tab<\/span><\/td>\n<\/tr>\n
F11<\/span><\/td>\nTo create a bar chart based on selected data in a separate sheet.<\/span><\/td>\n<\/tr>\n
Alt+F1<\/span><\/td>\n To create an embedded bar chart based on select data (same sheet)<\/span><\/td>\n<\/tr>\n
Ctrl+F<\/span><\/td>\n To search in a spreadsheet<\/span><\/td>\n<\/tr>\n
Alt+M\u00a0<\/span><\/td>\nTo go to the Formulas tab<\/span><\/td>\n<\/tr>\n
Alt+A\u00a0<\/span><\/td>\nTo go to the Data tab<\/span><\/td>\n<\/tr>\n
Alt+R<\/span><\/td>\nTo go to the Review tab<\/span><\/td>\n<\/tr>\n
Alt+W\u00a0<\/span><\/td>\nTo go to the View tab<\/span><\/td>\n<\/tr>\n
Alt+X\u00a0<\/span><\/td>\nTo go to the Add-ins tab<\/span><\/td>\n<\/tr>\n
Alt+Y\u00a0<\/span><\/td>\nTo go to the Help tab<\/span><\/td>\n<\/tr>\n
Ctrl+Tab\u00a0<\/span><\/td>\nTo switch between open workbooks<\/span><\/td>\n<\/tr>\n
Shift+F3\u00a0<\/span><\/td>\nTo insert a function<\/span><\/td>\n<\/tr>\n
Alt+F8\u00a0<\/span><\/td>\nTo create, run, edit, or delete a macro<\/span><\/td>\n<\/tr>\n
Alt+F11\u00a0<\/span><\/td>\nTo open the Microsoft Visual Basic For Applications Editor<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Shortcut keys for Moving Around in a Worksheet or Cell in Excel<\/h3>\n

There are shortcut keys to navigate around the worksheet, within a cell and throughout the entire excel.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Shortcut Key<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
Left Arrow\u00a0<\/span><\/td>\nTo move one cell to the left.<\/span><\/td>\n<\/tr>\n
Right Arrow<\/span><\/td>\nTo move one cell to the right<\/span><\/td>\n<\/tr>\n
Ctrl+Left Arrow<\/span><\/td>\nTo move to the farthest left cell in the row<\/span><\/td>\n<\/tr>\n
Ctrl+Right Arrow<\/span><\/td>\nTo move to the farthest right cell in the row<\/span><\/td>\n<\/tr>\n
Down Arrow\u00a0<\/span><\/td>\nTo move one cell down<\/span><\/td>\n<\/tr>\n
Up Arrow\u00a0<\/span><\/td>\nTo move one cell up<\/span><\/td>\n<\/tr>\n
Ctrl+Down Arrow\u00a0<\/span><\/td>\nTo move to the bottom cell in the column<\/span><\/td>\n<\/tr>\n
Ctrl+Up Arrow\u00a0<\/span><\/td>\nTo move to the top cell in the column<\/span><\/td>\n<\/tr>\n
Tab<\/span><\/td>\n To go to the next cell<\/span><\/td>\n<\/tr>\n
Shift+Tab\u00a0<\/span><\/td>\nTo go to the previous cell<\/span><\/td>\n<\/tr>\n
Ctrl+End\u00a0<\/span><\/td>\nTo go to the most bottom right used cell<\/span><\/td>\n<\/tr>\n
F5\u00a0<\/span><\/td>\nTo go to any cell by pressing F5 and typing the cell coordinate or cell name.<\/span><\/td>\n<\/tr>\n
Home<\/span><\/td>\nTo go to the leftmost cell in the current row (or go to the beginning of the cell if editing a cell)<\/span><\/td>\n<\/tr>\n
Ctrl+Home\u00a0<\/span><\/td>\nTo move to the beginning of a worksheet<\/span><\/td>\n<\/tr>\n
Page Down\u00a0<\/span><\/td>\nTo move the cursor down in a worksheet<\/span><\/td>\n<\/tr>\n
Page Up<\/span><\/td>\nTo move the cursor up in a worksheet<\/span><\/td>\n<\/tr>\n
Alt+Page Down\u00a0<\/span><\/td>\nTo move the cursor to the right in a worksheet<\/span><\/td>\n<\/tr>\n
Alt+Page Up<\/span><\/td>\nTo move the cursor to the left in a worksheet<\/span><\/td>\n<\/tr>\n
Ctrl+Page Down\u00a0<\/span><\/td>\nTo move to the next worksheet<\/span><\/td>\n<\/tr>\n
Ctrl+Page Up<\/span><\/td>\nTo move to the previous worksheet<\/span><\/td>\n<\/tr>\n
End<\/span><\/td>\nThe user can turn on or off the end mode.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Excel Keyboard Shortcuts for Selecting Cells<\/h4>\n

To speed up the selections in excel, the user can use few shortcut keys to rapidly do the work:<\/p>\n\n\n\n\n\n\n\n\n
Shortcut Key<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
Shift+Left Arrow<\/span><\/td>\nTo extend the cell selection to the left\u00a0<\/span><\/td>\n<\/tr>\n
Shift + Right Arrow<\/span><\/td>\nTo extend the cell selection to the right<\/span><\/td>\n<\/tr>\n
Shift+Space\u00a0<\/span><\/td>\nTo select the entire row<\/span><\/td>\n<\/tr>\n
Ctrl+Space<\/span><\/td>\nTo select the entire column<\/span><\/td>\n<\/tr>\n
Ctrl+Shift+Space\u00a0<\/span><\/td>\nTo select the entire worksheet<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Shotcut keys in Excel for Editing Cells<\/h4>\n

The user can also edit the cells in the sheet and the few shortcut keys listed below are the keys to edit the cells in Excel:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Shortcut Key<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
F2\u00a0<\/span><\/td>\nTo edit a cell<\/span><\/td>\n<\/tr>\n
Shift+F2\u00a0<\/span><\/td>\nTo add or edit a cell comment<\/span><\/td>\n<\/tr>\n
Ctrl+X\u00a0<\/span><\/td>\nTo cut the contents of a cell or selected cell range.<\/span><\/td>\n<\/tr>\n
Ctrl+C\u00a0<\/span><\/td>\nTo copy the contents of a cell or selected cell range.<\/span><\/td>\n<\/tr>\n
Ctrl+V\u00a0\u00a0<\/span><\/td>\nTo paste the contents of a cell, selected data, or selected cell range<\/span><\/td>\n<\/tr>\n
Ctrl+Alt+V\u00a0<\/span><\/td>\nTo open the Paste Special dialog box<\/span><\/td>\n<\/tr>\n
Delete\u00a0<\/span><\/td>\nTo remove the contents of a cell.<\/span><\/td>\n<\/tr>\n
F3\u00a0<\/span><\/td>\nTo paste a cell name if the cells are named in the spreadsheet.<\/span><\/td>\n<\/tr>\n
Alt+H+D+C\u00a0<\/span><\/td>\nTo delete the column<\/span><\/td>\n<\/tr>\n
Esc\u00a0<\/span><\/td>\nTo cancel an entry in a cell or the formula bar.<\/span><\/td>\n<\/tr>\n
Enter\u00a0<\/span><\/td>\nClick on it when the entry is done completely.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Excel Shortcut keys for Formatting Cells<\/h4>\n

Let’s see few shortcut keys to format the cells in Excel:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Shortcut key<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
Ctrl+B\u00a0<\/span><\/td>\nTo add or remove bold to the contents of a cell, selected data, or selected cell range<\/span><\/td>\n<\/tr>\n
Ctrl+I\u00a0<\/span><\/td>\nTo add or remove italics to the contents of a cell, selected data, or selected cell range<\/span><\/td>\n<\/tr>\n
Ctrl+U\u00a0<\/span><\/td>\nTo add or remove underline to the contents of a cell, selected data, or selected cell range<\/span><\/td>\n<\/tr>\n
Alt+H+H\u00a0<\/span><\/td>\nTo select a fill color<\/span><\/td>\n<\/tr>\n
Alt+H+B\u00a0<\/span><\/td>\nTo add a border<\/span><\/td>\n<\/tr>\n
Ctrl+Shift+&<\/span><\/td>\nTo apply outline border<\/span><\/td>\n<\/tr>\n
Ctrl+9<\/span><\/td>\nTo hide the selected rows<\/span><\/td>\n<\/tr>\n
Ctrl+0<\/span><\/td>\nTo hide the selected columns<\/span><\/td>\n<\/tr>\n
Ctrl+1<\/span><\/td>\nTo open the Format Cells dialog box<\/span><\/td>\n<\/tr>\n
Ctrl+5\u00a0<\/span><\/td>\nTo apply or remove strikethrough<\/span><\/td>\n<\/tr>\n
Ctrl+Shift+$\u00a0<\/span><\/td>\nTo apply currency format<\/span><\/td>\n<\/tr>\n
Ctrl+Shift+%\u00a0<\/span><\/td>\nTo apply percent format<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Excel Shortcuts for Select Special<\/h4>\n

There are different types of dialog boxes available for different functions. To access the select special category, we can make use of the following shortcut keys.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Shortcut Keys<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
Ctrl + G<\/span><\/td>\n\u2018Go To\u2019 Dialog Box<\/span><\/td>\n<\/tr>\n
Ctrl + Shift + O<\/span><\/td>\nChoosing cells with comments<\/span><\/td>\n<\/tr>\n
Ctrl + Shift + *\u00a0<\/span><\/td>\nChoosing current region around active cell<\/span><\/td>\n<\/tr>\n
Ctrl + A<\/span><\/td>\nChoosing current region<\/span><\/td>\n<\/tr>\n
Ctrl + \/<\/span><\/td>\nChoosing current array<\/span><\/td>\n<\/tr>\n
Ctrl + \\<\/span><\/td>\nChoosing row differences<\/span><\/td>\n<\/tr>\n
Ctrl + Shift + |<\/span><\/td>\nChoosing column differences<\/span><\/td>\n<\/tr>\n
Ctrl + Shift + {<\/span><\/td>\nChoosing all precedents<\/span><\/td>\n<\/tr>\n
Ctrl + Shift + }<\/span><\/td>\nChoosing all dependants<\/span><\/td>\n<\/tr>\n
Alt + ;<\/span><\/td>\nChoosing visible cells only<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Shortcut keys in Excel for Number Formatting<\/h3>\n

Excel can hold a lot of data and those data can be of numeric types. To change the format of the numerics, we can use the following commands as per the requirement.<\/p>\n\n\n\n\n\n\n\n\n\n\n
Shortcut Keys<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
Ctrl +Shift + !<\/span><\/td>\nApplying number formatting to the cell<\/span><\/td>\n<\/tr>\n
Ctrl +Shift + @<\/span><\/td>\nApplying time formatting to the cell<\/span><\/td>\n<\/tr>\n
Ctrl +Shift + %<\/span><\/td>\nApplying percentage formatting to the cell<\/span><\/td>\n<\/tr>\n
Ctrl +Shift + ^<\/span><\/td>\nApplying scientific format to the cell<\/span><\/td>\n<\/tr>\n
Ctrl +Shift + $<\/span><\/td>\nApplying currency format to the cell<\/span><\/td>\n<\/tr>\n
Ctrl +Shift + ~<\/span><\/td>\nApplying general format to the cell<\/span><\/td>\n<\/tr>\n
Ctrl +Shift + #<\/span><\/td>\nApplying date format to the cell<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Excel Shortcuts for Borders<\/h3>\n

The Excel users can also add borders to the tables in Excel and they can also make changes in the border by using the following commands.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
Shortcut Keys<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
Ctrl + Shift + &<\/span><\/td>\nAdding Border outline<\/span><\/td>\n<\/tr>\n
Alt + R<\/span><\/td>\nAdding or Removing Border right\u00a0<\/span><\/td>\n<\/tr>\n
Alt + L<\/span><\/td>\nAdding or Removing Border Left\u00a0<\/span><\/td>\n<\/tr>\n
Alt + T<\/span><\/td>\nAdding or Removing Border Top\u00a0<\/span><\/td>\n<\/tr>\n
Alt + B<\/span><\/td>\nAdding or Removing Border Bottom<\/span><\/td>\n<\/tr>\n
Alt + H<\/span><\/td>\nAdding or Removing horizontal interior border<\/span><\/td>\n<\/tr>\n
Alt + V<\/span><\/td>\nAdding or Removing vertical interior border<\/span><\/td>\n<\/tr>\n
Ctrl + Shift\u00a0<\/span><\/td>\nAdding or Removing Borders<\/span><\/td>\n<\/tr>\n
Alt + D<\/span><\/td>\nAdding or Removing upward diagonal Border<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Excel Keyboard Shortcuts for Formulas<\/h3>\n

There are enormous formulas available in MS-Excel and they can be accessed by using the following commands.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Shortcut Keys<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
F4<\/span><\/td>\nToggling between absolute and relative referencing<\/span><\/td>\n<\/tr>\n
Shift + F3<\/span><\/td>\nTo open the insert function dialog box<\/span><\/td>\n<\/tr>\n
Alt+=<\/span><\/td>\nTo autosum the selected cells<\/span><\/td>\n<\/tr>\n
Ctrl + \u2018<\/span><\/td>\nToggling formulas between on and off<\/span><\/td>\n<\/tr>\n
Ctrl +Shift + A<\/span><\/td>\nInserting function arguments<\/span><\/td>\n<\/tr>\n
Ctrl + Shift + Enter<\/span><\/td>\nEntering array formula<\/span><\/td>\n<\/tr>\n
F9<\/span><\/td>\nCalculating the worksheets<\/span><\/td>\n<\/tr>\n
Shift + F9<\/span><\/td>\nCalculating the active worksheet<\/span><\/td>\n<\/tr>\n
Ctrl + Alt + F9<\/span><\/td>\nForce calculating all worksheets<\/span><\/td>\n<\/tr>\n
Ctrl + Shift + U<\/span><\/td>\nExpanding or collapsing the formula bar<\/span><\/td>\n<\/tr>\n
Ctrl + F3<\/span><\/td>\nOpening the name manager<\/span><\/td>\n<\/tr>\n
F3<\/span><\/td>\nPasting the name into formula<\/span><\/td>\n<\/tr>\n
Ctrl + Shift + F3<\/span><\/td>\nDefining the name using the row and column labels<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Excel Keyboard Shortcuts Keys for Grid Operations<\/h3>\n

The grid operations help the user to differentiate between the specific cells and few shortcut keys to access the grid operations are<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Shortcut Keys<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
Ctrl + Shift + +<\/span><\/td>\nTo Insert the Rows and Columns<\/span><\/td>\n<\/tr>\n
Ctrl –<\/span><\/td>\nTo delete either the columns or rows<\/span><\/td>\n<\/tr>\n
Ctrl + 0<\/span><\/td>\nTo hide the columns<\/span><\/td>\n<\/tr>\n
Ctrl + 9<\/span><\/td>\nTo hide the rows<\/span><\/td>\n<\/tr>\n
Delete<\/span><\/td>\nDeleting the contents of chosen cells<\/span><\/td>\n<\/tr>\n
Ctrl + Shift + 9\u00a0<\/span><\/td>\nUnhide Rows<\/span><\/td>\n<\/tr>\n
Ctrl + Shift + 0\u00a0<\/span><\/td>\nUnhide Columns<\/span><\/td>\n<\/tr>\n
Alt + Shift + Right Arrow<\/span><\/td>\nGrouping the rows or columns<\/span><\/td>\n<\/tr>\n
Alt + Shift + Left Arrow<\/span><\/td>\nUngrouping the rows or columns<\/span><\/td>\n<\/tr>\n
Ctrl + 8<\/span><\/td>\nTo hide or unhide outline symbols<\/span><\/td>\n<\/tr>\n
Ctrl + Alt + +<\/span><\/td>\nTo Zoom in<\/span><\/td>\n<\/tr>\n
Ctrl + Alt –<\/span><\/td>\nTo Zoom out<\/span><\/td>\n<\/tr>\n
Ctrl + Scroll<\/span><\/td>\nTo Zoom scroll<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Shortcut keys in Excel for Pivot Tables<\/h3>\n

Pivot tables in excel help the user to summarize the data and the following are the keyboard shortcuts to access the pivot table features.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n
Shortcut Keys<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
Ctrl + A<\/span><\/td>\nTo select the entire pivot table<\/span><\/td>\n<\/tr>\n
Space\u00a0<\/span><\/td>\nToggling between pivot table field checkbox<\/span><\/td>\n<\/tr>\n
Alt + Shift + Right Arrow\u00a0<\/span><\/td>\nGrouping the table items<\/span><\/td>\n<\/tr>\n
Alt + Shift + Left Arrow\u00a0<\/span><\/td>\nUngrouping the table items<\/span><\/td>\n<\/tr>\n
Ctrl –<\/span><\/td>\nHiding the pivot table item<\/span><\/td>\n<\/tr>\n
Alt + F1<\/span><\/td>\nCreating the pivot chart on same worksheet<\/span><\/td>\n<\/tr>\n
F11<\/span><\/td>\nCreating the pivot chart on new worksheet<\/span><\/td>\n<\/tr>\n
Alt + D + P<\/span><\/td>\nTo open the pivot table wizard<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Other Excel Shortcut Keys<\/h3>\n

The following shortcut keys are some of the other shortcut keys to access other commands in excel.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
Shortcut Keys<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
F7<\/span><\/td>\nTo open spelling dialog box<\/span><\/td>\n<\/tr>\n
Shift + F7<\/span><\/td>\nTo open thesaurus dialog box<\/span><\/td>\n<\/tr>\n
Alt + F8<\/span><\/td>\nTo open macro dialog box<\/span><\/td>\n<\/tr>\n
Alt + F11<\/span><\/td>\nTo open the VBA editor<\/span><\/td>\n<\/tr>\n
Ctrl + D<\/span><\/td>\nTo set up the duplicate object<\/span><\/td>\n<\/tr>\n
Ctrl + 6<\/span><\/td>\nTo hide or show objects<\/span><\/td>\n<\/tr>\n
Shift + F10<\/span><\/td>\nTo display right click menu<\/span><\/td>\n<\/tr>\n
Shift + F10 + D<\/span><\/td>\nTo delete a comment<\/span><\/td>\n<\/tr>\n
Alt + Space<\/span><\/td>\nTo display the control menu<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Summary<\/h3>\n

The article contains different keyboard shortcuts for different uses in Excel. Each and every user cannot remember every shortcut but they could remember the shortcut keys which could fasten up their work in Excel. This is where the shortcut keys come in handy to the users.<\/p>\n","protected":false},"excerpt":{"rendered":"

In Microsoft Excel, there are various keyboard shortcuts that help the user speed up the work. As there are many shortcuts, the user can’t remember or memorize all the keyword combos. Each user’s needs...<\/p>\n","protected":false},"author":1,"featured_media":98385,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24129],"tags":[24772,24771,24773],"class_list":["post-98377","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ms-excel","tag-excel-keyboard-shortcut-keys","tag-excel-keyboard-shortcuts","tag-excel-keyboards-shortcut"],"yoast_head":"\nExcel Keyboard Shortcuts - DataFlair<\/title>\n<meta name=\"description\" content=\"In Microsoft Excel, there are variety of keyboard shortcuts that help the user to speed up the work. Learn about these excel shortcut keys.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/excel-shortcut-keyboard-keys\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Keyboard Shortcuts - DataFlair\" \/>\n<meta property=\"og:description\" content=\"In Microsoft Excel, there are variety of keyboard shortcuts that help the user to speed up the work. Learn about these excel shortcut keys.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/excel-shortcut-keyboard-keys\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-19T03:30:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/Excel-Shortcut-Keys.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Keyboard Shortcuts - DataFlair","description":"In Microsoft Excel, there are variety of keyboard shortcuts that help the user to speed up the work. Learn about these excel shortcut keys.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/excel-shortcut-keyboard-keys\/","og_locale":"en_US","og_type":"article","og_title":"Excel Keyboard Shortcuts - DataFlair","og_description":"In Microsoft Excel, there are variety of keyboard shortcuts that help the user to speed up the work. Learn about these excel shortcut keys.","og_url":"https:\/\/data-flair.training\/blogs\/excel-shortcut-keyboard-keys\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2021-07-19T03:30:15+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/Excel-Shortcut-Keys.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/excel-shortcut-keyboard-keys\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/excel-shortcut-keyboard-keys\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/b49855299264df5e27e3ec6c2cd9fde9"},"headline":"Excel Keyboard Shortcuts","datePublished":"2021-07-19T03:30:15+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/excel-shortcut-keyboard-keys\/"},"wordCount":1775,"commentCount":1,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/excel-shortcut-keyboard-keys\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/Excel-Shortcut-Keys.jpg","keywords":["Excel Keyboard shortcut keys","Excel Keyboard Shortcuts","Excel Keyboards Shortcut"],"articleSection":["MS Excel Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/excel-shortcut-keyboard-keys\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/excel-shortcut-keyboard-keys\/","url":"https:\/\/data-flair.training\/blogs\/excel-shortcut-keyboard-keys\/","name":"Excel Keyboard Shortcuts - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/excel-shortcut-keyboard-keys\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/excel-shortcut-keyboard-keys\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/Excel-Shortcut-Keys.jpg","datePublished":"2021-07-19T03:30:15+00:00","description":"In Microsoft Excel, there are variety of keyboard shortcuts that help the user to speed up the work. Learn about these excel shortcut keys.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/excel-shortcut-keyboard-keys\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/excel-shortcut-keyboard-keys\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/excel-shortcut-keyboard-keys\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/Excel-Shortcut-Keys.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/Excel-Shortcut-Keys.jpg","width":1200,"height":628,"caption":"Excel keyboard Shortcuts"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/excel-shortcut-keyboard-keys\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"MS Excel Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/ms-excel\/"},{"@type":"ListItem","position":3,"name":"Excel Keyboard Shortcuts"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/b49855299264df5e27e3ec6c2cd9fde9","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ef46b745ddad2fad690af626c6ef29b91809ad0a9f5ef398d07817d8cad042f5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ef46b745ddad2fad690af626c6ef29b91809ad0a9f5ef398d07817d8cad042f5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ef46b745ddad2fad690af626c6ef29b91809ad0a9f5ef398d07817d8cad042f5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team is a group of passionate educators and industry experts dedicated to providing high-quality online learning resources on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. With years of experience in the field, the team aims to simplify complex topics and help learners advance their careers. At DataFlair, we believe in empowering students and professionals with the knowledge and skills needed to thrive in today\u2019s fast-paced tech industry. Follow us for Free courses, expert insights, tutorials, and practical tips to boost your learning journey.","url":"https:\/\/data-flair.training\/blogs\/author\/datafbdad\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/98377","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=98377"}],"version-history":[{"count":2,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/98377\/revisions"}],"predecessor-version":[{"id":98386,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/98377\/revisions\/98386"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/98385"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=98377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=98377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=98377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}