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

Simply select the data input range and start entering data. Excel will move the cursor from column to column until you reach the right-most column in the selection.