In Excel, custom input or error messages explain the rules for each field to prevent data-entry errors. Here's how to set them up in a spreadsheet.

Susan Harkins shows you how to format and unlock input cells in Excel at the same time by assigning a modified style.

Automating the selection process isn't difficult if you rely on VBA's InputBox in Microsoft Excel.