Tag Archive: Shortcut

Articles sur le thème : Shortcut

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/