Shortcuts for the pros

Most Viewed Posts

  1. Displaying Negative Numbers in Parentheses – Excel (260,703)
  2. How to make automatic calendar in Excel (161,193)
  3. Dash for 0 in Excel (133,039)
  4. Convert YYYYMMDD to DD/MM/YYYY (117,131)
  5. Date Format in Excel (113,026)
  6. Excel Split Date and Time (91,206)
  7. How to calculate VAT in Excel? (88,871)
  8. Exchange rate in Excel (80,872)
  9. UNIQUE Function – Remove duplicates with formulas (67,669)
  10. Convert Latitude and Longitude from Decimal to Degree, Minute, Seconde (63,713)
  11. Add Emojis to your charts, formulas (60,047)
  12. Comma or Semicolon in an Excel formula (59,510)
  13. Compare 2 Columns (56,872)
  14. Change the default Date format in Excel (51,631)
  15. Dynamic SUM in Excel (44,845)

Shortcuts for the pros

Reading time: < 1 minutes
Post Views: 2,169
Last Updated on 10/02/2021 by Frédéric LE GUEN

Discover the best Excel shortcuts for the pros.

Have a look at all this amazing tips and tricks about the Excel shortcuts 😃👍😉

Copy / Paste on a large range of cells

The following video will show you the technique to make a copy / paste over 5000 rows without using the mouse in less than one second.

Analyze a formula with F9

The shortcut with the F9 key allows you to view the result 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 column with a lot of empty cells, you can't use the shortcuts Ctrl + Shift + Arrow down.

To select easily all your column (empty cell or not), it's better to use the F8 shortcuts

Fill the blank

Discover this amazing trick to fill the blank cells of your table before to import it in a data model, in a pivot table or in power pivot.

https://www.youtube.com/watch?v=hdHr6S_DuC8
Manage data,Shortcuts
Manage data,Shortcuts,Top 10

Leave a Reply

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

Excel Quiz

Recent Posts

Categories

Shortcuts for the pros

Reading time: < 1 minutes
Post Views: 2,169
Last Updated on 10/02/2021 by Frédéric LE GUEN

Discover the best Excel shortcuts for the pros.

Have a look at all this amazing tips and tricks about the Excel shortcuts 😃👍😉

Copy / Paste on a large range of cells

The following video will show you the technique to make a copy / paste over 5000 rows without using the mouse in less than one second.

Analyze a formula with F9

The shortcut with the F9 key allows you to view the result 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 column with a lot of empty cells, you can't use the shortcuts Ctrl + Shift + Arrow down.

To select easily all your column (empty cell or not), it's better to use the F8 shortcuts

Fill the blank

Discover this amazing trick to fill the blank cells of your table before to import it in a data model, in a pivot table or in power pivot.

https://www.youtube.com/watch?v=hdHr6S_DuC8
Manage data,Shortcuts
Manage data,Shortcuts,Top 10

Leave a Reply

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