Excel hot keys that you need to know all

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

Almost everyone uses or uses 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 to work faster and more efficiently, we have collected the 40 best Excel Hotkeys that you need to know in the teeth!

The use of these hot keys may seem complicated, but as soon as you remember them, the pace of your work will be faster all. If we missed anything, or you just want to share your favorite hot Excel keys, 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 : Accessing 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-align columns / Auto size columns
  • PG + UP / PG + DOWN : Jump forward / backward through 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 day, month and year
  • 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 : Italics
  • CTRL + U : Underline / Underline
  • CTRL + Shift + ~ : Normal style / General style number
  • CTRL + Shift + $ : Currency style number
  • CTRL + Shift +% : Percentage style / Percentage style Number
  • CTRL + Shift + ^ : Scientific style / Scientific notation style
  • CTRL + Shift + # : Date style / Date style
  • CTRL + Shift + @ : Style Time / Time Style
  • CTRL + Shift +! : Number Style Style
  • CTRL + F12 : Open / Open
  • CTRL + Spacebar : Select the whole column / Select the entire column
  • CTRL + [ : Select all cells directly referenced by formulas in the selection
  • CTRL +; : Inserting the current date in the active cell / Insert actual date in active cell
  • CTRL +:: Insert the current time in the active cell / Insert the actual time in active cell
  • CTRL + A : Select All / Select All
  • CTRL + Shift + J : Constants List / List Constants
  • CTRL + D : Copy down
  • CTRL + F : Find / 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 the cells
  • Shift + Spacebar : Select whole series / Select the entire row
  • Shift + F3 : Find Previous / Find Previous