Microsoft Office Excel shortcut keys

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.

 

Fazal Rehman Shamil
Welcome to all friends. The reason for our success is only your love for T4Tutorials. Our team is always available to answer your queries regarding any kind of confusions or discussion regarding your study and career matters. For discussion with us please join our facebook group "T4Tutorials.com". The link of the group is mentioned below. Thanks and love to all for connecting with us. We are nothing without you. Love you all.....
https://web.facebook.com/groups/2066136233601097/

Leave a Reply