But to really boost your data-management skills, you’ll need to learn Power Query, a feature that can help you automate data cleanup tasks. Learning these shortcuts and other Excel tricks can help you save time on daily tasks. The shortcuts described here work in Excel 2016 with a US English keyboard layout.

Open the Find dialog box with Ctrl + F (PC) or Control + F (Mac).

Open the formatting dialog box with Ctrl +1 (PC) or Command + 1.

Shift between Excel worksheets with Ctrl + PgUp or PgDn (PC) or Option + → or Option + ← (Mac).

Open Excel Help with F1 (PC) or Command + / (Mac).

Navigate to the last filled cell of a worksheet with Ctrl + End (PC) or Fn + Control + → (Mac).

Navigate to the first cell of a worksheet with Ctrl + Home (PC) or Fn + Control + ← (Mac).

Navigate to the edge of a sheet with Ctrl + any arrow button (PC) or Command + any arrow key (Mac).

Add the current time to a cell with Ctrl + Shift + Colon (PC) or Command + Semicolon (Mac).

Add the current date to a cell with Ctrl + Semicolon (PC) or Control + Semicolon (Mac).

That means developing a repertoire of keyboard shortcuts that can help you create, edit, and navigate your spreadsheet efficiently.Ĭommit these 10 time-saving tricks to memory: If you’re aiming for extreme productivity with Excel, you’ll need to ditch your mouse and keep your hands on the keyboard.

Learning keyboard shortcuts and other Excel tricks can help you save time on daily tasks.

Key shortcuts for excel 2016