Articles | Photoshop blog | Photography blog | about me | e-mail

Helen Bradley - MS Office Tips, Tricks and Tutorials

I'm a lifestyle journalist and I've been writing about office productivity software for a long time. Here you'll find handy hints, tips, tricks, techniques and tutorials on using software as diverse as Excel, Word, PowerPoint, Outlook, Access and Publisher from Microsoft and other applications that I love. My publishing credits include PC Magazine, Windows XP mag, CNet, PC User mag, SmallbusinessComputing.com, Winplanet and Sydney Morning Herald.

Saturday, February 3, 2007

Automatic Excel cell entries

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:
  1. Type the list of items to use in a single column in a spare sheet in the workbook.
  2. Select these cells and choose Insert, Name, Define and type DataForList and click Ok.
  3. 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.

Labels: , , , , , ,

Add to Technorati Favorites