January 28, 2014

Copy Formula to Multiple Cells in Microsoft Excel 2010

Many times we use the same formula, but don’t want to have to constantly retype it in each cell to reflect the individual references to each specific row.  If you have ever found yourself in this place, this trick will save you lots of time.  First, create the formula that you need and then move your cursor to the lower right corner of the cell, and when you see a dark plus sign double click.  Now you will see that the formula has been copied to all the cells below.  The data showed in these cells will automatically be specific to the cells in that row.

No comments:

Post a Comment