Save Time and Effort with the CTRL+. Shortcut: The Handy Excel Trick You Need to Know!
Navigating large tables can be time consuming and frustrating, but with this keyboard shortcut you'll save time and effort.
The CTRL+. shortcut is a great Excel trick that can save you time and effort. It allows you to quickly jump to the next error or empty cell in an Excel spreadsheet. This is especially useful when you need to quickly locate and fix errors in a large spreadsheet. To use the CTRL+. shortcut, simply select a cell, press CTRL+. and Excel will instantly jump to the next error or empty cell in the spreadsheet. You can then take action on the cell as necessary. By using this shortcut, you can save yourself time and effort when dealing with large spreadsheets.
What are the best Excel Shortcuts
There are many Excel shortcuts that can save you time and make your work more efficient. Here are some of the most useful ones:
- 1 Ctrl + C: Copy
- 2 Ctrl + X: Cut
- 3 Ctrl + V: Paste
- 4 Ctrl + Z: Undo
- 5 Ctrl + Y: Redo
- 6 Ctrl + A: Select all
- 7 Ctrl + B: Bold
- 8 Ctrl + U: Underline
- 9 Ctrl + I: Italic
- 10 Ctrl + F: Find
- 11 Ctrl + H: Replace
- 12 F2: Edit cell contents
- 13 F4: Repeat last action
- 14 F5: Go to
- 15 F7: Spell check
- 16 Ctrl + Shift + # or Ctrl + Shift + $: Apply number formatting
- 17 Ctrl + Shift + %: Apply percentage formatting
- 18 Ctrl + Shift + &: Apply border to selected cells
- 19 Ctrl + Shift + *: Select current region around active cell
- 20 Ctrl + Shift + ~: Apply general number format
These are just a few of the many Excel shortcuts available. By using them, you can work more quickly and efficiently, and become more productive in your work.
More links on about
Make the most of your time with these top 10 tips and tricks for shortcut Excel formulas! Learn how to streamline your workflow and save time on tedious tasks.
Save all those clicks with this easy trick. Hold the Shift key while you left click on the X. This will close all open workbooks at once. Don't Save All Option.
Mar 5, 2020 — F12 – File Save As (also works in Word, PowerPoint etc.) F7 – Spell Check. Essential if you're creating reports. F5 – Go to. F5 or CTRL+G > ALT+ ...