When crafting an Excel 2010 spreadsheet for your business, ... Excel knows how to auto-populate cells with days, months and years. ... then click "Merge" in the "Alignment" area of the ribbon.

Open your Excel spreadsheet. Select the cell for which you want to disable auto-formatting. To select multiple cells, click and drag your mouse over the desired range.