Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extend the numbers 1,2 to get 3,4,5,.....
Dear community,
I generally know how to obtain 3,4,5,.... having 1 and 2. I just need to select both cells and then drag the fill handle over the range. But very recently the Drag thing disappeared completely. Do you know how I can return it back? Thank you very much. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extend the numbers 1,2 to get 3,4,5,.....
From the Menu Bar:
<Tools <Options <Edit tab, And check "Allow Cell Drag & Drop". -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "peter_sagg" wrote in message ... Dear community, I generally know how to obtain 3,4,5,.... having 1 and 2. I just need to select both cells and then drag the fill handle over the range. But very recently the Drag thing disappeared completely. Do you know how I can return it back? Thank you very much. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extend the numbers 1,2 to get 3,4,5,.....
In xl2003 menus:
Tools|Options|Edit Tab|check Allow cell drag and drop peter_sagg wrote: Dear community, I generally know how to obtain 3,4,5,.... having 1 and 2. I just need to select both cells and then drag the fill handle over the range. But very recently the Drag thing disappeared completely. Do you know how I can return it back? Thank you very much. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extend Name range | Excel Discussion (Misc queries) | |||
Extend Formulas | Excel Worksheet Functions | |||
Extend Formula | Excel Discussion (Misc queries) | |||
Extend series | Excel Worksheet Functions | |||
Extend formulas | Excel Discussion (Misc queries) |