How to Change Default Fonts in Excel


The default font for Excel spreadsheets is usually Arial, with the size set at 10. However, there are other options for fonts that will make worksheets appear bolder and more readable. The user can change the font attributes for a cell or a group of cells and for a worksheet or a workbook.

Change the Font Attributes in a Worksheet

  • Select the cell, or group of cells, that you want to format. To select one cell, place the mouse pointer on the cell and click the left mouse button. To select a group of adjacent cells, click on one of the cells and drag the mouse pointer to highlight all the cells in the group.

  • Locate the font box on the tool bar. Click the arrow on the right side of the box to see the drop down menu. The menu contains the various fonts.

  • Change the default font. Use the scroll bar on the right side of the menu to see all the fonts available. Click on a font to select it.

  • Change the font size. Click on the font size box, located on the right side of the font box, to select a new font size. You can also increase the font size with the "Increase Font Size" button or decrease it with the "Decrease Font Size" button.

Change the Font Attributes in a Workbook

  • Open the "Options" dialog box. Click on "Tools" on the tool bar and select "Options." This opens the Options dialog box in which you can change the default attributes of your workbook.

  • Change the default font. Click the "General" tab and then click the arrow in the "Standard font" field. Select a new font from the list.

  • Change the font size. Click the "Size" box and select a new font size.

  • Click "OK" when you have finished making your changes. You will have to restart Excel in order for the changes to take effect.

Tips & Warnings

  • The options you select for your Excel workbooks will only apply to new workbooks. If you want your current workbook to reflect the changes that you have made, you will need to copy the data into a new workbook.

Related Searches

Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!