fill handle in Excel
Hi,
A few comments on the mythical fill handle:
- You can drag it in all 4 directions - up, down, left, or right (it
decriments when going up or left, in general)
- You can drag it while holding down the Ctrl key which causes
incrementation to change to copy and copy to change to incrementation, in
many cases.
- You can drag it with the right mouse button - when you release you will
get a list of options.
- You can double-click it and if there is an adjactent column of data it
will fill down automatically. (This is a most important feature) This only
works in the down direction.
- There is an Options icon at the end of a fill that can be opened to give
you options similar to those that appear when you drag with the right mouse.
--
Thanks,
Shane Devenshire
"Broadbrook" wrote:
Where is this mythical fill handle. I have it enabled, but I can't find it.
Thanks!
|