Excel - Amazing Way to Add AutoSum to Total Row and Total Column at Once - Episode 1980
Microsoft Excel Tutorial - trick for adding total row and total column at the same time using AutoSum.
Welcome to the MrExcel netcast, sponsored by the "MrExcel XL" book. In this episode, we will be discussing a faster way to use AutoSum in Excel. I'm Bill Jelen and I'm excited to share this tip with you.
Before we dive into the tip, we need to create a quick report. We will start from scratch on a blank worksheet and add week numbers across the top. To make this easier, we will use the fill handle with any word followed by a number. Then, we will use the custom list we created in episode 1978 down the left-hand side.
Next, we need to add some numbers to our report. Instead of manually typing them, we will use the RANDBETWEEN function to generate random numbers. This is a great function for creating fake data sets, but I don't recommend using it for real-life budgets. Once we have our numbers, we will use the AutoSum feature to quickly add totals on the right-hand side and at the bottom of our report.
But here's the real trick - instead of using the AutoSum button or Alt+= to add the totals, we can select all of our numbers, plus one extra row and column, and then use the AutoSum feature. This will automatically add the totals all around the report. It's a beautiful trick that will save you time and impress your colleagues.
We will also discuss some formatting tips, such as using the Heading 4 and Title cell styles, and how to create a custom comma style using the dialog launcher. And don't worry, in next week's episode, we will show you how to make this custom style available in all future workbooks.
If you're enjoying these tips, be sure to check out the "MrExcel XL" book for more Excel tips, cartoons, cocktails, tweets, and jokes. And don't forget to click the "i" on the top-right corner to purchase the book.
Thank you for tuning in to this episode of the MrExcel netcast. I want to give a special thanks to Bob Umlas for sharing the AutoSum trick in his "Excel Outside the Box" book. Stay tuned for more netcasts from MrExcel and don't forget to subscribe to our channel for more Excel tips and tricks. See you next time!
Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...
Table of Contents:
(00:00) Faster AutoSum in Excel
(00:19) Setting up a report on a blank worksheet
(00:29) Using the fill handle and custom list for data entry
(00:53) Creating fake data with RANDBETWEEN function
(01:13) Adding totals with AutoSum
(01:56) Selecting all numbers for faster AutoSum
(02:36) Comma Style is not what I want
(03:24) Creating a new cell style
(04:44) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelautosum
This video answers these common search terms:
how to autosum in excel
autosum tips in excel
how to add comma style in excel
how to use comma style in excel
how to apply comma style excel
how to format to comma style excel
quick autosum excel
autosum excel quick method
excel autosum time-saver
how to apply cell styles in excel
how to save custom cell styles in excel
how to do cell style in excel
excel shortcut for autosum
A great trick for adding Total Row and Total Column in a single click. Also in this episode:
Fill Handle works with "any word" and a number
Fill handle with custom list from episode 1978
Using RANDBETWEEN for fake data but not budgets
AutoSum all around by choosing data + total row and column
Formatting using Heading 4 cell style
Formatting using Title cell style
I hate the comma icon in the Number tab
Using dialog launcher to get to Format Cells
Saving a regular comma style as a new Style
Adding comma style to all future workbooks - page 20
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
Смотрите видео Excel - Amazing Way to Add AutoSum to Total Row and Total Column at Once - Episode 1980 онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал MrExcel.com 07 Август 2016. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 2,271 раз и оно понравилось 51 посетителям.
