To create a validation list with multiple columns, we'll need to trick Excel to accept to create a validation list with multiple columns Example to show the range A1 to C20 (20 rows and 3 columns).

That’s where a table with expandable rows can come in handy. At the NICAR data journalism conference earlier this year, I posted a form so speakers (and other attendees) could submit links to ...

How to Clear the Column List in an Excel Spreadsheet. Microsoft Excel is filled with a number of quick tricks that can be used to make fast changes to multiple cells in a spreadsheet. Clearing all ...