Paste Special dialog.................................................................................................................19
Paste Special options...............................................................................................................19
Paste Only options....................................................................................................................20
Insert cell fields..............................................................................................................................20
Formatting data..................................................................................................................21
Multiple lines of text.......................................................................................................................21
Automatic wrapping..................................................................................................................21
Manual line breaks....................................................................................................................22
Shrinking text to fit a cell................................................................................................................22
Formatting numbers.......................................................................................................................22
Formatting fonts.............................................................................................................................22
Font effects....................................................................................................................................23
Text direction..................................................................................................................................24
Formatting cell borders..................................................................................................................25
Formatting cell backgrounds.........................................................................................................27
AutoFormat of cells and sheets.......................................................................................27
Using AutoFormat..........................................................................................................................27
Defining a new AutoFormat...........................................................................................................27
Using themes......................................................................................................................28
Value highlighting..............................................................................................................29
Using conditional formatting............................................................................................29
Setting up conditional formatting...................................................................................................29
Types of conditional formatting......................................................................................................31
Condition...................................................................................................................................31
Color scale................................................................................................................................31
Data bars...................................................................................................................................31
Icon sets....................................................................................................................................31
Conditional formatting management.............................................................................................31
Copying cell styles.........................................................................................................................32
Conditional formatting example.....................................................................................................32
Defining conditions....................................................................................................................32
Generating number values.......................................................................................................32
Defining cell styles....................................................................................................................32
Calculating average..................................................................................................................33
Applying cell styles....................................................................................................................33
Hiding and showing data..................................................................................................33
Hiding data.....................................................................................................................................33
Sheets, rows, and columns.......................................................................................................33
Cells..........................................................................................................................................33
Showing data.................................................................................................................................34
Sheets, rows, and columns.......................................................................................................34
Cells..........................................................................................................................................34
Group and outline..........................................................................................................................35
Grouping....................................................................................................................................35
Hiding details.............................................................................................................................35
Showing details.........................................................................................................................35
Ungrouping................................................................................................................................36
4 Entering, Editing, and Formatting Data