Dragging Formula

[cjpascoe1]

Property Name

Unit Mix	Rent $	Square Foot
Studio	D8	H8
1 Bed, 1 Bath	D9	H9
1 Bed, 1.5 Bath	D10	H11
1 Bed, 2 Bath	D11	H13

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

Property Name

Unit Mix	Rent $	Square Foot
Studio	D47	H47
1 Bed, 1 Bath	D48	H48
1 Bed, 1.5 Bath	D49	H49
1 Bed, 2 Bath	D50	H50

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

This is my example, i need to find a way so that at the bottom of the my spreadsheet i show this

Studio Rent

Studio SF

<tbody>
</tbody>

=D8 =F8
=D47 =F47
=D86 =F86


How Can i drag down this formula so the bottom shows just the cells i want, normally on a drag down formula it just reselectsthe first cells and won't skip the 39 rows I want it to. It need to drag down skipping 39 rows

 

[XlsXprt]

In short, you can't. But there are solutions:

If you just need to do it once, you can copy and paste formulas without the cell references changing by:
1. Highlight the formula in the formula bar by manually clicking and dragging with your cursor
2. Copy (Ctrl + C), then hit Esc
3. Select the cell under "Studio Rent" box and Paste (Ctrl + V).

If you need to do this regularly, you could easily record a macro to do this.