ACCC Seminars

Welcome
Getting Started
Entering and Editing Data
Formulas and Functions
Formatting Cells
Page Setup and Print Preview
Charting
Related Links

Handout (PDF)
ACCC Seminars
Rev. Sep 15/2001

Formatting Cells


 

The Formatting Toolbar

Like many applications, you can format the cells in your spreadsheet for different fonts, font sizes, and colors. The FORMATTING TOOLBAR, located at the right side of the main Toolbar, allows you to format selected cells.

These buttons allow you to make text bold, italic, underline, change alignment in the cell, text color, and cell background color. There are also buttons for formatting numbers for currency, comma, percentage, and to regulate the number of decimal places displayed. <Click here> to see a video demonstration of the Formatting Toolbar in action. (1.88MB)

Format Painter

You can also copy the formats of one cell to another with the Format Painter button. Firstly, click on the cell containing the formats you wish to copy. After clicking the Format Painter button on the Standard Toolbar, drag over the cells which will receive the formats. <Click here> for a video demonstration. (281K)
Back to TopFormulas and Functions Absolute Cell References Page Setup and Print Preview Page Setup and Print Preview
   

Seminar materials:
<http://www.accc.uic.edu/seminars/excel2000-intro>

Last Modified: September 15, 2001 — pjm