Discover the best Excel shortcuts used by the Excel pros. Have a look at all this amazing tips and tricks about the Excel shortcuts 😃👍😉
Move to the last cell / first cell
Insert column with the mouse
- Select the column where you want to insert a nem column
- Go to the fill handle
- Hold the Shift key
- Click on the button of your mouse and extend your selection
Copy / Paste on a large range of cells
The following video will show you how to copy/paste over 5000 rows without using the mouse in less than one second.
Analyze a formula with F9
The F9 shortcut key allows you to view the results of a part of your formulas. For example, if you have a very complex formula, the F9 key will help you to visualize what a specific part of a formula will return.
Shortcut with the F8 keys
If you have a column with many empty cells, you can’t use the shortcuts Ctrl + Shift + Arrow down. To select easily all your columns (empty cell or not), it’s better to use the F8 shortcuts
