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

Discover all the shortcuts with the Function Key Function keys alone Help Toogle to the Edit mode Paste name formula (if you have defined Name in your worksheet) Toogle the reference of a cell (block/un-block) Goto Go to the next pane. Spell Check Extend Selection (EXT appears in the status bar). In Extend Mode, when …

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/

Shortcuts - Combination of many shortcuts

Shortcuts are very useful to save a lot of time. But you can also manage more than one shortcuts to get amazing action with Excel. 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. Copy/Paste …

Continue reading »

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

Inspect a formula with F9

In Excel, there is some amazing shortcuts and F9 is one of them Let's say you have a complex formula with a lot of VLOOKUP, INDEX, MATCH, Reference all over your workbook. And you have a mistake Not easy to find where is the mistake. Except if you use the shortcut F9 😏 When do …

Continue reading »

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