View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default 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!