| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drag down
i have a cell formatted as Text
if i enter a number and use the little lower right box to drag down, it adds one to each cell. so if i enter 01 and drag down it enters 02,03,04 in the next three cells. Can i stop this...i just want to see 01,01,01, thanks in advance for any advice, tami |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
drag down
hold the control key while doing
-- Don Guillett Microsoft MVP Excel SalesAid Software "Tami" wrote in message ... i have a cell formatted as Text if i enter a number and use the little lower right box to drag down, it adds one to each cell. so if i enter 01 and drag down it enters 02,03,04 in the next three cells. Can i stop this...i just want to see 01,01,01, thanks in advance for any advice, tami |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
drag down
Interestingly it behaves if you try the other way
Enter 1; Format cell as Text and then try dragging.. If you are looking at filling the same value then try this. Enter 01Select the cell and the cells downKeeping the selection hit Ctrl + D If this post helps click Yes --------------- Jacob Skaria "Tami" wrote: i have a cell formatted as Text if i enter a number and use the little lower right box to drag down, it adds one to each cell. so if i enter 01 and drag down it enters 02,03,04 in the next three cells. Can i stop this...i just want to see 01,01,01, thanks in advance for any advice, tami |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
drag down
I mean to say
Interestingly it behaves differently if you try the other way If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Interestingly it behaves if you try the other way Enter 1; Format cell as Text and then try dragging.. If you are looking at filling the same value then try this. Enter 01Select the cell and the cells downKeeping the selection hit Ctrl + D If this post helps click Yes --------------- Jacob Skaria "Tami" wrote: i have a cell formatted as Text if i enter a number and use the little lower right box to drag down, it adds one to each cell. so if i enter 01 and drag down it enters 02,03,04 in the next three cells. Can i stop this...i just want to see 01,01,01, thanks in advance for any advice, tami |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
drag down
don't drag just copy and paste
"Tami" wrote: i have a cell formatted as Text if i enter a number and use the little lower right box to drag down, it adds one to each cell. so if i enter 01 and drag down it enters 02,03,04 in the next three cells. Can i stop this...i just want to see 01,01,01, thanks in advance for any advice, tami |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
drag down
thanks much. I have a lot of inexperienced users that i need to train on
this when they are populating this worksheet so i needed something easy. so as you suggested i entered in 01 then prior to dragging down i hold my control key then drag and it worked!...i should be albe to train them to do that prior to dragging but in addition is there a way to turn off/disable the "incrementing" of 1 when dragging? "Jacob Skaria" wrote: I mean to say Interestingly it behaves differently if you try the other way If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Interestingly it behaves if you try the other way Enter 1; Format cell as Text and then try dragging.. If you are looking at filling the same value then try this. Enter 01Select the cell and the cells downKeeping the selection hit Ctrl + D If this post helps click Yes --------------- Jacob Skaria "Tami" wrote: i have a cell formatted as Text if i enter a number and use the little lower right box to drag down, it adds one to each cell. so if i enter 01 and drag down it enters 02,03,04 in the next three cells. Can i stop this...i just want to see 01,01,01, thanks in advance for any advice, tami |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
drag down
In cases like this I right-click and drag.
Release the button and select "Copy cells" Gord Dibben MS Excel MVP On Sun, 20 Sep 2009 07:42:01 -0700, Tami wrote: thanks much. I have a lot of inexperienced users that i need to train on this when they are populating this worksheet so i needed something easy. so as you suggested i entered in 01 then prior to dragging down i hold my control key then drag and it worked!...i should be albe to train them to do that prior to dragging but in addition is there a way to turn off/disable the "incrementing" of 1 when dragging? "Jacob Skaria" wrote: I mean to say Interestingly it behaves differently if you try the other way If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Interestingly it behaves if you try the other way Enter 1; Format cell as Text and then try dragging.. If you are looking at filling the same value then try this. Enter 01Select the cell and the cells downKeeping the selection hit Ctrl + D If this post helps click Yes --------------- Jacob Skaria "Tami" wrote: i have a cell formatted as Text if i enter a number and use the little lower right box to drag down, it adds one to each cell. so if i enter 01 and drag down it enters 02,03,04 in the next three cells. Can i stop this...i just want to see 01,01,01, thanks in advance for any advice, tami |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drag cell from A1 : A (Value here) | Excel Discussion (Misc queries) | |||
| Drag Formula Until ( ) | Excel Discussion (Misc queries) | |||
| can I drag down sequential #'s? | Excel Discussion (Misc queries) | |||
| drag..... | Excel Discussion (Misc queries) | |||
| Column Drag Down | Excel Discussion (Misc queries) | |||
Linear Mode
