O'Reilly logo

Office 2010 Made Simple by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Formatting Cells and Ranges

In Excel, you can format cells in a wide variety of ways—everything from choosing how to display the borders and background to controlling how Excel represents the text you enter in the cell. This section shows you how the most useful kinds of formatting work and shows you how to apply them.

Each cell comes with essential formatting applied to it—the font and font size to use, and usually the General number format, which you'll meet shortly. So when you create a new workbook and start entering data in it, Excel displays the data in a normal-size font.

TIP: To control the font and font size Excel uses for new workbooks, choose File Excel Options. In the General category, go to the When creating new workbooks area. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required