Working with the Excel Fill Handle — One Minute Office Magic


One of the cool things about working with Excel is the ability to click on the Fill Handle in the lower right corner of a cell, and then drag it to auto-fill values based on what’s in the original cell. However, it can be frustrating to figure out whether it’s going to copy the value or auto-fill based on the next value in the sequence. Here’s a brief overview on how you can get it to copy or fill based on what you need, regardless of what Excel wants to do for you automagically…

via Working with the Excel Fill Handle — One Minute Office Magic

Advertisements