Friday, December 17, 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!

- Irene Heckert, Microsoft Office Expert; CTT, MCAS, ITIL Certified, MOS LinkIn with Irene

Bookmark and Share

No comments:

Post a Comment