The most obvious way to increment a number in Excel is to add a value to it. Start with any value in cell A1, and enter "=A1+1" in cell A2 to increment the starting value by one.

Microsoft Excel users, follow these two easy methods to reduce data entry time and errors when customized features aren't available.

In this tutorial, I’ll show you how to combine a custom number format and data validation to force users to enter the correct number of numeric digits.