Home|Developers|IT Pros

Products

Downloads

Help and How-To

Shop Now

Excel 2008 Help and How-To

Search Excel 2008


Search All Products

Learn More About

Word 2008

Excel 2008

Setup and Settings

What's new in Office

Learn about Excel: Create your first workbook

Get up to speed with the Office Elements Gallery

So that's how: great Excel features

Great Excel 2008 features

Check for software updates automatically

Specifications and limits for Excel 2008

Explore the bigger grid in Excel 2008

Proofing tools that are available for each language

Multilingual features in Office 2008

Change the currency symbol

Turn on Japanese language features

Use furigana (phonetic guides) with Japanese text

Research words and topics by using the Reference Tools

Plan an event by using Project Center

Spelling

Add a word to the spelling dictionary

Change the language of the spelling dictionary

Create and use a custom dictionary

Look up a word in the Office dictionary

I can't type characters for a certain language.

Known issues in Excel 2008

Excel Training

Courses

So that's how: great Excel features

Get up to speed with the Office Elements Gallery

Analyze your data with PivotTable reports

Customize your applications by using accessibility features

Design great-looking documents with themes

Get started with charts

Let Excel do the math: introduction to formulas and functions

Manage your finances with ledger sheets

Manage your lists by sorting, adding, and filtering

Videos

Get started with Excel 2008

Great Excel 2008 features

Build formulas by using the new Formula Builder in Excel 2008

Dealing with Visual Basic macros in Excel 2008

Explore the bigger grid in Excel 2008

Get started with charts in Office 2008

Get the most out of Help in Office 2008

Manage your finances with the new, preformatted Ledger Sheets

Save time by using predefined workflows

QuickTip - Format, insert, research, and clip with the Toolbox

QuickTip - Get a fast and free document translation

QuickTip - Insert a spreadsheet snippet

QuickTip - Excel worksheet tips

QuickTip - Access your pictures within Office

QuickTip - Download and use clip art from Office Online

Learning roadmap for Excel

Accessibility

Customize your applications by using accessibility features

Accessibility options

Common Office keyboard shortcuts

Excel keyboard shortcuts

Keyboard shortcuts for the euro currency symbol

My keyboard shortcut doesn't work

Customizing Excel

Turn off automatic changes

Turn off hyperlink formatting

Add or edit automatic corrections

Change the preferred folder for opening and saving workbooks

Change how often files are automatically saved

Change the number of sheets in new workbooks

Change the unit of measurement

Change Toolbox settings

Control how workbooks and sheets are created

Create a custom keyboard shortcut

Customize how Excel opens

Customize toolbars and menus

Display font menus in plain text

Hide a reference tool

Reset menus and toolbars

Turn off editing directly in a cell

Change how the Toolbox appears when it is inactive

Great Excel 2008 features

Change the highlight color of selected cells

Compatibility

Best practices for working with Windows

Sharing documents with other versions of Office

Turn off Compatibility Report

Freely rotated objects in earlier versions of Office

Pictures in earlier versions of Office

Shadows in earlier versions of Office

SmartArt graphics in earlier versions of Office

Transparent objects in earlier versions of Office

Text and shape effects in earlier versions of Excel

Embedded Office 2008 files in earlier versions of Office

Change the file format for saving workbooks

File formats for saving workbooks

Save a workbook as a Web page

Limitations of saving a workbook as a Web page

I can't open an Office document that has restricted permission.

My characters appear differently in earlier versions of Office.

My QuickTime movie doesn't play in Office for Windows

Workbooks and Sheets

Add a custom sheet to the Elements Gallery

Copy or move a sheet

Delete a sheet

Insert or delete cells, rows, columns, or sheets

Move or copy cells, rows, columns, or sheets

Rename a sheet

Select a group of sheets

View multiple sheets or workbooks at the same time

Delete files

Edit a file that is on a site or workspace

Formatting

Fix data that is cut off in cells

Change cell borders

Remove contents, hyperlinks, or formatting

Shade every other row on a sheet

Design great-looking documents with themes

Find templates for Word, Excel, and PowerPoint

Fit more text in column headings

Sheet Appearance

Change column width or row height

Freeze rows and columns

Hide gridlines on a sheet

Merge or split cells or cell contents

Hide error values and error indicators

Display formulas, rows, columns, or cell values

Hide a window

Change gridline color

Add a watermark to a sheet

Adjust the column size to see everything

Freeze column headings for easy scrolling

My column headings are labeled with numbers instead of letters

Headers and Footers

Create a header or footer

Add a watermark to a sheet

Hyperlinks

Create, edit, or remove a hyperlink

Select a cell that contains a hyperlink

Turn off hyperlink formatting

Remove all hyperlinks on a sheet

Formulas and Functions

Let Excel do the math: introduction to formulas and functions

Build formulas by using the new Formula Builder in Excel 2008

Calculation operators and order of operations

Control calculation

Refer to the same cell or range on multiple sheets

Show the formula bar

Enter a formula

Use names in formulas

Change a formula

Move or copy a formula

Replace a formula with its result

Switch between relative and absolute references

Errors

Correct a circular reference

Correct an inconsistent formula

Find errors in formulas and cells

