For news about the latest Excel for the web updates visit the Microsoft Excel blog. Note the formula in the formula bar while the result we would expect is in cell B2. To insert a formula in Excel for an entire column of your spreadsheet enter the formula into the topmost cell of your desired column and press Enter Then highlight and double-click the bottom-right corner of this cell to copy the formula into every cell below it in the column.
For news about the latest Excel for the web updates visit the Microsoft Excel blog.
Place the mouse pointer over the fill handle its the dot in the bottom right corner of. Press Enter to complete the formula. Place the mouse pointer over the fill handle its the dot in the bottom right corner of. Type a plus sign then use your pointer to select C2 to enter the second cell reference into the formula.