Ctrl + Spacebar: Selects the entire column in the worksheet.ĥ4. Shift + Spacebar: Selects the entire row in the worksheet.ĥ3. Ctrl + Page Down: Switches to the next worksheet in the workbook.ĥ1. Ctrl + Page Up: Switches to the previous worksheet in the workbook.ĥ0. Ctrl + Tab: Switches to the next tab in the workbook.Ĥ9. Ctrl + Shift + Tab: Switches to the previous tab in the workbook.Ĥ8. Ctrl + Shift + ~: Applies or removes the General number format.Ĥ7.

Ctrl + Shift + *: Selects the entire worksheet.Ĥ6. Ctrl + Shift + +: Adds an outline border to the selected cells.Ĥ5. Ctrl + Shift + _: Removes the outline border from the selected cells.Ĥ4.

Ctrl + Shift + &: Changes the number format of the selected cells to the text format.Ĥ3. Ctrl + Shift + ^: Changes the number format of the selected cells to the exponential format.Ĥ2. Ctrl + Shift + %: Changes the number format of the selected cells to the percentage format.Ĥ1. Ctrl + Shift + $: Changes the number format of the selected cells to the currency format.Ĥ0. Ctrl + Shift + #: Changes the number format of the selected cells to the date format.ģ9. Ctrl + Shift + Changes the number format of the selected cells to the time format.ģ8. Ctrl + Shift + !: Changes the number format of the selected cells to the number format.ģ7. Ctrl + ': Copies the value from the cell above the active cell into the cell or the Formula Bar.ģ6. Ctrl + Shift + =: Unhides the selected columns.ģ5. Ctrl + Shift + -: Hides the selected columns.ģ4. Ctrl + Shift + 0: Unhides the selected rows.ģ3. Ctrl + Shift + 9: Hides the selected rows.ģ2. Ctrl + Shift + 8: Adds or removes the outline border from the selected cells.ģ1. Ctrl + Shift + W: Closes all open workbooks.ģ0. Ctrl + Shift + V: Pastes the contents of the clipboard into the selected cells as a picture.Ģ9. Ctrl + Shift + U: Applies or removes underlining.Ģ8. Ctrl + Shift + R: Fills the selected cells with the contents of the cell to the right.Ģ7. Ctrl + Shift + P: Opens the Page Setup dialog box.Ģ6. Ctrl + Shift + N: Applies or removes bold formatting.Ģ5. Ctrl + Shift + F: Opens the Format Cells dialog box.Ģ4. Ctrl + Shift + C: Copies the selected cells as a picture.Ģ3. Ctrl + Shift + A: Inserts a new worksheet.Ģ2. Ctrl + Z: Undoes the last command or action.Ģ1. Ctrl + Y: Repeats the last command or action.Ģ0. Ctrl + V: Pastes the contents of the clipboard into the selected cells.ġ7. Ctrl + U: Applies or removes underlining.ġ6. Ctrl + R: Fills the selected cells with the contents of the cell to the left.ġ5. Ctrl + I: Applies or removes italic formatting.ġ1. Ctrl + H: Opens the Replace dialog box.Ĩ. Ctrl + F: Opens the Find and Replace dialog box.ħ. Ctrl + D: Fills the selected cells with the contents of the cell above.ĥ. Ctrl + B: Applies or removes bold formatting.Ĥ. Ctrl + A: Selects the entire worksheet.Ģ. While there are hundreds of different shortcut keys you can use in Excel, we've compiled a list of the 50+ best shortcuts you need to know to help you boost your productivity.ġ. If you're an Excel power user, you know that shortcut keys are essential for working quickly and efficiently in spreadsheets.

List of shortcut keys for excel