Hide error values and error indicators

I see ##### instead of content in some cells.

I see #DIV/0! instead of content in some cells

I see #N/A instead of content in some cells

I see #NAME? instead of content in some cells

I see #NULL! instead of content in some cells

I see #NUM! instead of content in some cells

I see #REF! instead of content in some cells

I see #VALUE! instead of content in some cells

Math Examples

Raise a number to a power

Round a number

Calculate percentages

Add a list of numbers in a column

Counting Examples

Count cells that contain data

Count numbers greater than or less than a number

Count unique values among duplicates

Date and Time Examples

Subtract dates

Subtract times

Insert the current date and time

Show dates as days of the week

Financial Examples

Calculate a running balance

Statistical Examples

Calculate an average

Text Examples

Combine first and last names

Function Reference

List of all functions by category

Excel 4.0 (XLM) macro commands

My function doesn’t work.

Database

Date and Time

Engineering

Financial

Information

Logical

Lookup and Reference

Math and Trigonometry

Statistical

Text

Data

Entering Data

Create a list

Enter a series of numbers, dates, or other items

Insert a bullet, symbol, or special character

Have Excel complete your lists

I can't copy and paste data on my sheet.

Add, delete, or find data in a list

Importing Data

Import data from a database

Import data from a CSV, HTML, or text file

Import data from FileMaker Pro

Fix broken links to data

Sorting and Filtering Data

Sort a list of data

Filter a list of data

Manage your lists by sorting, adding, and filtering

Finding and Replacing Data

Copy formula results or formatting

Find or replace text and numbers

Remove duplicate rows

Analyzing Data

Predict data trends

I can't find Solver

I can't find the Analysis ToolPak

Summarizing and Consolidating Data

Add up totals for sales data

Applying Conditional Formatting

Change conditional formatting

Highlight data points

Validating Data

Restrict data entry

Controlling Number Display

Prevent formatting of numbers

Create a custom number format

Display dates, times, currency, fractions, or percentages

Control how zero values are displayed

Charts

Change data for a chart

Format a chart

Add or edit data labels on a chart

Change the order of categories, values, or series in a chart

Create a combination chart

Add error bars to a chart

Add a secondary axis to a chart

Chart your data for high impact

Get started with charts

Get started with charts in Office 2008

Ledger Sheets

Change the appearance of a ledger sheet

Add or delete a row on a ledger sheet

Add or delete a column on a ledger sheet

Rename a column in a ledger sheet

Assign a category to an item on a ledger sheet

Create or delete a custom category for a ledger sheet

Assign a priority to an item on a ledger sheet

Save a ledger sheet as a template

My data does not import correctly into a ledger sheet

Manage your finances with ledger sheets

Manage your finances with the new, preformatted Ledger Sheets

Pictures and Shapes

Add or edit a SmartArt graphic

Create an organizational chart

Store text and graphics for future use

Add a watermark to a sheet

Graphics file types you can insert and save

Use a logo across Office applications

I can't see the object that I want to select

Aligning and Arranging Objects

Align objects

Move, rotate, or flip an object

Group, arrange, or distribute objects

Creating and Editing Objects

Add or replace a picture

Add or change a shape

Add or change a line

Create transparency in a picture

Copy formatting between objects

Cropping and Sizing Objects

Crop or trim a picture

Equations

Fills, Shadows, and Effects

Add an effect to a picture

Add effects to text

Apply Quick Styles and preset effects

Change fill color or fill effects

Create or delete a custom theme color

Apply a theme color

Create a custom theme

Copy formatting between objects

Give your Office documents a stylish look

Make a picture look 3-D

PivotTable Reports

Analyze your data with PivotTable reports

Create a PivotTable report

Sort and filter a PivotTable report

Refresh data in a PivotTable report

Printing

Set page margins

Adjust page breaks before printing

Fit a fixed size or number of pages

Preview pages before printing

Print with landscape orientation

Create and print mailing labels

Print with formulas displayed

Print cell gridlines

Print comments

Print headings or labels on every page

Print part of a sheet

Add a watermark to a sheet

Print your sheet on just one page

Repeat column headings on each page of a printout

Security and Privacy

Help protect your privacy

Protect sheet elements

Use passwords to help protect documents

View the privacy statement

Information Sharing

Merge changes from copies of a workbook

Share a workbook

Share data between applications

Track and review changes to a workbook

Comments

Add or remove a comment

Display comments or their indicators

Troubleshooting

I can't copy and paste data on my sheet.

I see ##### instead of content in some cells.

I see #DIV/0! instead of content in some cells

I see #N/A instead of content in some cells

I see #NAME? instead of content in some cells

I see #NULL! instead of content in some cells

I see #NUM! instead of content in some cells

I see #REF! instead of content in some cells

I see #VALUE! instead of content in some cells

My data does not import correctly into a ledger sheet

My function doesn’t work.

My column headings are labeled with numbers instead of letters

My Visual Basic macros don't work

Dealing with Visual Basic macros in Excel 2008

I can't find Solver

I can't find the Analysis ToolPak

Technical support options

PowerPoint 2008

Entourage 2008

Messenger for Mac

Remote Desktop Connection

Training

Courses

Videos