Shortcut key for Excel

May 9, 2017

Useful shortcut keys for Excel

Useful shortcut key for Excel which help you in day to day life, as a professionally many of us usages Excel for their office work and waste their time to format their spreadsheets. We have some useful shortcut keys for Excel which is very useful for you.

F2 Edit selected cell.
F4 Repeat last edit.
F9 Recalculate all worksheets.
F12 Display the Save as dialog.
Ctrl + F1 Display or hide the Ribbon.
Ctrl + PgDn Switch between worksheet tabs.
Ctrl + PgUp Switch between worksheet tabs, moving right to left.
Ctrl+Shift+; Enter the current time.
Ctrl+; Enter the current date.
Ctrl+A Select all contents of the worksheet.
Ctrl+B Bold  selection.
Ctrl+I Italic  selection.
Ctrl+S Save the open worksheet.
Ctrl+U Underline selection.
Ctrl+P Print option.
Ctrl+Z Undo last action.
Ctrl+F3 Open Excel Name Manager.
Ctrl+F6 Switch between open workbooks or windows.
Ctrl+F9 Minimize current window.
Ctrl+Tab Switch between two or more open Excel files.
Ctrl+Shift+1 Format number in comma format.
Ctrl+Space Select entire column.
Ctrl+- Delete the selected column or row.
Ctrl+Home Move to cell A1.
Alt+Shift+F1 Insert New Worksheet.
Alt+Enter Multiple lines of text in one cell.
Shift+F3 Open the Excel formula window.
Shift+F5 Bring up search box.

See Also:-  Shortcut Key For Windows 7.

Leave a Reply