Excel Guides

Working with Fonts in Excel

When working with fonts in Excel, there are a few things to keep in mind. First, Excel supports a variety of font types, including TrueType, OpenType, and PostScript. Second, you can change the default font type and size for new workbooks by going to File > Options > General and selecting a new font from the drop-down menu. Finally, when working with text in cells, you can format it using the Font group on the Home tab. This includes changing the font type, size, color, and adding effects like bolding, italics, and underlining.

When it comes to choosing a font type, there are a few things to consider. First, what kind of document are you creating? If it's something that will be printed out, you'll want to choose a serif font like Times New Roman or Garamond. These fonts are easy to read at small sizes and have been designed specifically for print documents. If you're creating something for the web or digital display, however, you'll want to choose a sans-serif font like Arial or Helvetica. These fonts are easier to read on screens and won't get lost when printed at smaller sizes.

Once you've chosen a general category of font, you can start narrowing down your options by considering things like weight (light, regular, bold), style (italic or not), and width (condensed or extended). For example, if you want something that's easy to read at small sizes but still has some personality, you might choose a light or regular weight sans-serif font with an italic style. Or if you need something that's going to make a big impact on the page, you might go for a bolder weight or an extended width.

Once you've chosen a font typeface, it's time to start thinking about size. Again, this will largely depend on what kind of document you're creating and how it will be used. For print documents intended to be read at close range (like books), 12-point type is usually considered the minimum size. For documents that will be viewed from further away (like newspapers), 14-point type is more common. And for digital displays where people will be scrolling through large amounts of text (like websites), 16-point type is often used.

Finally, don't forget about color! While black is the standard color for text in most documents, there are times when using another color can be effective. For example, if you want to highlight something important in your document or make it more visually interesting, using a different color for your text can be a good option. Just be sure not to use colors that will be difficult to read or clash too much with the rest of your document.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.