View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Why doesn't this work??

It does not work because Excel is not smart enough to recognize your data as
a series, But we are smart enough to make a series. Enter this in a cell
and copy down:

="pimage_" & ROWS($A$1:A379) & ".jpg"

--
Gary''s Student - gsnu2007


"Just Me" wrote:

when I type in one cell 1 and the the cell below it 2 then highlight both
and drag the corner the next cell will be then 4 then 5 and so on BUT

when I have cells that have this

pimage_379.jpg
pimage_380.jpg

and I do the same thing, highlight both and drag the corners the next cells
keep going like this why?


pimage_379.jpg
pimage_380.jpg
pimage_379.jpg
pimage_380.jpg

I want it to be like this
pimage_379.jpg
pimage_380.jpg
pimage_381.jpg
pimage_382.jpg


I appreciate any help