Microsoft Office Excel shortcut keys

By Prof. Fazal Rehman Shamil
Last modified on January 28th, 2021

Microsoft Office Excel shortcut keys

Short Key Description
Alt+Enter Next line
Shift+F3 Open the formula window.
Shift+F5 Show search box.
Ctrl+Shift+; Current time.
Ctrl+; Curernt date.
Alt+Shift+F1 Insert New Worksheet.
F2 Edit the cell as selected.
F4 Repeat the last action.
F5 Move to a specific cell. 
F7 Spelling checking
F11 Create chart from the selected data.
Ctrl+1 Show Format Cells window.
Ctrl+A Select all full contents
Ctrl+B Bold the text
Ctrl+I Italic the text
Ctrl+K Insert the link.
Ctrl+S To save
Ctrl+U Underlining the text.
Ctrl+D Fill down.
Ctrl+R Fills the cell to the right with the contents of the selected cell.
Ctrl+1 Change the format of selected cells.
Ctrl+5 Strikethrough the  text
Ctrl+P To print
Ctrl+Z Undo the last action.
Ctrl+F9 Minimize the current window.
Ctrl+F10 Maximize currently selected window.
Ctrl+F6 Switch between windows or open workbooks.
Ctrl+Shift+1 Format the number in comma format.
Ctrl+Shift+4 Format the number in currency format.
Ctrl+Shift+3 Format the number in date format.
Ctrl+Shift+5 Format the number in a percentage format.
Ctrl+Shift+6 Format the number in scientific format.
Ctrl+Shift+2 Format the number in time format.
Ctrl+Tab Move between 2 or more open Excel files.
Alt+= Create a formula to sum all of the above cells.
Ctrl+’ Insert the value of the above cell into the cell currently selected.
Ctrl+Arrow key Move to next section of text.
Shift+Space Select entire row.
Ctrl+Home Move to cell A1.
Ctrl+~ Switch between showing Excel formulas or their values in cells.
Ctrl+- Delete the selected column or row.
Ctrl+Shift+= Insert a new column or row.
Ctrl+~ Switch between showing Excel formulas or their values in cells.
Ctrl+Home Move to cell A1.
Ctrl+Space Select entire column.
Ctrl+Page up Move between worksheets in the same document.
Ctrl+Page down Move between worksheets in the same document.

Read More 

  1. Microsoft Word MCQs
  2. Microsoft Excel MCQs

  3. Microsoft Office shortcut keys

  4. Microsoft access Solved MCQ’s

  5. MS Access MCQs

  6. Microsoft PowerPoint MCQs

  7. Microsoft Word MCQs

  8. Microsoft Windows and Office MCQs

  9. Microsoft Windows MCQs

  10. Basic MS Office MCQsComputer Science Repeated MCQs Book Download

Prof.Fazal Rehman Shamil (Available for Professional Discussions)
1. Message on Facebook page for discussions,
2. Video lectures on Youtube
3. Email is only for Advertisement/business enquiries.