guidesvast.blogg.se - List of ctrl shortcuts excel

So the same formula that appeared in row 6 for Segment 1 is needed for Segment 2 in row 11 (Revenues less Cost of Goods Sold). 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 the completed cell (CTRL +C), then select the cells (SHIFT + Arrow Keys) where you want to repeat the formula and do a Paste (CTRL + V or Enter), or Paste Special (CTRL + ALT + V) if you only want to paste some attributes of the copied cell.Moving on, here are two great ways to speed up your copy and pasting using some lesser known shortcuts on the keyboard. OK, let’s not go there, if only because that previous sentence contained the word “mouse”. There’s of course dragging the bottom right corner with the mouse. How many ways are there in Excel to copy and paste cells? Lots. When you’re working in Excel, one of the most common sequences is to fill in one cell (with say a link or a formula) and then copy and paste the same thing into adjacent cells. Copy & Paste in Excel Using the CTRL + ENTER and SHIFT + F8 Shortcuts