![]() Note: You will get a default Excel chart. This is a quick win for you and also one of my favorite Excel Shortcuts of all time :), so let’s dive into it.įirst, select the data you want to chart (or just click on our data range ), then just press ALT + F1 and that’s it. Heads-Up: This shortcut may not work at first. Really amazing and definitely worth remembering and using to get faster and more efficient in Excel. If you select the row below our numbers at the bottom, and the empty column to the right, you will get all the SUMs in one move. If you select the empty column, to the right, ( Apples + Pears column), you will get a sum of Apples + Pairs. But why? If you select just the cells you would like to sum up, Apples column in our example, and press ALT + =, only that column will be summed up with the result written in the first empty cell underneath the data selected. Let’s take a look at the contents of cells (look inside the formula bar) B15, C15, and D15 to see whether we actually got the SUM function. Now simply press ALT + = and there it is. Note: you can select data without headers as well. But whatever way you chose, there is a faster way to SUM your data in Excel.įirst, let’s select the data we would like to sum up. ![]() You could also just start typing with the “=” (equal) sign and continue typing SUM afterward to call the function faster. Question: How can we SUM this data quickly, in Excel?ĭo you know the fx button near the formula bar? That good old click on the formula bar and then scrolling to find SUM. IF you find it easier to learn through Videos, here is a link to the Excel Olympics YouTube video explaining all the shortcuts described in this post. ![]() ![]() Let’s look at some great things you can do using Alt-based shortcuts in Excel. But if you don’t, you are missing some great shortcuts. But very rarely do users use shortcuts with the Alt key. Sometimes we will even use some that use Ctrl and Shift keys. Enter the name you want to give to the selection in the Name Box (no spaces allowed in the name).I guess we all use our fair amount of Excel shortcuts that start with Ctrl.Select the columns for which you want to create the named range (hold the Control key and then select the columns one-by-one).Once created, you can simply enter the named range name in the Name box (or select it from the drop-down)īelow are the steps to create a named range for specific columns: Instead of doing it one by one or entering it manually in the Name Box, here is what you can do – create a named range that refers to the columns you want to select. Suppose you’re working in a workbook where you may often have a need to select far-off columns (say column B, D, and G). Let me also show you another wonderful trick. It allowed me to quickly select columns and format them at once, or delete/hide these columns in one go. When I used to work as a financial analyst years ago, I found this trick extremely useful. If you want to select multiple columns that are not adjacent, say D, H, and I, you can enter the below: D:D,H:H,I:I Similarly, if you want to select multiple columns (say D, E, and F), enter the following in the name box: D:F While the main purpose of the Name Box is to quickly name a cell or range of cells, you can also use it to quickly select any column (or row).įor example, if you want to select the entire column D, enter the following in the name box and hit enter: D:D
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |