Semper Phone

Effortless
LEARNING

  • Improve effortlessly – just by living your life
  • Learn while waiting for your apps to load
  • Recommended by 5 universities
  • Community of over 1,000,000 learners
  • 50,000+ expert-made packs, or create your own
"One of the best learning apps" - CNET
  • Apple Play Store
  • Install Semper from the Play Store
Excel Shortcuts

Excel Shortcuts

Last update 

These are commonly used Excel shortcuts/hotkeys that are used in data entry. This is currently a work in progress and will be updated.

Items (20)

  • Copy a formula

    Ctrl + C

  • Paste Values

    Alt + E + S + V

  • Paste Formulas

    Alt + E + S + T

  • Select all cells down a column

    Shift + End + DownArrow

  • Undo Last Action

    Ctrl + Z

  • Edit a formula within a cell

    F2

  • Toggle between cell references

    F4

  • Open Find Dialog

    Ctrl + F

  • Open Replace Dialog

    Ctrl + H

  • Insert a Row or Column

    Ctrl + "+"

  • Delete a Row or Column

    Ctrl + "-"

  • Toggle Between Worksheets to the Right

    Ctrl + PageDown

  • Toggle Between Worksheets to the Left

    Ctrl + PageUp

  • Open New Workbook

    Ctrl + N

  • Close Current Workbook

    Ctrl + W

  • Open VBA Window

    Alt + F11

  • Insert new worksheet within workbook

    Shift + F11

  • Rename the worksheet

    Alt + O + H + R

  • Delete worksheet

    Alt + E + L

  • Insert a Pivot Table

    Alt + N + V + T