Notice in the graphic we’ve been using, there’s another segment (Segment 2) for which we need to calculate Gross Profit. Now let’s take this to the next level for even greater efficiency. Part of the issue is that the first two options above require that you go back to cell C6 after you’ve initially built it. faster) than options 1 and 2, respectively. Option 3 is 17% and 23% more efficient (ie.
Option 3: (select C6:G6, build C6, hit CTRL + ENTER): 10 keystrokes.Option 2: (build C6, select D6:G6, hit CTRL + V): 13 keystrokes.Option 1: (build C6, select C6:G6, hit CTRL + R): 12 keystrokes.Starting on cell C6, here’s a tally of the various methods and the number of keystrokes required to fill in the rest of row 6: Pretty sweet, no? It actually saved keystrokes. Here’s the key step: instead of hitting ENTER the way you normally do, hit CTRL + ENTER and Excel will replicate the formula in all of the selected cells.You’ll notice that even though multiple cells are selected, Excel will create the formula in the top left cell of the selected range (in this case, the leftmost cell C6). Now start creating the formula the way you normally would (type = then up arrow twice, etc.).First, select all the cells where you want the Gross Profit calculation (C6:G6).Let’s suppose you have a simple table with revenue and cost forecasts as shown in the picture below, and you want to quickly fill in the formulas for Gross Profit in row 6.Use the CTRL + ENTER shortcut – this shortcut applies the same contents or formula in all the cells you initially select. Here’s an alternative way that can speed things up even more (let’s call this option 3). But they still involve a fair number of keystrokes. These methods are fine and certainly quicker than using the mouse. Highlight the completed cell as well as the other destination cells and do a fill right and/or down (CTRL + R / CTRL + D) depending on the orientation of the data.
Copy & Paste in Excel Using the CTRL + ENTER and SHIFT + F8 Shortcuts
0 kommentar(er)
