Commonly Used Excel Shortcut Keys


"Commonly Used Excel Shortcut Keys"




Shortcut KeyFunction
Ctrl + CCopy
Ctrl + VPaste
Ctrl + XCut
Ctrl + ZUndo
Ctrl + YRedo
Ctrl + SSave
Ctrl + FFind
Ctrl + HReplace
Ctrl + ASelect all
Ctrl + BBold            
Ctrl + NCreate a new workbook
Ctrl + OOpen an existing workbook
Ctrl + PPrint
Ctrl + F2Open Print Preview
Ctrl + F4Close the active workbook
Ctrl + F5Restore the window size of the active workbook
Ctrl + F6Switch between open workbooks
Ctrl + F9Minimize the active workbook window
Ctrl + F10Maximize the active workbook window
Ctrl + TabMove to the next open workbook
Ctrl + Shift + TabMove to the previous open workbook
Alt + =AutoSum
F2Edit the active cell
F4Repeat the last action
F5Go to a specific cell
F7Spell check
F11Create a chart of the selected data
Ctrl + ;Enter the current date
Ctrl + Shift + :Enter the current time
Ctrl + -Delete the selected cells
Ctrl + Shift + +Insert cells, rows, or columns
Ctrl + HomeMove to the beginning of the worksheet
Ctrl + EndMove to the last cell with data in the worksheet
Ctrl + Shift + LApply or remove filters
Ctrl + Shift + $Apply the currency format
Ctrl + Shift + #Apply the date format
Ctrl + Shift + %Apply the percentage format
Ctrl + Shift + &Apply the outline border to the selected cells
Ctrl + Shift + _Remove the outline border from the selected cells
Ctrl + Shift + *Select the current region around the active cell
Ctrl + Shift + ~Apply the general number format
Ctrl + Shift + @Apply the time format
Alt + EnterStart a new line in the same cell
Ctrl + Shift + Arrow keySelect a range of cells
Ctrl + Shift + F3Create names from row and column labels
Ctrl + Shift + F6Switch between open workbooks
Ctrl + Shift + F12Save the current workbook
Ctrl + Alt + VDisplay the Paste Special dialog box
Ctrl + Alt + F1Insert a new worksheet
Ctrl + Alt + F2Save as
Ctrl + Alt + F9Calculate all worksheets in all open workbooks
Ctrl + Alt + F11Open the Microsoft Visual Basic for Applications editor
Alt + F1Create a chart with data in the current range
Alt + F4Close Excel
F1Open the Excel Help window

Please note that these shortcut keys may vary depending on the version of Excel you are using.

Post a Comment

Previous Next

نموذج الاتصال