Book Image

101 Excel 2013 Tips, Tricks and Timesavers

By : John Walkenbach
Book Image

101 Excel 2013 Tips, Tricks and Timesavers

By: John Walkenbach

Overview of this book

Excel is a popular program. Millions of people throughout the world use it on a regular basis. But it’s a safe bet that the vast majority of users have yet to discover some of the amazing things this product can do. 101 Excel 2013 Tips, Tricks, & Timesavers?is packed with information that you need to know in order to confidently and seamlessly master the challenges that come with using Excel! Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka "Mr. Spreadsheet," shares new and exciting ways to accomplish and master all of your spreadsheet tasks. From taming the Ribbon bar to testing and tables, creating custom functions, and overcoming "impossible" charts, mixing nesting limits, and more,?101 Excel 2013 Tips, Tricks, & Timesavers?will save you time and help you avoid common spreadsheet stumbling blocks.
Table of Contents (10 chapters)
Free Chapter
1
Cover
2
Table of Contents
3
Title Page
4
Introduction

Tip 25: Updating Old Fonts

When you install Microsoft Office, several new fonts are added to your system, and these new fonts are used when you create a new workbook. The exact fonts that are used as defaults vary, depending on which document theme is in effect.

cross_ref.eps   See Tip 10 for more information about using document themes.

If you use the default Office theme, a newly created Excel workbook uses two new fonts: Cambria (for headings) and Calibri (for body text). When you open a workbook that was saved in a version prior to Excel 2007, the old fonts (probably Arial) aren’t updated. The difference in appearance between a worksheet that uses the old fonts and a worksheet that uses the new fonts is dramatic. When you compare an Excel 2003 worksheet with an Excel 2013 worksheet, the latter is much more readable and appears less cramped.

Figure 25-1 shows a workbook that was created in Excel 2003.

9781118642184-fg02501.tif

Figure 25-1: This Excel 2003 workbook uses Arial 10...