cell reference

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Cell reference

Cell reference

resolvedResolved · Low Priority · Version Standard

Saroja has attended:
Excel Introduction course

Cell reference

How do you copy the formula from one cell to another?

RE: cell reference

Click in the cell, copy the formula from the formula bar above the sheet. Press the enter key before selecting any other cell. Then select the target cell and paste in the formula. Also, if you right clik and select paste append you can copy the values/formulas etc.


 

Excel tip:

Adding up rows or columns without seeing formulas

Highlight a column or row and click the Autosum button. This gives you your answer without showing the formula.

View all Excel hints and tips


Server loaded in 0.09 secs.