Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

You are here

Home › Videos › Using Format Cells to apply font settings in Excel

Using Format Cells to apply font settings in Excel

Transcript 

An alternative to using the ribbon to apply fonts is to use the Format Cells dialog box. The Font tab in Format Cells has more options, but the ribbon has advantages for basic settings.

Let's take a look.

As we looked at in a previous lesson, the Font group on the ribbon provides access to fonts, font sizes, font color, and basic font styles.

The Font tab of the Format Cells dialog box contains all of these options and several more. You can access the Font tab of the Format Cells dialog box using the arrow at the bottom of the font group or using the keyboard shortcut Control-Shift-F.

In addition to font controls on the ribbon, the Format Cells dialog box contains settings for Subscript, Superscript, and Strikethrough formatting, and several types of underlining.

So, you could use Format Cells for almost all of your font formatting needs.

However, for basic font formatting, there are some disadvantages in using the Format Cells dialog box because its controls are more limited than the ribbon's. For example, the font menu is just a plain list and only displays six fonts at a time.

It also doesn't respond to typing, so you can't select a font by typing the first few letters of its name. As a result, scrolling through a long list of fonts is tedious.

In addition, the changes you make in the Format Cells dialog box are previewed only in a small preview window, not in the worksheet. You'll need to click OK to see the effect of changes in the worksheet.

In contrast, the ribbon provides a much larger and more useful font menu. It shows you what each font looks like and provides a live preview of font, color, and size. For basic font formatting, it's a better choice.

Master Excel with practice. Download this worksheet (and dozens more) in our Core Excel course. Learn by doing.

Dave Bruns Profile Picture

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Microsoft Most Valuable Professional Award  

Exceljet Training

  • Excel 101
  • Excel Fundamentals
  • Conditional Formatting
  • Essential Formulas
  • Advanced Formulas
  • Pivot Tables
  • Excel Tables
  • Excel Shortcuts
  • Excel Charts
  • Course Bundles
Love your website. Your algorithms are clever and innovative. Your examples are easy to follow. And I've never seen a cleaner looking website. It has been extremely helpful to me.
I've never seen a cleaner looking website
More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact
  • Donate

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2025 Exceljet. Terms of use
  • Visit our Twitter page