With Cell E4 selected, drag the fill handle in cell E4 down through cell E8.Click the Enter button on the Formula Bar, which is the green or blue check mark.If the keyboard shortcut does not work (this is common due to variations in keyboards), use the AutoSum technique from step 16. This is a keyboard shortcut that enters the Sum function.Click in cell E4, Press Alt and + = key.In cell E3, type Total and then press Enter.In cell D8, click AutoSum on the Home Tab, Editing Group and press Enter.A quicker way to enter a formula is with a function.The formula bar displays the Underlying Formula. Notice the Formula Bar as you enter in your formula. Note: Using this technique we are manually entering a formula that sums a range of cells.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |