View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dan dan is offline
external usenet poster
 
Posts: 866
Default Excel Fill issue


Excel 2007

When I fill down the following formula
=A2&","&C2&","&Q2


I get
=A2&","&C2&","&Q3
=A2&","&C2&","&Q4
=A2&","&C2&","&Q5
=A2&","&C2&","&Q6
=A2&","&C2&","&Q7

Instead of what I wanted
=A3&","&C3&","&Q3
=A4&","&C4&","&Q4
=A5&","&C5&","&Q5
=A6&","&C6&","&Q6
=A7&","&C7&","&Q7
--
Any help?
Thanks,
Dan