how fill with different reference?

  • Thread starter Thread starter Ian Elliott
  • Start date Start date
I

Ian Elliott

Thanks in advance.
I have a cell (P31) with =SUM(C31:E31)
When I click on P31, then move my cursor to the lower
right, and drag to the right by one cell, I autofill the
next cell. However, the cell to the right becomes =SUM
(D31:F31) but I want it to be =SUM(F31:H31). Is there a
way I can tell Excel that the next fill will be not one
over but two over? I have to do this a total of four
times, and I am doing it by moving the blue rectangle, I
am wondering if there is a quicker way. Thanks.
 
Ian,

I don't think it is possible to do what you want.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Back
Top