Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Increasing distance labels using drag down method
Hello All,
Here is what I have to deal with. I have around 1,200 labels that I don't want to have to type in. I would like to us the fill down method. The labels will be as follows... 0.0-0.1mm 0.1-0.2mm 0.2-0.3mm and so on. Keep in mind, they are labels and I am not actually subtracting them. Doing that 1,200 times will not be fun. Help is appreciated. Thanks, Bowbender |
#2
|
|||
|
|||
the simplest method would be to use a helper column (A:A)
fill it with 0.0 to whatever the highest number is in your working column (B/)enter in B1 =text(A1,"0.0")&"-"&text(A2,"0,0")&"mm" copy down as far as you need. I would then coly the column and paste special values over the top of itself and then delete the helper column. "Bowbender" wrote: Hello All, Here is what I have to deal with. I have around 1,200 labels that I don't want to have to type in. I would like to us the fill down method. The labels will be as follows... 0.0-0.1mm 0.1-0.2mm 0.2-0.3mm and so on. Keep in mind, they are labels and I am not actually subtracting them. Doing that 1,200 times will not be fun. Help is appreciated. Thanks, Bowbender |
#3
|
|||
|
|||
Bow
I would start out with 2 columns. A1 enter 0 A2 enter .1 B1 enter .1 B2 enter .2 Both columns formatted as Number and 1 decimal place. Select A1:B2 and drag/copy down 1200 rows. In C1 enter =A1 & "-" & B1 & "mm" Double-click on C1 fill handle to copy down down. Column C Copypaste specialvaluesOkEsc Note: Column C will not pick up the formatting from A and B so whole numbers will show as 0, 1, 2 etc. Gord Dibben Excel MVP On 20 Sep 2005 12:06:12 -0700, "Bowbender" wrote: Hello All, Here is what I have to deal with. I have around 1,200 labels that I don't want to have to type in. I would like to us the fill down method. The labels will be as follows... 0.0-0.1mm 0.1-0.2mm 0.2-0.3mm and so on. Keep in mind, they are labels and I am not actually subtracting them. Doing that 1,200 times will not be fun. Help is appreciated. Thanks, Bowbender |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL Charts: Let my mouse drag all data labels for a whole series. | Charts and Charting in Excel | |||
count distance in column | Excel Worksheet Functions |