How to drag a formula to the right and skip x columns

< Back to Search results

 Category: [Excel]  Demo Available 

How to drag a formula to the right and skip x columns




The user would like to drag the formula to the right by picking the values from another sheets and sum its.
So, it should skip every 3 columns.





paste in your first column "A" and then press the Enter key

Then drag it ...

if your formula column is not first "A" and minus the before column count from where you paste.


See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets


See also:

How to skip VBA Code if table filter returns nothing


Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.


Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.


stars (0 Reviews)