Microsoft Excel shortcut keys Enter,Backspace

Microsoft Excel shortcut keys
Shortcut	Description
Alt+Tab	Cycles through applications.
Alt+Spacebar	Opens the system menu.
Alt+Backspace	Undo.
Alt+Enter	While typing text in a cell, pressing Alt+Enter will move to the next line, allowing for multiple lines of text in one cell.
Alt+=	Creates a formula to sum all of the above cells.
Alt+'	Allows formatting on a dialog box.

Microsoft Excel shortcut keys Arrow Keys

Microsoft Excel shortcut keys
Shortcut	Description
Shift+Insert	Pastes what is stored on the clipboard.
Shift+Page Up	In a single column, highlights all cells above that are selected.
Shift+Page Down	In a single column, highlights all cells above that are selected.
Shift+Home	Highlights all text to the left of the cursor.
Shift+End	Highlights all text to the right of the cursor.
Shift+Up Arrow	Extends the highlighted area up one cell.
Shift+Down Arrow	Extends the highlighted area down one cell.
Shift+Left Arrow	Extends the highlighted area left one character.
Shift +Right Arrow	Extends the highlighted area right one character.

Microsoft Excel shortcut keys Main Keys

Microsoft Excel shortcut keys
Shortcut	Description
Ctrl+Enter	Fills the selected cells with the current entry.
Ctrl+Spacebar	Selects the entire column.
Ctrl+Shift+Spacebar	Selects the entire worksheet.
Ctrl+Home	Move to cell A1.
Ctrl+End	Move to last cell on worksheet.
Ctrl+Tab	Move between Two or more open Excel files.
Ctrl+Shift+Tab	Activates the previous workbook.
Ctrl+Shift+A	Inserts argument names into a formula.
Ctrl+Shift+F	Opens the drop-down menu for fonts.
Ctrl+Shift+O	Selects all of the cells that contain comments.
Ctrl+Shift+P	Opens the drop-down menu for point size.

Microsoft Excel shortcut keys Others Keys II

Microsoft Excel shortcut keys
Shortcut	Description
Ctrl+Shift+=	Inserts a new column or row.
Ctrl+Shift+~	Switches between showing Excel formulas or their values in cells.
Ctrl+Shift+@	Applies time formatting.
Ctrl+Shift+!	Applies comma formatting.
Ctrl+Shift+$	Applies currency formatting.
Ctrl+Shift+#	Applies date formatting.
Ctrl+Shift+%	Applies percentage formatting.
Ctrl+Shift+^	Applies exponential formatting.
Ctrl+Shift+*	Selects the current region around the active cell.
Ctrl+Shift+&	Places border around selected cells.
Ctrl+Shift+_	Removes a border.
Ctrl++	Insert.
Ctrl+-	Delete.
Ctrl+Shift+(	Unhide rows.
Ctrl+Shift+)	Unhide columns.
Ctrl+/	Selects the array containing the active cell.
Ctrl+\	Selects the cells that have a static value or don’t match the formula in the active cell.
Ctrl+[	Selects all cells referenced by formulas in the highlighted section.
Ctrl+]	Selects cells that contain formulas that reference the active cell.
Ctrl+Shift+{	Selects all cells directly or indirectly referenced by formulas in the highlighted section.
Ctrl+Shift+}	Selects cells which contain formulas that directly or indirectly reference the active cell.
Ctrl+Shift+| (pipe)	Selects the cells within a column that don’t match the formula or static value in the active cell.