Search This Blog

Thursday, December 9, 2010

Quickly copy a formula in Excel

You probably already know that you can copy a formula down or across by "dragging" the small plus sign (fill handle) in the bottom right corner of a cell, which is especially useful when working with formulas. If the data covers more than just a few cells, this can be tedious. Instead, double click on the fill handle.

Wow - that was fast!



No comments:

Post a Comment