Best Excel Shortcut Keys: AutoSum and SUM Filtered Rows Only

Показать описание

🎯 AutoSum and Subtotal in an instant with this shortcut....PLUS get a total that excludes filtered values to SUM only what you see 👀

======================================================================================
📒 Using keyboard shortcuts in Excel is the best way to save time and improve speed using Excel. I have brought together the best shortcut keys in Excel in this video series, which aims to cover all Excel shortcut keys you ever need to know. Using CTRL shortcut keys in excel is far easier than using a mouse and will save you time and wrist strain. There are keyboard shortcuts in Excel for almost everything you need to do, and I will show you the best Excel shortcut keys so you don’t need to learn them all. Learn a new shortcut key for Excel every week with my Best Excel Shortcut Keys videos, and you will soon be a master at keyboard shortcuts for Excel with lots more time on your hands.

and I'll send you an Everyday Essential Excel Shortcuts Cheat Sheet straight away.

📒 In this episode of Best Excel Shortcut Keys you will learn one of the most useful shortcut keys for formulas & calculation in MS Excel, how to do a sum of all data in a column, row, table or any block of cells in Excel. This quick sum in Excel is called AutoSum. The shortcut key for total sum in Excel is ALT + = (i.e. hold down ALT and hit the = key). This will AutoSum Excel data above or next to the active cell and give you a quick sum. I will give you AutoSum help where your Excel sum has the wrong result in this Excel AutoSum video. An Excel SUM gives the wrong answer if data is hidden or filtered so I will show you how to SUM filtered rows only using the subtotal shortcut key in Excel. The Excel subtotal shortcut key is the same as the AutoSum Shortkey Key ALT+= and automatically changes to SUBTOTAL 9 when it detects filtered rows.

======================================================================================
📖 a really quick way of putting totals and subtotals onto a table of numbers is the shortcut key alt equals alt equals pick up everything above and you can hit enter of what if we had filtered the data and just had a few on there that will give you necessarily the wrong answer but again if you use the shortcut key on filtered data it automatically detects you want a subtotal 9 which will only shall stand what is showing so there you go I've pulled together this one-page cheat sheet of all the everyday essential Excel shortcuts I'm giving this away today completely free just click on the link and I'll send you this straightaway don't waste any more time in Excel get this free cheat sheet right now today coming

======================================================================================
#Up4Excel
#Up4ExcelShortcuts
#Up4ExcelBeginner

Here at Up4Excel we’re on a mission to help YOU:
» Get your Excel skills UP and your task time DOWN
» Focus on shortcuts and fast impressive results
» Improve your productivity and free up your time

Everyone will assume you work 24 hours a day to produce the kind of output you’ll be producing in no time…. with the help of Up4Excel training.

You get new video releases every week, packed full of ways to save time and impress those around you.

💎 Don't miss out and fall behind.....
🅾 SUBSCRIBE NOW 🅾

======================================================================================
👀 Learn more with my playlist: Excel Shortcut Key Shorts

🎁 Feel free to donate - your small gift will help me make better videos for you and others.

👉 Get ALL Up4Excel workbooks and templates on YOUR device in a structured searchable index….with free lifetime updates