Office X for Macintosh: The Missing Manual

702 office x for macintosh: the missing manual

floppy disk icon in Word status bar, 31

folders, 26

copying, 337

email messages, 336–337

HTML code organization, 304

saving email attachments, 342

fonts

changing in Excel, 489–490

color, Web pages, 283–284

email messages, 354

size in Entourage, 327

Word, 110–113

footnotes/endnotes, 197–201

foreign language dictionaries, 93

foreign language text, Spelling and Grammar

and, 89

form letters see also data merges

Format Cells dialog box, 487

Format Painter

Excel, 479–480

Word, 126

Format pop-up menu, 487

formatting see also character formatting;

paragraph formatting; section formatting

addresses, 403

automatically in Excel, 477

bullets in PowerPoint, 587–588

cell sizes in Excel, 481–482

chart transparency (Excel), 507–509

charts in Excel, 504–507

conditional in Excel, 480

data merges (Word), 261–262

dates in Calendar, 380

dates in Excel, 440

email messages, 333–334, 353–356

find and replace and, 79–80

Format Painter (Excel), 479–480

graphics, 650–655

manually in Excel, 480–486

master documents (Word), 224

numbers in Excel, 486–489

Reveal Formatting option (Word), 124

tables in Word, 171–178

text boxes (Word), 157–158

text in Excel, 486–491

text in PowerPoint, 585–586

text in Word, 109–140

troubleshooting in Excel, 441

worksheets, 477

Formatting Palette

Bullets and Numbering, 118

Carbonization and, 1

cell borders and color, 484–486

character formatting, Word, 110–113

Office 2001, 7

Word, 36, 37, 109–110

Formatting toolbar, 487

forms, creating data entry in Excel, 557–558

Formula Palette, 459, 532–533

formulas see also calculations; functions

auditing, 536

circular references, 533–534

compared to data, 437

compared to functions, 532

creating with Calculator, 458–459

Cut command in Excel, 447

iterations, 534

linking to other worksheets, 534–536

named ranges, 462–463

nested, 532

order of calculation, 459

overview, 453–454

syntactical order, 456

updating worksheet references, 535

viewing in Excel, 454

Forward Delete key, 71

forwarding email messages, 335

Fraction formatting (Format Cells dialog box),

488

freeform drawing, 645

function keys, 70

functions see also calculations; formulas

AutoSum, 455

compared to formulas, 532

finding, 456–457

iterations, 534

overview, 455

G

Gallery (clip art), 637

categories, 638

deleting clips, 638

online resources, 638

General formatting (Format Cells dialog box),

487

General properties in Excel, 531

GIF files, graphics, 288

global templates, Word, 204, 209–211

Go Back command (Word), 74

Go to, Open dialog box, 22

Go To command (Word), 72

Go to Today (Calendar), 377

goal seek feature (Excel), 547–548

grammar checking see also Spelling and

Grammar

Graph (Microsoft), 659, 668–670

graphics see also clip art; drawings; images;

multimedia; pictures

adding in Excel, 493–494

adding to PowerPoint, 588

floppy disk icon in

Word status bar