You are here LEARN EXCEL & VBA Excel Tips Excel Text, Editing and Format Changing the Default Style

Changing the Default Style

The default Style name is Normal.

To change the default Style:

1. From the Format menu, select Style.
2. From the Style name dropdown list, select Normal.
3. Click Modify.
4. Select the Number tab.
5. In the Category box, select Custom.
6. In the Type box, enter the following format:
#,##0;[Red]-#,##0;0;@ (or any other custom number formatting chosen)
7. Select the Font tab.
8. Select the font and the desired font size, and then click OK.

This only changes the normal style for the current workbook.