10 Useful Keyboard Shortcuts for Ms Excel

1. Add border to cells

Shortcuts : Alt+H, B,T

If you want to add an outline (outer) border around your selected cells, just use this quick shortcut.

If you want to add an outline (outer) border around your selected cells, just use this quick shortcut.

If you want to add an outline (outer) border around your selected cells, just use this quick shortcut.

2. Insert Picture

Shortcuts : Alt+N,P

 

If you want to add an Picture  around your selected cells, just use this quick shortcut.

If you want to add an Picture  around your selected cells, just use this quick shortcut.

If you want to add an Picture  around your selected cells, just use this quick shortcut.

3. Formulas SUM Shortcuts Keys

Shortcuts : Alt+M,U,S 

 If you want to Formulas SUM Shortcuts Keys  your selected Value just use this quick shortcuts Keys.

 If you want to Formulas SUM Shortcuts Keys  your selected Value just use this quick shortcuts Key.

 If you want to Formulas SUM Shortcuts Keys  your selected Value just use this quick shortcuts Key. 

4. Insert on Columns and Rows

Shortcuts : Alt+H,I,I

   

 If you want to Insert on Columns and Rows  your selected Value just use this quick shortcuts Key. 


 If you want to Insert on Columns and Rows  your selected Value just use this quick shortcuts Key. 

 If you want to Insert on Columns and Rows  your selected Value just use this quick shortcuts Key. 

Microsoft Excel shortcut keys "Functions Keys Ctrl , Shift , Alt "

Microsoft Excel shortcut keys
Shortcut	Description
Shift+F1	Opens the "What's This?" window.
Shift+F2	Allows the user to edit a cell comment.
Shift+F3	Opens the Excel formula window.
Shift+F5	Brings up a search box.
Shift+F6	Move to previous pane.
Shift+F8	Add to selection.
Shift+F9	Performs calculate function on active sheet.
Ctrl+F3	Open Excel Name Manager.
Ctrl+F4	Closes current Window.
Ctrl+F5	Restores window size.
Ctrl+F6	Next workbook.
Ctrl+Shift+F6	Previous workbook.
Ctrl+F7	Moves the window.
Ctrl+F8	Resizes the window.
Ctrl+F9	Minimize current window.
Ctrl+F10	Maximize currently selected window.
Ctrl+F11	Inserts a macro sheet.
Ctrl+F12	Opens a file.
Ctrl+Shift+F3	Creates names by using those of either row or column labels.
Ctrl+Shift+F6	Moves to the previous worksheet window.
Ctrl+Shift+F12	Prints the current worksheet.
Alt+F1	Inserts a chart.
Alt+F2	Save As option.
Alt+F4	Exits Excel.
Alt+F8	Opens the macro dialog box.
Alt+F11	Opens the Visual Basic editor.
Alt+Shift+F1	Creates a new worksheet.
Alt+Shift+F2	Saves the current worksheet.

Microsoft Excel shortcut keys Functions Keys

Microsoft Excel shortcut keys
Shortcut	Description
F1	Opens the help menu.
F2	Edits the selected cell.
F3	After a name has been created, F3 will paste names.
F4	Repeats last action. For example, if you changed the color of text in another cell, pressing F4 will change the text in cell to the same color.
F5	Goes to a specific cell. For example, C6.
F6	Move to the next pane.
F7	Spell check selected text or document.
F8	Enters Extend Mode.
F9	Recalculates every workbook.
F10	Activates the menu bar.
F11	Creates a chart from selected data.
F12	Save As option.