Excel Auto increment drag left add cell like dragging down
Posted on 2011-03-25
In Excel 2010,
I can drag down and have it auto increment: I have references to another sheet, the data is in vertical columns but the summary sheet with the references need it horizontal.
Summary sheet: ='data'!h23 |'data'!H24|'data'$h25
I would like to create the first one ('data'!h23), highlight and drag right automatically filling in the cells to the right.