Change the font style and size for a worksheet

Note: You cannot change the default font for an entire workbook in Excel for the web, but you can change the font style and size for a worksheet.

When you enter data in a worksheet, Excel automatically uses the Calibri font style in size11 but if you prefer a different font style or size, here’s how you can change them:

font options on the Excel Ribbon

  1. Select the cell or cell range that has the text or number you want to format.

  2. Click the arrow next to Font and pick another font.

pick another font style

  1. To change font size, click the arrow next to the default Font Size and pick the size you want.

    In our example below, we’ve changed the font style to Century and size to 9.

    changed to a new font from the default worksheet font.

Tip: Data added to cells outside the newly formatted cell range would appear in the default style and size and you’ll need to repeat the above steps to format them. You can also select blank cells and apply the formatting before entering data.

You can also change the way the text is placed in a cell.

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.