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. Function keys alone Help Toogle to the Edit mode Paste name formula (if you have defined Name in your worksheet) Toogle the …

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 Follow these links to have others shortcuts with Excel, Shortcuts with Alt key Best Excel shortcuts ever 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, …

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/

Shortcuts for the pros

Discover the best Excel shortcuts for the pros. 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/shortcuts-for-the-pros/

Inspect a Formula with F9

In Excel, you can scan part of your formula with the shortcut F9 When use the F9 shortcut? Let’s say you have a complex formula with a lots of VLOOKUP, INDEX, MATCH, references. But the result returned is not correct and you need to find the reason. Tips: To display your formula on multiple rows, …

Continue reading

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