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.

Fortunately, Excel is flexible enough to handle long text in several ways.To bypass the ribbon interface to apply Shrink to fit, press Alt, H, F and A. Doing so will open the Format Cells dialog ...