Home / Tricks / A drop-down list in 20 seconds
// trick 043 · Shortcuts

A drop-down list in 20 seconds

The formula to copy, for Excel with Italian function names and for Google Sheets.

The formula

EXCEL (ITALIAN)Dati › Convalida dati › Consenti: Elenco › Origine: =$H$2:$H$8
GOOGLE SHEETSDati › Convalida dei dati › Elenco da un intervallo
// this trick is already inside

2027 Goals Planner

Goals and progress month by month, with a status that updates itself.

See the template