Dragging Ranges

Y

yegua22

I have a question if anyone can help it would be greatly appreciated.
have some values that fall in a range, and for a graph I would like t
graph all the number in that range. My ranges are 0-1, 1-2, 2-3, etc


My question is when I enter the first two rows, 0-1 and 1-2 and try t
drag the list down (to fill in 2-3, 3-4, etc) it starts filling 0-2
1-3, 0-3, and so on. Is there any way possible to get it to fill i
the way I would like, where both numbers are increased?

Thank
 
F

Frank Kabel

Hi
enter the following in your first cell:
=ROW(1:1)-1 & "-" & ROW(1:1)
and copy this formula down
 
Top