Microsoft Excel's Data Validation tool lets you add a drop-down list to a cell based on existing data in a column. However, how this works depends on whether the source data is part of a formatted ...
How-To Geek on MSN
Excel for Windows Gets a Feature That Could Save You Hours
In the screenshot below, when the first and last initials of the names in columns A and B are typed into cells C2, C3, and C4 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback