30 useful Excel shortcuts General Shortcuts - Ctrl + N: Create a new workbook - Ctrl + O: Open an existing workbook - Ctrl + S: Save the current workbook - Ctrl + P: Open the Print dialog - Ctrl + Z: Undo the last action - Ctrl + Y: Redo the last action - Ctrl + C: Copy selected cells - Ctrl + X: Cut selected cells - Ctrl + V: Paste copied/cut cells - Ctrl + F: Open the Find dialog - Ctrl + H: Open the Find and Replace dialog - Ctrl + A: Select all cells in the worksheet Navigation & Selection - Ctrl + Arrow Keys: Move to the edge of data regions - Shift + Space: Select the entire row - Ctrl + Space: Select the entire column - Ctrl + Home: Go to cell A1 - Ctrl + End: Go to the last used cell - Alt + Page Up/Down: Move one screen left/right Formatting Shortcuts - Ctrl + B: Apply or remove bold formatting - Ctrl + I: Apply or remove italic formatting - Ctrl + U: Apply or remove underline - Ctrl + 1: Open the Format Cells dialog - Alt + H + O + I: Auto-adjust column width - Alt + H + O + A: Auto-adjust row height Formula & Data Shortcuts - F2: Edit the active cell - Ctrl + ; : Insert current date - Ctrl + Shift + ; : Insert current time - Alt + = : AutoSum selected cells - Ctrl + Shift + L: Toggle filters on/off Dashboard & PivotTable Shortcuts - Alt + N + V: Create a PivotTable - Alt + F1: Create a default chart from selected data - F11: Create a chart in a new sheet - Ctrl + Shift + \ (or Ctrl + A in a data range): Select entire data range - Alt + J + T + L: Refresh PivotTable data