EXCEL SOME OF USEFUL SHORTCUTS
Shortcut key Action Menu equivalent comments
Alt or F10 Menu Go to Menu bar
Alt+’ Format Style dialog box Format the Style
Alt+= Auto Sum Sum Formula Showing in Cell
Alt+Down arrow Display Auto Complete list Displaying Auto Complete Data List
Alt+F1 Insert Chart Insert the Chart
Alt+F11 Visual Basic Editor Tools, Macro, Visual Basic Editor
Alt+F2 Save As Save File to Save As
Alt+F4 Exit File Exit
Alt+F8 Macro dialog box Macro dialog box Tools
Alt+Shift+F1 New worksheet Insert New Worksheet
Alt+Shift+F2 Save Save the File
Ctrl + Shift + L Filter Filter the Row
Ctrl W Close Close the Open File
Ctrl+- Delete Delete the Rows, Columns and Cells Right or Down
Depends on selection
Ctrl+! Format cells dialog box Font Tab Open in Format Cell Tool
Ctrl+# Italic Cell Font Style Change to Italic toggle
Ctrl+$ Underline Cell Font Style Change to Underline toggle
Ctrl+% Strikethrough Cell Font Style Change to Strikethough
Ctrl+( Hide rows Hide the Row
Ctrl+) Hide columns Hide the Columns
Ctrl+; Insert Current Date Add the Current Date
Ctrl+@ Bold Cell Font Style Change to Bold toggle
CTRL+[ Select all cells directly referenced
by formulas in the selection. Reference Contains Cell Easily Find
CTRL+] Select cells that contain formulas
that directly reference the
active cell Reference Formula Cell Easily Find
Ctrl+` Column Width Column Width Increase Double Size
Ctrl++ Insert Insert the Rows, Columns and Cells Right or Down
Depends on selection
Ctrl+A Select All Selecting Entire Sheet
Ctrl+Alt+V Displays the Paste Special dialog box
Available only after you have cut or
copied an object, text, or cell contents
on a worksheet or in another program Purpose Paste and Paste Special
Ctrl+Alt+V, Press A Displays the Paste Special dialog
box, Selecting All Purpose Paste and Paste Special
Ctrl+Alt+V, Press V Displays the Paste Special dialog
box, Selecting Values Purpose Paste and Paste Special
Ctrl+B Bold Cell Font Style Change to Bold toggle
Ctrl+C Copy As Your Wish to Copy Selected Cells
Ctrl+D Fill Down Copy to Down Cell
Ctrl+F Find Find What you Find
Ctrl+F1 Hide the Menu bar Hiding the Menu bar
Ctrl+F10 Maximize or restore Down window Maximize and restore Down the window
Ctrl+F11 Macro sheet Insert the Macro Worksheet
Ctrl+F12 File Open Open the File
Ctrl+F2 Format Shape & Print 1st Side to Open Format Shape Tool, Next Immediately
Open Print Option
Ctrl+F3 Name Manager New Name add to Refer Cell (Any Cell You Want add New Name)
Ctrl+F4 Close Close the Open File
Ctrl+F5 Restore Down Window Size Change
Ctrl+F6 Next workbook Next Workbook Window Change
Ctrl+F7 Move window 1st Change the Window Size Pressing Ctrl+F5, After Window
Move to Any Area
Ctrl+F8 Add to selection Multiple Different Cell Add to Selection
Ctrl+F9 Minimize workbook Minimize the Worksheet
Ctrl+G Go to Type the Reference Cell Number Want to Go
Ctrl+H Replace Find What you Find to Replace With Another Word
Ctrl+I Italic Cell Font Style Change to Italic toggle
Ctrl+K Insert Hyperlink Hyperlink Insert
Ctrl+N New Workbook New File Open
Ctrl+O Open Open File
Ctrl+P Print Print File
Ctrl+R Fill Right Copy to Right Cell
Ctrl+S Save Save the Workbook File
Ctrl+Shift+& outline border around selected cells lace outline border around selected cells
Ctrl+Shift+( Unhide rows Unhide the Hided Rows
Ctrl+Shift+) Unhide columns Unhide the Hided Coloumns
Continue More .....
Page 2 >Page 3 >Page 4 >Page 5 >Page 6 >Page 7 >Page 8 >Page 9 >Page 10 >Page 11
Alt or F10 Menu Go to Menu bar
Alt+’ Format Style dialog box Format the Style
Alt+= Auto Sum Sum Formula Showing in Cell
Alt+Down arrow Display Auto Complete list Displaying Auto Complete Data List
Alt+F1 Insert Chart Insert the Chart
Alt+F11 Visual Basic Editor Tools, Macro, Visual Basic Editor
Alt+F2 Save As Save File to Save As
Alt+F4 Exit File Exit
Alt+F8 Macro dialog box Macro dialog box Tools
Alt+Shift+F1 New worksheet Insert New Worksheet
Alt+Shift+F2 Save Save the File
Ctrl + Shift + L Filter Filter the Row
Ctrl W Close Close the Open File
Ctrl+- Delete Delete the Rows, Columns and Cells Right or Down
Depends on selection
Ctrl+! Format cells dialog box Font Tab Open in Format Cell Tool
Ctrl+# Italic Cell Font Style Change to Italic toggle
Ctrl+$ Underline Cell Font Style Change to Underline toggle
Ctrl+% Strikethrough Cell Font Style Change to Strikethough
Ctrl+( Hide rows Hide the Row
Ctrl+) Hide columns Hide the Columns
Ctrl+; Insert Current Date Add the Current Date
Ctrl+@ Bold Cell Font Style Change to Bold toggle
CTRL+[ Select all cells directly referenced
by formulas in the selection. Reference Contains Cell Easily Find
CTRL+] Select cells that contain formulas
that directly reference the
active cell Reference Formula Cell Easily Find
Ctrl+` Column Width Column Width Increase Double Size
Ctrl++ Insert Insert the Rows, Columns and Cells Right or Down
Depends on selection
Ctrl+A Select All Selecting Entire Sheet
Ctrl+Alt+V Displays the Paste Special dialog box
Available only after you have cut or
copied an object, text, or cell contents
on a worksheet or in another program Purpose Paste and Paste Special
Ctrl+Alt+V, Press A Displays the Paste Special dialog
box, Selecting All Purpose Paste and Paste Special
Ctrl+Alt+V, Press V Displays the Paste Special dialog
box, Selecting Values Purpose Paste and Paste Special
Ctrl+B Bold Cell Font Style Change to Bold toggle
Ctrl+C Copy As Your Wish to Copy Selected Cells
Ctrl+D Fill Down Copy to Down Cell
Ctrl+F Find Find What you Find
Ctrl+F1 Hide the Menu bar Hiding the Menu bar
Ctrl+F10 Maximize or restore Down window Maximize and restore Down the window
Ctrl+F11 Macro sheet Insert the Macro Worksheet
Ctrl+F12 File Open Open the File
Ctrl+F2 Format Shape & Print 1st Side to Open Format Shape Tool, Next Immediately
Open Print Option
Ctrl+F3 Name Manager New Name add to Refer Cell (Any Cell You Want add New Name)
Ctrl+F4 Close Close the Open File
Ctrl+F5 Restore Down Window Size Change
Ctrl+F6 Next workbook Next Workbook Window Change
Ctrl+F7 Move window 1st Change the Window Size Pressing Ctrl+F5, After Window
Move to Any Area
Ctrl+F8 Add to selection Multiple Different Cell Add to Selection
Ctrl+F9 Minimize workbook Minimize the Worksheet
Ctrl+G Go to Type the Reference Cell Number Want to Go
Ctrl+H Replace Find What you Find to Replace With Another Word
Ctrl+I Italic Cell Font Style Change to Italic toggle
Ctrl+K Insert Hyperlink Hyperlink Insert
Ctrl+N New Workbook New File Open
Ctrl+O Open Open File
Ctrl+P Print Print File
Ctrl+R Fill Right Copy to Right Cell
Ctrl+S Save Save the Workbook File
Ctrl+Shift+& outline border around selected cells lace outline border around selected cells
Ctrl+Shift+( Unhide rows Unhide the Hided Rows
Ctrl+Shift+) Unhide columns Unhide the Hided Coloumns
Continue More .....
Page 2 >Page 3 >Page 4 >Page 5 >Page 6 >Page 7 >Page 8 >Page 9 >Page 10 >Page 11