Office Tips and Hints Blog

Home Page

Host your Web site with PureHost!

Tuesday, November 24, 2009 – Permalink –

Formatting Overview

Looking good

The judicious use of formatting can make data easier to understand as well as pleasant to see.
Scott Lowe put together a series of articles on how to format data in Excel.

The Articles are on TechRepublic.com

Anatomy of Excel formatting: Part 1

Boldface, italicize and underline cell content
Change the size and font of your text
Apply a default Excel style (i.e. dollar, percent, etc) to cells
Use date and time formatting in your spreadsheet
Apply shading

Anatomy of Excel formatting: Part 2

Apply borders
Resize rows
Resize columns

Anatomy of Excel formatting: Part 3

Text formatting
Justify cell contents
Change the direction of the text in your spreadsheet
Word wrap text

Anatomy of Excel formatting: Part 4

Automatically format cells based on their contents
Change the margins for your printed page
Add a header and footer to your printer spreadsheet

[Edited entry from 11/20/2006]

See all Topics

Labels: Excel

<Doug Klippert@ 3:37 AM

Comments: Post a Comment

Links to this post:

<$BlogBacklinkTitle$>: <$BlogBacklinkSnippet$>
posted by <$BlogBacklinkAuthor$> @ <$BlogBacklinkDateTime$>

Create a Link