Ask Your Question

Copy/paste drop-down list (cell range) without auto cell range adjustment?

asked 2020-07-30 08:28:54 +0200

appreciatethehelp gravatar image

LO 6, Mojave

I'm copy/pasting a drop down list from one row to the row below, however I want the cell range referenced in the list to stay the same, not automatically increase by 1- how can this be achieved?

For example say the range in the drop-down list in the row above is A1:A3, I want this range to remain the same in the pasted version of the drop-down list in the row below, not auto-adjust to A2:A4.


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-07-30 08:55:41 +0200

JohnSUN gravatar image

Did you write the address of range A1:A3 manually? In such a case, add a dollar sign $ before row numbers (A$1:A$3) or before each element of the range address ($A$1:$A$3)

This problem would not have occurred if you had used the "Shrink" button to enter the address (circled in red in the figure). In this case, the address of the range would immediately be entered in absolute coordinates


edit flag offensive delete link more


@appreciatethehelp is given another excellent answer mentioning relative/absolute addressing, like several times before. Please read the topic, as it appears again and again in your questions!

Mike Kaganski gravatar imageMike Kaganski ( 2020-07-30 10:09:10 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-07-30 08:28:54 +0200

Seen: 15 times

Last updated: Jul 30