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

1. Select the column where you want to insert a nem column
2. Go to the fill handle
3. Hold the Shift key
4. Click on the button of your mouse and extend your selection

• Tutorial – Moving or Swapping rows and columns
• Adjusting the Size of rows and columns with the mouse

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