AutoFill is one of Microsoft Excel’s most convenient features, but there are times when you want to copy an item in a list without filling the series. Simply select the first item, “January”, for example, then just hold down the control (CTRL) button while dragging the fill handle. January will fill to the cells, instead of the sequence of months (February, March, etc.) that normally would.
Jared Hawk teaches Boise, ID Excel Classes. He is also a contributing author to www.masterthebusiness.com, and is more of a cat person than a dog person, although he likes dogs, too.