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

Excel hotkeys that everyone needs to know

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

Almost everyone uses or has used Excel in one way or another of his 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 collected 40 of the best Excel hotkeys that you need to know!

Using these hot key combinations may seem complicated, but once you memorize them, the pace of your work will be the fastest. If we missed something, or you just want to share your favorite Excel shortcuts, let us know in the comments!

  • F2 : Editing the selected cell / Edit selected cell
  • F4 : Repeat last action / Repeat last edit
  • F9 : Counting all sheets / Calculates all worksheets
  • F11 : New chart / New chart
  • ALT : Access Formula Tips / Access the ribbon for formulas
  • ALT + = : Automatic summation of the selected / Automatically SUM () selected
  • ALT + Enter : New line inside the cell / Start a new line in the same cell
  • ALT + oca : Auto size alignment / Auto size columns
  • PG + UP / PG + DOWN : Go forward / backward through the sheets / Go to next / previous worksheet
  • CTRL + ` : Display Formulas / Display Formulas
  • CTRL + Backspace : Show active cell / Show active cell
  • CTRL + Shift + # : Change the date format / Change Date format with month, day and month
  • CTRL + K : Insert Hyperlink / To insert hyperlink.
  • CTRL + Shift + $ : Applies the currency format to the selected cells.
  • CTRL + Shift + & : Applies border to cells
  • CTRL + B : Bold / Bold
  • CTRL + I : Inclined / Italics
  • CTRL + U : Underline / Underline
  • CTRL + Shift + ~ : Style / General style number
  • CTRL + Shift + $ : Currency style / Currency style number
  • CTRL + Shift +% : Percent style / Percentage style Number
  • CTRL + Shift + ^ : Scientific / notation style
  • CTRL + Shift + # : Date Style / Date Style
  • CTRL + Shift + @ : Style Time / Time Style
  • CTRL + Shift +! : Number Style / Number Style
  • CTRL + F12 : Open / Open
  • CTRL + Spacebar : Select the whole column / Select the entire column
  • CTRL + [ : Select all cells directly by formulas in the selection
  • CTRL +; : Insert the current date in the active cell / Insert
  • CTRL +:: Insert the current time in the active cell / Insert actual time in active cell
  • CTRL + A : Select All
  • CTRL + Shift + J : List of Constants / List Constants
  • CTRL + D : Copy equation down
  • CTRL + F : Find
  • CTRL + H : 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 whole row
  • Shift + F3 : Find Previous / Find Previous