how fill with different reference?

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.
 
C

Chip Pearson

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

fill series of multiple rows and columns 4
Auto Fill formula when inserting a new line 4
Autofiller Tool Help 4
Macro 0
Not working: Conditional Formatting 6
filling down to the end of a data set automatically 1
How to do an IF statement that copy data based on a partial match 0
How do I add a formula to a range of cells 0

Top