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

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 gathered the 40 best Excel Hotkeys that you need to know in the teeth!

Using these hotkeys may seem difficult, 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 : Skip forward / backward through sheets / Go to next / previous worksheet
  • CTRL + ` : Display Formulas / Display Formulas
  • CTRL + Backspace : Show the 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 + ~ : Style normal / 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 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 : List of Constants / 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 the whole row / Select the entire row
  • Shift + F3 : Find Previous / Find Previous