The newly created dropdown is no longer referencing $C2:$C20. If you choose relative references and copy and paste or autofill, the dropdown will reference a range equivalent to the relative movement that occurred during the copy and paste or autofill: $A1:$B1, A$1:B$1, or A1:B1) you need to specify the type of referencing using dollar signs in the 'Enter a range or formula' text box: If you want the reference to be partially or completely relative (e.g. In fact, if you make a selection, save it, and open the data validation again the range you selected will automatically have absolute referencing applied to it: This means that if you copy and paste or autofill the dropdown elsewhere in the spreadsheet the dropdown list will be created from the same range. When you select a range Google Sheets assumes that you want it to be referenced absolutely (e.g. The blank cells in the range are simply ignored. This will select all the way down to the last cell of that column, meaning all future updates to the dropdown list will be captured. To save time in having to highlight the entire column you can simply remove the numbers from the last column reference (C2:C instead of C2:C20): You'll now see the Data validation popup: STEP 2: Click on the Data menu item and click on the Data validation option: Selected cells are highlighted and bordered in blue. STEP 1: Select the cell/s you want to contain your dropdown list by clicking (to select a single cell) and dragging (to select a range).
Not on desktop? Click for mobile instructions: iPhone/iPad and Android. How To Create Dropdown Lists In Google Sheets why am I trying to convince you? You already know they're awesome.
They help to prevent formula and script errors by making sure that data is entered exactly as you need it to be. List of items to type a comma-separated list there and thenĭropdowns in Google Sheets make your spreadsheets user-friendly.List from a range to select list items from cells within the sheet, or.
In the popup menu change the Criteria dropdowns to: In the main menu go to Data ➜ Data validation. Select the cell/s you want a dropdown in.
0 kommentar(er)
