We all love to save time and here’s a great tip to make repetitive cell entries in Excel just so much easier to complete.
You do this by making a drop-down list in a cell so you can select your entry from it rather than having to type it fresh each time.
To do this:
- Type the list of items to use in a single column in a spare sheet in the workbook.
- Select these cells and choose Insert, Name, Define and type DataForList and click Ok.
- Move to the sheet where the data goes, select the cells for the drop-down list and choose Data, Validation, Settings tab. From the Allow list choose List and, in the Source area, type =DataForList and click Ok.
Now, whenever you click a cell in this range you’ll see a list box indicator appear and you can choose the cell entry from the list.
Thanks Helen.. a great tip.. I was doing something similar but this is much more efficient!