Excel 2007 for Starters: The Missing Manual

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

calculations

     chart data 2nd

     copying formulas 2nd 3rd 4th 5th

     formulas and 2nd 3rd 4th

     Status bar and

Cancel command

capitalization

     AutoCorrect and 2nd

     function names

CAPS indicator 2nd

Caps Lock key 2nd

cascade arrangement

case sensitivity

category axis

     column charts and

     date or time values 2nd

     line chart and

     non-contiguous ranges

     value axis vs.

category-axis scaling

cell appearance

     alignment 2nd 3rd 4th

     borders 2nd 3rd

     color

     fonts 2nd 3rd 4th 5th

     orientation

     patterns 2nd

cell ranges

     cell references and

     Chart Wizard and

     continuous 2nd

     freezing

     specifying 2nd

cell references

     absolute 2nd 3rd

     conditional formatting and

     fixed

     formulas and 2nd 3rd

     partially fixed

     relative

cell value

     conditional formatting 2nd

     finding and replacing 2nd 3rd

     formatting dates 2nd 3rd

     formatting numbers 2nd 3rd 4th 5th 6th 7th 8th

     special numbers 2nd

     storing dates

     storing times

cells (see also non-contiguous cells)

     address format

     automating repetitive tasks

     blank 2nd

     copying values multiple times

     edge 2nd

     entering information

     grouped worksheets and 2nd

     merging

     moving around 2nd 3rd 4th

     overlapping columns 2nd

     rotating content

     selecting 2nd 3rd

     shortcut keys

     wrapping text

Chart command

     Chart Wizard and 2nd

     non-contiguous ranges

Chart Options command

Chart Type command

Chart Window command

Chart Wizard

     changing chart options

     changing series order

     Custom Types tab

     multiple series of numbers

     non-contiguous ranges

     Standard Types tab

charts (see also embedded charts; standalone charts)

     adding data 2nd

     configuring options

     controlling plots on x-axis

     custom types

     date or time scales 2nd

     editing data 2nd

     moving and resizing 2nd 3rd

     non-contiguous ranges

     printing 2nd 3rd

     static ranges

     types of 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th

Circular Reference

Clip Art task 2nd

Clippy 2nd 3rd

Close command

     multiple spreadsheets and

     multiple workbooks and

clustered column charts 2nd 3rd

Collapse Dialog Box icon 2nd

colon (:) 2nd

color

     formatting

     grouped worksheets

     of active worksheet

     printouts and 2nd

     template and

     worksheet tabs

column charts

     3-D version

     category axis and 2nd

     example of

     too many columns

Column command

     AutoFit Selection option

     Hide option

     Standard Width option

     Unhide option

columns

     adding

     adding titles

     adjusting width 2nd 3rd 4th 5th

     alignment 2nd

     AutoComplete

     AutoFill feature 2nd 3rd 4th

     AutoFit feature

     AutoFormat templates

     blank

     charts and

     custom view settings

     fixed in place

     formatting 2nd 3rd

     freezing 2nd 3rd

     hiding

     maximum number

     partially fixed references

     plotting data 2nd

     print area

     Scaling setting

     searching

     selecting 2nd

     shading

     standard size

     vertical split

Columns command 2nd

COMBIN( ) function 2nd 3rd

comma (

     Currency format and

     determining data type 2nd

     Number format and

Comma worksheet style

comma-delimited text files

Comment command

comments 2nd

conditional formatting 2nd

conditions 2nd

constants

continuous range 2nd 3rd

Control Panel 2nd

conversions

     formats supported and

     special number formats

Convert to Number menu option

Copied Cells command

Copy command

     copy-and-paste operation

copy-and-paste operation

     grouped worksheets

     inserting cells

     paste icon

     process for 2nd 3rd

     source data in

copyright symbol ((c))

corrupted files 2nd

COS( ) function

CSV file type

Ctrl key

     copying text

     Find All feature

     grouping worksheets

     non-contiguous selection and

     selection with

     transferring multiple worksheets

Ctrl+arrow-key combination 2nd

Ctrl+C key combination

     displaying clipboard

Ctrl+End key combination

Ctrl+Enter key combination

Ctrl+F key combination 2nd

Ctrl+F6 key combination

Ctrl+H key combination

Ctrl+Home key combination

Ctrl+Page Down key combination

Ctrl+Page Up key combination

Ctrl+S key combination

Ctrl+Shift+F6 key combination

Ctrl+Shift+Tab key combination

Ctrl+Tab key combination

Ctrl+V key combination

     clipboard and

     pasting formulas

Ctrl+X key combination 2nd

Ctrl+Y key combination

Ctrl+Z key combination

     deleting worksheets

     undoing changes

Currency format

     example of

     searching

currency symbol

     Accounting format

     Currency format 2nd 3rd

     regional settings and

Currency worksheet style

custom dictionary

Custom Views command 2nd 3rd

custom.dic dictionary

Customize command 2nd

Cut Cells command

Cut command 2nd

cut-and-paste operation

     grouped worksheets

     paste icon