Excel Ninja Secrets: Mastering Shortcuts for Advanced User

🎯 If you use advanced Excel features you really SHOULD be using these shortcuts! Learn these NOW for your advanced Excel operations and save a ton of time!

📒 In this Excel Shortcut Keys tutorial you will learn the top 10 most useful must know Excel shortcuts keys for advanced users. The Excel keyboard shortcuts you will learn are:

You could learn how to set filters in Excel but much easier to use the Excel filter shortcut key control L (CTRL+SHIFT+L). This autofilter shortcut key in Excel can also be used as a clear filter Excel shortcut. Use spacebar to tick or untick items on filters!

There are several shortcuts to insert data into many cells at once in Excel, depending on your needs. The Excel data entry time savers covered in this video will show us how to save our time when data entering. The data entry shortcuts in Excel demonstrated in this tutorial will show you how to use ctrl enter in Excel, how to use fill down in Excel, how to use flash fill in Excel to split data, how to enter an Excel formula in multiple cells at the same time, and how to enter data into multiple cells at once in Excel.
There are 2 main Excel chart shortcuts shown in this video. The Excel chart shortcut key to create a chart in a new sheet is F11, and the Excel chart shortcut key to create a chart in the same sheet is ALT+F1.
How to insert and delete rows and columns in Excel. This video demonstrates the shortcut key to insert/delete rows & columns in MS Excel, how to insert rows in Excel, how to add multiple rows in Excel and how to insert columns in Excel.
Hide and unhide rows and columns in Excel. The hide and unhide rows and columns Excel keyboard shortcuts are based around CTRL+9 and CTRL+0. I will demonstrate how to hide a column in Excel, how to hide Excel rows, how to unhide columns in Excel, how to unhide rows in Excel. Hide and unhide rows and columns Excel shortkeys will save you a lot of time at work so make a point of learning how to hide unwanted columns and rows in Excel using shortcut keys. Sometimes you may find that the unhide column shortcut is not working. When ctrl shift zero is broken in Excel it is usually due to windows language settings. You can fix ctrl shift 0 using the instructions below.
Grouping data to create a button in Excel to hide unhide rows when clicked. To add a hide or unhide rows button in Excel you can use the Excel group rows function shortcut ALT + SHIFT + RIGHT ARROW. This will let you expand or collapse rows in Excel with a plus or minus sign next to the sheet.
You will learn the shortkeys for how to enter current date and time in Excel and create a timestamp in Excel that doesn’t change.
There are many Excel number format shortcuts but it is best to learn the ones you use most first. In this video I show you data formatting shortcut keys such as the general number format keyboard shortcut, currency symbol format, percentage format in Excel and date format Excel shortcut…all very useful Excel data formatting shortcuts.
Data formatting shortcut keys can be used after CTRL+1 (format cells Excel shortkey / key to open format cell). Excel data formatting shortcuts include the shortcut key to text formatting, general number format keyboard shortcut, percentage format in Excel, currency symbol format in Excel, and general number format in Excel.
How to edit the contents of a cell in Microsoft Excel. I will show you how to edit cell contents in Excel using edit inside cells shortkeys. To edit contents of a cell in Microsoft Excel use F2 to enter cell edit mode.

💎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 as follows:
• 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.

Topics Covered:
1. Auto Filter Shortcut: Simplify data management and analysis with Ctrl + Shift + L.
2. Data and Formula Entry Shortcuts: Accelerate data entry and analysis with Ctrl + D and Ctrl + E.
3. Instant Chart Creation: Create charts quickly using Alt + F1 and Alt + F11.
4. Row and Column Management: Manage data organization with shortcuts like Ctrl + Shift + Equals.
5. Hide and Unhide Rows/Columns: Control data visibility with shortcuts like Ctrl + 9.
6. Grouping Rows/Columns: Speed up data organization with Alt + Shift + Arrow.
7. Date and Time Shortcuts: Insert today's date/time using Ctrl + ; and Ctrl + Shift + ;.

[UpExcel]

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

[UpExcel]

✅ Something I forgot to say in the video: Use spacebar to tick or untick items on filters and dialog boxes!

[wayneedmondson]

Hi John.. some great tips there.. thanks for sharing them. Another one I like is CTRL+\ to highlight row differences and CTRL+SHIFT+\ to highlight column differences. They are helpful when auditing sheets from third parties to find hard inputs or other inconsistencies across a row or column range. Thumbs up!!