Apply bold to totals, key assumptions in your math, and conclusion cells. Bold. Draw attention to key cells using bold formatting.You probably already know what these three tools do, but how should you use them in a spreadsheet? Here are some ideas on how you can apply those styles: These are the most basic tweaks that you can use, and you’ve probably seen them in practically every app with text editing, like Microsoft Word or Apple Pages. Use the Bold, Italic, and Underline commands The text will change to the selected font color. On the Home tab, click the drop-down arrow next to the Font Color command, then select the desired font color.ģ. Highlight the font size already there and type in your own font size and then hit Enter.Ģ. You can also enter a a custom font size using your keyboard. These are especially helpful when you know you want text to be proportionally bigger or smaller without knowing an exact font size. Notes: You can also use the Increase Font Size and Decrease Font Size commands on the Ribbon. The text will change to the selected font size.
In our example, we will choose 18 to make the text larger.ģ. Along with Calibri, standard reading fonts include Cambria, Times New Roman, and Arial.Ģ. On the Home tab, click the drop-down arrow next to the Font Size command, then select the desired font size. Note: When creating a workbook, you will want to select a font that is easy to read. The text will change to the selected font. Click the drop-down arrow next to the Font Select the desired font.ģ.In the example below, we’ll format our title cell to help distinguish it from the rest of the worksheet. However, Excel provides many other fonts you can use to customize your cell text. Change the fontīy default, the font of each new workbook is set to Calibri. Use as much formatting as you need to make your files comprehensible and easy to follow. Cells with formatting will draw the viewer’s attention to the important cells.įormatting not only makes Excel files look better, but it can make a spreadsheet easier to read, more relatable and understandable. Good formatting helps your user find meaning in the spreadsheet without going through every individual cell. You can find them useful, but that doesn’t mean that you can’t bring some style and formatting to your spreadsheets. We often see spreadsheets as boring and purely tools to manage numbers and data.