O'Reilly logo

Creating Spreadsheets and Charts in Microsoft Office Excel 2007 for Windows: Visual QuickProject Guide by Maria Langer

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

6. format worksheets

Although the information in our four worksheets is accurate and informative, it doesn’t look very good. And in this day and age, looks are almost everything. We need to dress these worksheets up to make them more presentable.

Excel offers many extremely flexible formatting options. Our worksheets can benefit from some font and number formatting, as well as alignment, borders, and color. As shown here, we’ll transform our plain Jane worksheets into worksheets that demand attention.

On the following pages, I’ll show you how to apply formatting to the January worksheet. You can repeat those steps on your own for the other worksheets in our workbook.

Before

After

set font formatting

Font formatting changes the way individual ...

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