View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
michaelberrier michaelberrier is offline
external usenet poster
 
Posts: 63
Default Drag to fill row with column values

In the sheet "Stats", there are columns of numbers, we'll say A1:A10,
that I would like to automatically put in a single row, we'll say
A15:J15,using "=A1" and so on, and I'd like to do this many times.

In A15 I put "=A1"....is there a keyboard shortcut that, when pressed
while I drag to the right will put "=A2" in B15 instead of B2, and so
on?

Thanks to all.