Join Dennis Taylor for an in-depth discussion in this video Exploring font styles and effects, part of Excel 2016 Essential Training.
- We're looking at the worksheet Fonts in the workbook 04-Formatting. If you click on a cell, on the Home tab you can see what font is being used. Standard font in Excel is called Calibri, as it has been for the last few versions of Excel, and the standard size is 11. At different times, you might want to consider changing these. If we want to make these numbers stand out a little bit more strongly, we could possibly use a larger size, think that'd be 12. Or, instead of that, as I press Control Z to undo, we could consider some other options in the Font group here on the Home tab.
Make them Bold, Italic, Underline. Any two, any one, any combination of those, as desired. All of these are what we call toggle buttons. They're on, off. Click them once to apply the feature, again to remove the feature, for times you can easily get to these. Sometimes you want to change the actual font type. Now in older versions of Excel, the standard font was called Arial, size 10. Off to the right, although of not of huge importance, you can see a comparison of the two.
Calibri 11, the current standard. Arial 10, pretty much the same although you will see, at different times, a difference, like, between the numbers, seven. The way they're depicted. The dollar sign, slight difference there. Sometimes you're looking at a worksheet, it might look a little strange to you or funny. Maybe it's Arial, size 10, instead of Calibri 11, or vice versa. It's what you're used to that counts. There will be times, too, when you want to change the actual font, for example, in a title. So, I'm clicking on this merged cell that appears across the top of the worksheet, here.
On the Home tab next to Candara is a drop arrow and I can slide over some other choices here as well. If you're an indecisive person, well, you're going to have a tough time out here deciding on which one works best. Do notice that the font's size varies with some of these different choices. Some of the fonts, you'll want to use a larger number, or smaller number, for the actual font size here. So, lots of choices there too. And at different times, you might want to consider some other possibilities, here, that are not available in this Font group.
You can click the little arrow to the right. It's called a dialogue box launcher. Click that. You can also get here by way of Control 1, although it doesn't always take you to the Font tab. But once here, you can also see we've got some font choices available for Strikethrough. If you need to use Superscript or Subscript, you'll see those here. And possibly you could come here to apply a number of different features at the same time. So you could be applying Bold, and the font type itself, and the size, and a few other features all at once, if you wish.
If you simply want to change the font color, if you want the color here to be different, I strongly advise against using red. If you click the drop arrow here, using red sometimes, for a lot of people working with numbers, think those are negatives. So stay away from red. Dark Blue might work just fine, here, maybe Bold, although certainly not necessary. So lots of different capabilities here for working with different font choices. Primarily from the menu, occassionally from that dialogue box that you can get to from the corner.
Author
Released
9/22/2015- Working with the Excel interface
- Entering data
- Creating formulas and functions
- Formatting rows, columns, cells, and data
- Working with alignment and text wrap
- Adjusting rows and columns
- Finding and replacing data
- Printing and sharing worksheets
- Creating charts and PivotTables
- Inserting and deleting sheets
- Using power functions such as IF and VLOOKUP
- Password-protecting worksheets and workbooks
- Sorting data
- Analyzing data with Goal Seek and Solver
- Creating and running macros
Skill Level Beginner
Duration
Views
Related Courses
-
OneNote Tips and Tricks
with Heather Severino2h 3m Intermediate -
Word 2016 Essential Training
with David Rivers5h 41m Beginner
-
Introduction
-
Welcome38s
-
-
1. Getting Started with Excel
-
What is Excel used for?2m 14s
-
Using the menu system5m 50s
-
Using the Formula bar1m 37s
-
Using the Status bar5m 20s
-
Using navigation tools3m 24s
-
Creating new workbooks2m 37s
-
Using Excel Help5m 28s
-
-
2. Entering Data
-
Entering data with AutoFill3m 56s
-
Working with dates and times4m 28s
-
Using Undo and Redo4m 13s
-
Adding comments2m 52s
-
Using Save or Save As4m 11s
-
3. Creating Formulas and Functions
-
Creating simple formulas7m 11s
-
Using SUM and AVERAGE5m 18s
-
Using other common functions7m 44s
-
-
4. Formatting
-
Designing borders2m 55s
-
Formatting numbers and dates7m 18s
-
Using conditional formatting8m 13s
-
Creating and using tables11m 18s
-
5. Adjusting Worksheet Layout and Data
-
Finding and replacing data5m 30s
-
6. Printing
-
Previewing page breaks5m 53s
-
7. Charts
-
Creating charts6m 45s
-
Exploring chart types9m 53s
-
Formatting charts7m 12s
-
New charts in Excel 201610m 19s
-
-
8. Adjusting Worksheet Views
-
9. Multiple Worksheets and Workbooks
-
10. IF, VLOOKUP, and Power Functions
-
11. Security and Sharing
-
Protecting workbooks5m 50s
-
Sharing workbooks3m 57s
-
Tracking changes5m 17s
-
12. Data Management Features
-
Sorting data9m 44s
-
Using filters6m 43s
-
Removing duplicate records2m 23s
-
Using validation tools10m 45s
-
-
13. Data Analysis Tools
-
Using Goal Seek7m 14s
-
Using Solver7m 3s
-
Using Scenario Manager6m 38s
-
Using data tables8m 21s
-
-
14. PivotTables
-
Creating PivotTables12m 25s
-
Manipulating PivotTable data11m 27s
-
Grouping by date and time10m 50s
-
Grouping by other factors4m 40s
-
Using PivotCharts4m 42s
-
-
15. Introduction to Macros
-
Creating a simple macro10m 20s
-
Running a macro13m 46s
-
Conclusion
-
Goodbye35s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Exploring font styles and effects