This page has been robot translated, sorry for typos if any. Original content here.

Excel hotkeys everyone needs to know

Горячие клавиши для Excel

Almost everyone uses or used Excel in one or another of their work, but almost all of us spend too much time trying to format these annoying, incomprehensible, spreadsheets.

In order to help you work faster and more efficiently, we have compiled the 40 best Excel hotkeys you need to know!

Using these hotkeys may seem complicated, but as soon as you remember them, the pace of your work will be the fastest. If we missed something, or you just want to share your favorite Excel hotkeys, let us know in the comments!

  • F2 : Edit selected cell
  • F4 : Repeat last edit
  • F9 : Calculate all worksheets
  • F11 : New chart
  • ALT : Access the ribbon for formulas
  • ALT + = : Automatically SUM () selected
  • ALT + Enter : Start a new line in the same cell
  • ALT + oca : Auto-align columns / Auto size columns
  • PG + UP / PG + DOWN : Go forward / backward through sheets / Go to next / previous worksheet
  • CTRL + ` : Display Formulas / Display Formulas
  • CTRL + Backspace : Show active cell
  • CTRL + Shift + # : Change Date Format with day, month and year
  • CTRL + K : Insert Hyperlink.
  • CTRL + Shift + $ : Applies the currency format to the selected cells.
  • CTRL + Shift + & : Applies border to cells
  • CTRL + B : Bold
  • CTRL + I : Inclined / Italics
  • CTRL + U : Underline / Underline
  • CTRL + Shift + ~ : General style number
  • CTRL + Shift + $ : Currency style number
  • CTRL + Shift +% : Percentage style Number
  • CTRL + Shift + ^ : Scientific notation style
  • CTRL + Shift + # : Date Style
  • CTRL + Shift + @ : Time Style
  • CTRL + Shift +! : Number Style
  • CTRL + F12 : Open
  • CTRL + Spacebar : Select the entire column
  • CTRL + [ : Select all cells directly referenced by formulas in the selection
  • CTRL +; : Insert actual date in active cell
  • CTRL +:: Insert actual time in active cell
  • CTRL + A : Select All
  • CTRL + Shift + J : List Constants
  • CTRL + D : Copy equation down
  • CTRL + F : Find
  • CTRL + H : Find and Replace / Find & Replace
  • CTRL + Right arrow : Right / Move right
  • CTRL + Left arrow : Left / Move left
  • CTRL + Up arrow : Up / Move up
  • CTRL + Down arrow : Down / Move down
  • CTRL + Enter : Same data in multiple cells
  • Shift + Spacebar : Select the entire row
  • Shift + F3 : Find Previous / Find Previous