Feb 23, 2013
When creating a validation list, it is often neater to store the source of the list on a separate worksheet, away from the main data. In Excel 2007 and earlier, you can’t store the “list source” on a different sheet to where the list will be used,...
Feb 17, 2013
In Excel (and other spreadsheets), most of the time we refer to a cell or a range by using it’s address, for example A1 or A1:B10. However, assigning a “name” to a cell or range provides a number of benefits. The quickest way to assign a name to a...
