Detroit Lakes, Minnesota, USA |

Archive for the ‘Copy, Cut, Paste’ Category

Excel 2007: Shortcut to Quickly Copy a Formula Down

Monday, August 18th, 2008

This only works on formulas to be copied down rows of cells, not across columns of cells. Type in and enter the formula to be copied. Move the cell pointer to the cell that holds the original formula. Double-click the fill handle to copy the formula down. It should copy down ...

Excel 2007: How to Create a Custom Fill Series

Thursday, August 14th, 2008

If you frequently have to type in a list of names, cities, locations, anything really, you can save that list and use the fill option to quickly generate the list. You do have to type in one of the names in the list to start the fill action. Click the ...

Excel 2007: Generate a Quick List of Months with the Fill Handle

Wednesday, August 13th, 2008

Not just months, but days (like Monday, Tuesday), dates, or a series of numbers. And it copies formulas, too. The fill handle is the thin plus you get onscreen when you hover your mouse over the little square in the corner of the cell pointer. To create a series of months ...