EASIEST Way to ADD Numbers in Excel (the shortcut you need) #shorts

let's cover a simple excel shortcut that adds numbers in columns and rows to some values in the column just go to the bottom and use the shortcut key alt equals that's automatically going to give you the sum function all you need to do is press enter to sum values in the rows do the same thing alt equals it's going to figure out where your data is you just have to press enter i'm going to show you a trick if you want to get the sum in rows as well as columns you just have to highlight your data area i'm gonna do that quickly using the shortcut key control a and then hold down shift use the arrow key to select one additional column and the down arrow key to select one additional row now check this out i'm gonna press alt equals and i'm gonna get the sum on both sides

Channel: Leila Gharani

Views: 87,299

Rating: 4.9724264 out of 5

Keywords: XelplusVis, Leila Gharani, Advanced Excel tricks, Excel online course, Excel tips and tricks, Excel for analysts, Microsoft Excel tutorials, Microsoft Excel, Excel 2016, Excel 2013, Excel 2019, XelPlus, Microsoft 365, Excel 365, excel tips, excel short tips, excel shortcut, excel shortcut add numbers, how to

Id: iXKg225HVKY

Length: 0min 52sec (52 seconds)

Published: Sun Oct 03 2021