STEP 3: Fill out the data validation popup to create a calendar dropdown: Cell range:Įnter the cell/s you want a date picker in by typing them in or clicking on the icon and selecting the cells directly in the sheet. One of these keyboard shortcuts (Windows only): Alt + A, V or Alt + D, L or Alt + D, V.Right click and choose the Data validation option.Data in the top menu ➜ Click the Data validation option.STEP 2: Open the Data validation menu using either: STEP 1: Select the cell/s you want to have a date picker: Not on desktop? Click for mobile instructions: iPhone/iPad and Android. This is a date picker (or dropdown calendar) in Google Sheets: In the popup menu change the Criteria dropdowns to Date ➜ is valid date and then Save.ĭouble click on the selected cell/s to bring up the dropdown calendar. In the main menu go to Data ➜ Data validation. Select the cell/s you want a date picker in.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |