![]() ![]() 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.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |