18 Essential Excel Shortcuts You SHOULD Learn

Want to achieve fast results and whizz through Excel tasks?
Nothing will save you more time in Excel than learning these shortcut keys.....so get the cheat sheet, download the workbook, and watch this now!

You'll learn all the Excel shortcuts beginners need to know, including the top 10 Excel keyboard shortcuts, Excel shortcuts for finance and shortcuts for accountants. Using keyboard shortcuts in Excel will save you a lot of time so get your Excel shortcuts free download with the link above. There are 18 sets of shortcut keys for Excel in this video covering the Excel shortcut to select all cells, format cells in Excel shortcut, Excel formatting shortcuts, insert current date and time, Excel shortcut to insert a chart, shortcuts to select ranges and many more. Using keyboard shortcuts in excel will save you a lot of time and save on mouse work hand strain.

You'll learn how to use all the shortcut keys on my Everyday Essential Excel Shortcuts Cheat Sheet in this video.....PLUS a ton of bonus extras as well, such as how to create your own shortcut keys.

======================================================================================
🕑 Video Timings:
00:00 Free Cheat Sheet
00:32 Basic Editing (Select All, Cut, Copy, Paste, Paste Special)
02:12 Undo & Redo
02:46 Instant Charts
03:23 Expand Working Area (Ribbon and Formula Bar)
03:58 Filtering
04:58 Switch Workbooks
05:25 Switch Worksheets
05:42 Jump Cell Locations (Select or Highlight Cells)
07:17 Select Entire Rows or Columns
07:32 Insert or Delete Rows or Columns
08:39 Hide or Unhide Rows or Columns
09:56 Edit Inside Cells
11:07 Format Cells
12:27 Number & Date Formats
13:09 Bulk Cell Entry (Fill Down, Fill Right, Flash Fill)
14:24 SUM and SUBTOTAL
15:02 Date and Time Entry
15:29 Grouping Rows or Columns
16:16 Make Your Own Shortcut Keys

Nothing will save you more time in Excel than learning the shortcut keys. In this video I'm going to show you the shortcut keys for 18 types of tasks in Excel, and even how to make your own shortcuts as well. I've pulled together these shortcuts onto a handy cheat sheet.

There are also two ways in which you can make your own at shortcut-keys as well. The first is very simple. Firstly you need to add the command you want to shortcut to your quick access toolbar. The way you do that is you click on the customize quick access toolbar, go to more commands, and I'm going to pick refresh all, which is great if you've got a lot pivot tables. Now once it's up there on your quick access toolbar, you can click ALT and that will give me number 7 straight away to access that.

The next way is, if you do something a bit more complicated, you can simply record it as a macro and when you hit record macro, one of the things that it asks you for is the shortcut key. I could type, and by holding down shift I can put a capital letter in, so I can have CTRL+SHIFT+D for example. But the problem is it allows you to pick letters that are already assigned to other shortcuts. Be very careful which letter you pick if you're going to go down this route.

💎Fix CTRL+SHIFT+0 for Windows 10
• In Settings go to Time & Language
• Search for Advanced Keyboard Setting
• Select Language Bar Options
• Select Advanced Key Settings
• Select Action = Between input languages
• Click Change Key Sequence
• Set Keyboard Layout Radio Button = Not Assigned

If this doesn't work, Add then Remove a new Language
• In Settings go to Time & Language
• Select Language
• Click Add a preferred language
• Click any language with a display icon and click next
• Click Install
• Once Installed go back and remove the language you've just installed

Reboot Excel for good measure and you should be up and running. If not, consult Google.

Thanks for tuning in to this Excel tutorial! I hope you've gained valuable insights into the world of keyboard shortcuts and how they can supercharge your Excel productivity. Remember, efficiency is key, and mastering these shortcuts will save you time and frustration in your Excel tasks. Keep practicing and incorporating these shortcuts into your workflow to see tangible results. Stay tuned for more actionable tips and tutorials to help you excel in Excel. Don't forget to like, subscribe, and share this video with your colleagues. Until next time, happy shortcutting!

[UpExcel]

✅ FREE Access to ALL Up4Excel Files. Includes Excel Templates, Training Workbooks, Example Data, Cheat Sheets and more. New Content Added Weekly!

[sudonghang]

Thank you John, I found it very concise and useful for me as an accountant

[arshadullah]

Thanks for uploading. I found this tutorial too much helpful & useful, God bless you.

[johnborg]

This will speed up things. Thanks John : )

[alanapalu]

Thanks for sharing this video, you kept it short and sweet, great tips!

[wayneedmondson]

Hi.. thanks for the video. Some great shortcut tips there. Appreciate you sharing them. Thumbs up!

[rickkeev]

I've tried twice to get the shortcuts but firewalls prevent the downloads; do you have another way?