Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Handle
I dont know when this happened or how this happened but when I use the fill
handle I typically want it to repeat the same numbers over and over again. By default it will increment the numbers which is fine at times but I would often click on that popup just after you fill the selection and tell it to repeat the same numbers. For some reason that popup doesn't come up anymore and I can't figure out how to get it back. Does anyone have any Ideas how I can get it back? Thank you for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Handle
I rightclick on the fill handle and drag down.
When I let go of the rightclick button, I can choose fill series or copy cells (and more, too). Abode wrote: I dont know when this happened or how this happened but when I use the fill handle I typically want it to repeat the same numbers over and over again. By default it will increment the numbers which is fine at times but I would often click on that popup just after you fill the selection and tell it to repeat the same numbers. For some reason that popup doesn't come up anymore and I can't figure out how to get it back. Does anyone have any Ideas how I can get it back? Thank you for your help. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Handle
Awesome. That'll work perfectly as soon as I get in the habbit of
rightclicking. "Dave Peterson" wrote: I rightclick on the fill handle and drag down. When I let go of the rightclick button, I can choose fill series or copy cells (and more, too). Abode wrote: I dont know when this happened or how this happened but when I use the fill handle I typically want it to repeat the same numbers over and over again. By default it will increment the numbers which is fine at times but I would often click on that popup just after you fill the selection and tell it to repeat the same numbers. For some reason that popup doesn't come up anymore and I can't figure out how to get it back. Does anyone have any Ideas how I can get it back? Thank you for your help. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Handle
Hi Abode,
2 more options for you... 1) You should be able to get your Auto fill options pop-up back by going to the Tools menu, selecting Options, Edit tab, and then selecting the Show Paste Options buttons check box. 2) You can hold down the control key while dragging the fill handle to get a straight copy instead of the series. "Abode" wrote: I dont know when this happened or how this happened but when I use the fill handle I typically want it to repeat the same numbers over and over again. By default it will increment the numbers which is fine at times but I would often click on that popup just after you fill the selection and tell it to repeat the same numbers. For some reason that popup doesn't come up anymore and I can't figure out how to get it back. Does anyone have any Ideas how I can get it back? Thank you for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill Handle | Excel Discussion (Misc queries) | |||
Trend using the same formula as the fill handle does | Excel Worksheet Functions | |||
Fill handle formula | Excel Worksheet Functions | |||
Fill Handle Across Columns | Excel Discussion (Misc queries) | |||
3-d reference not adjusting when using Fill Handle to copy down | Excel Worksheet Functions |