The Excel Shortcuts everyone must know

The Excel Shortcuts everyone must know
Last Updated on 02/06/2024
Reading time: < 1 minute

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

Ctrl down Ctrl up

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
Insert column 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.

YouTube video

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.

YouTube video

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

YouTube video

Leave a Reply

Your email address will not be published. Required fields are marked *

The Excel Shortcuts everyone must know

Reading time: < 1 minute
Last Updated on 02/06/2024

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

Ctrl down Ctrl up

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
Insert column 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.

YouTube video

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.

YouTube video

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

YouTube video

Leave a Reply

Your email address will not be published. Required fields are marked *