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.

Luckily, Excel offers handy formulas that allow you to convert text into upper case, lower case, title case, and even sentence case with minimal effort.

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.