Named ranges with drop down list - is this how it works?

lagrangePoint3

New Member
Joined
Jun 22, 2022
Messages
16
Office Version
  1. 365
Platform
  1. Windows
I've set up a drop down list using data validation on a single row (A23-A33), for example.
But now I wish to redact one of the values.
If I shorten the cells, one of two things will happen:
(1) I'll get a blank where the value used to be in the drop down list, or
(2) I will have to visit every reference to the list of values and change it to reflect the new number of cells.

Now if I set up a named range for this list of values, and then redact a value, I will still see a blank in the drop down list, if nothing is changed in the reference,
but is there a way to reduce my work in changing the reference? If the reference was a named range (just guessing what that is), and I redefined the name to a reduced number of cells (A23-A32),
would I still need to visit every reference to update it, or would the new values for newly defined named range be used without my further intervention?

Thanks.
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Forum statistics

Threads
1,214,653
Messages
6,120,749
Members
448,989
Latest member
mariah3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top