F3 − After a name has been created F3 will paste names.

Ctrl + ~ − Switches between showing Excel formulas or their values in cells.

Ctrl + Shift + = − Inserts a new column or row.

Ctrl + - − Deletes the selected column or row.

Shift + Space − Selects the entire row.Ctrl + Space − Selects the entire column.Ctrl + Arrow key − Moves to the next section of text.Ctrl + Shift + − Formats the number in time format.Ctrl + Shift + ^ − Formats the number in scientific format.Ctrl + Shift + % − Formats the number in percentage format.Ctrl + Shift + # − Formats the number in date format.Ctrl + Shift + $ − Formats the number in currency format.Ctrl + Shift + ! − Formats the number in comma format.Ctrl + ' − Inserts the value of the above cell into the cell currently selected.Alt + = − Creates a formula to sum all of the above cells.Ctrl + Tab − Moves between Two or more open Excel files.Ctrl + Page down − Moves between Excel worksheets in the same Excel document.Ctrl + Page up − Moves between Excel worksheets in the same Excel document.Ctrl + F6 − Switches between open workbooks or windows.

Ctrl + F10 − Maximize currently selected window.Ctrl + F9 − Minimizes the current window.Ctrl + P − Brings up the print dialog box to begin printing.Ctrl + 5 − Strikethrough the highlighted selection.Ctrl + 1 − Changes the format of selected cells.

Ctrl + U − Underlines the highlighted selection.Ctrl + I − Italicizes the highlighted selection.Ctrl + A − Selects all contents of the worksheet.Below is the list of all the major shortcut keys in Microsoft Excel for the Windows Operating system.

Excel shortcut keys download