Tag Archive: Shortcut

Articles sur le thème : Shortcut

Function SUM

This is the most commonly formula used and also the simplest to use. We will see in this page, different methods to perform a SUM in Excel. Presentation of the SUM function To perform a SUM function in Excel You simply start with the = sign in your cell Then, you enter the word SUM Then …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/function-sum/

Shorcuts – Function Key

At the beginning of the computer technology, the Function keys were really useful. Nowadays, these keys become less useful but some of them are still really important if you work daily with Excel. Discover all the shortcuts with the Function Key Function keys alone Help Toogle to the Edit mode Paste name formula (if you …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/shortcuts-function-key/

Shortcuts – Control Key

Discover all the shortcuts with the Control Key Shortcut with letter + Select all cells around the active cell (non-empty) Select all cells of your worksheet (if the active cell is empty) When you fill a formula, Ctrl + A display the formula’s Dialog box. + Toogle Bold + Copy + Fill Down Duplicate an …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/shortcuts-control-key/

Shortcuts – Alt Key

Discover all the shortcuts with the Alt Key Shortcut with symbol + Insert the function SUM in your active cell + Display in a combobox the value in the same column + + Group the data (row or column) + + Ungroup the data (row or column) Function keys + Insert a new chart + …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/shortcuts-alt-key/

Best excel shortcuts

Discover the best Excel shortcuts for the pro. Have a look at all this amazing tips and tricks about the Excel shortcuts 😃👍😉 Copy / Paste on large range of cells The following video will show you the technique to make a copy / paste over 5000 rows without using the mouse in less than …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/best-excel-shortcuts/

Inspect a formula with F9

In Excel, you can scan a part of your formula with the shortcut F9 When use the shortcut F9? Let’s say you have a complex formula with a lot of VLOOKUP, INDEX, MATCH, Reference all over your workbook. The result is not correct and you need to find the reason To split your formula in …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/inspect-a-formula-with-f9/