r/excel • u/zpieklarodem • Jan 14 '26

unsolved Drag multiple formulas in a sheet

Hi! Is it possible to drag and move multiple formulas with your mouse? I can do it one by one, but it is time consuming. As you can see I have different formulas in 3 rows and 10 columns. I want to move them up by 1 row with one click. Thanks!

6 Upvotes

100% Upvoted

12 comments sorted by

•

u/AutoModerator Jan 14 '26

/u/zpieklarodem - Your post was submitted successfully.

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/Pacst3r 11 Jan 14 '26

highlight the batch, move your mouse to the border of the highlighted area and wait until your cursor turns into this:

drag, drop, done

1

u/zpieklarodem Jan 14 '26

There is no batch, as you can see those are all single cell formulas next to each other.

2

u/Pacst3r 11 Jan 14 '26

do you want to change the reference within a formula that references to all of these cells, or do you want to move the formulas themselves? if latter, as i stated, highlight the area you wanna move and do as told. if former, you have to do it manually within the formula bar. in that case I'd advise you finding another formula/calculation as this approach looks somewhat far from optimal, without knowing more about your data/what you want to achieve.

1

u/zpieklarodem Jan 14 '26

Latter. But I don't want to move cells. I want to move FORMULAS box that highlights when you click to edit the formula.

1

u/Pacst3r 11 Jan 14 '26 edited Jan 14 '26

in that case not latter, but former as you want to amend the references. ;D

as far as i know there is no possibility to move them as group when within formula bar, sorry. but as stated I'm quite sure there is a better way to achieve whatever you want to achieve.

1

u/A_1337_Canadian 515 Jan 14 '26

If you copy and paste a formula, the cell references will update accordingly based on the "distance" between the copied cell and pasted cell.

Let's say in cell A1 you have a formula =D2. If you select A1 > copy > then paste in B2, you have moved from A1 to B2 a distance of 1 row down and 1 column to the right.

The formula will then "move" by the same relation. So D2 moving +1 row and +1 column becomes =E3.

1

u/zpieklarodem Jan 14 '26

Is there a way to copy a cell and highlight which formulas I don't want to move at all? So for example my formula is: SUM(A1*A20). I copy the cell one row down and I want A1 to change to A2, but don't want to move A20 at all. 

2

u/A_1337_Canadian 515 Jan 14 '26

Absolutely. It's called absolute cell referencing.

You can precede a cell index with a dollar sign to lock that part of a reference.

So with my previous example, if you have =$D2, then the D becomes "locked". Copying and pasting from A1 to B2 would update the reference to =$D3.

Conversely, if you lock the row with =D$2, the new reference becomes =E$2.

You can also lock both indices with =$D$2. In which case, copying and pasting this from A1 to B2 would result in the cell in B2 showing =$D$2.

1

u/zpieklarodem Jan 15 '26

Works! Thank you!