Office X for Macintosh: The Missing Manual

index 701

flag for follow up feature, 562

Format Painter, 479–480

Format pop-up menu, 487

formatting cell borders and color, 482–486

formatting charts, 504–507

formatting numbers, 486–489

formatting text, 486–491

formatting worksheets, 477

Formula Palette, 459, 532–533

formulas, 453–455

goal seek feature, 547–548

hiding cells, 482

importing data from text files, 542

importing data from Web sources, 541–542

inserting and removing cells, 448–449

keyboard shortcuts, 4

LIst Manager, 464–466

List menu, 474–475

List Wizard, 466–471

listsheets, 539

macros, 563–566

manipulating lists, 471–474

manual formatting, 480–486

merging cells, 491–492

merging workbooks, 527–528

named ranges, 462–463

nested formulas, 532

new features, 4–5

ODBC queries, 4

Office 2001 new features, 6–7

order of formula calculation, 459

outlines, 559–561

Paste Function dialog box, 456–457

Paste Special command, 448

printing worksheets, 512–518

protecting cells, 485

reports, 559

saving in earlier formats, 529

secnarios, 549–551

selecting cells, 445–446

selecting multiple worksheets, 520

sharing worksheets, 522–524

Solver, 551–552

spreadsheets, 435–437

spreadsheets in Word documents, 37

totaling numbers, 460–462

trend lines (charts), 510–512

validating data, 555

expanding compressed files, 343

expanding Word outlines, 213–214

exponential trend lines (Excel charts), 511

exporting

contacts (Address Book), 411

email messages, 337

Excel files, 529–531

FileMaker Pro data to Excel, 537–540

EXT in Word status bar, 30

Extend Selection mode (Word), 30

F

fast saves in Word, 42–43

favorites, 22

Favorites list, Internet Explorer, hyperlink

creation, 297–298

field codes in indexes, 249

editing, 250–252

Field dialog box (Word), 229

fields, Word, 228–233

AutoText, 101

data merges, 255

displaying, 232

documents and, 231–233

inserting, 228–229

locking, 232–233

modifying with switches, 229–230

printing, 233

Table of Contents, updating/deleting, 245

updating, 232

uses, 231

file extensions, viewing, 343

file formats, exporting Excel files, 529

file servers, Web file server, 304

FileMaker Pro

exporting data to Excel, 537–540

importing to Excel, 5

Service Release 1 and, 12

files

expanding compressed, 343

linking to, 295–296

Fill Color control (Formatting Palette), 484

fill colors, 651–652

fill effects, 652–653

fill handle (Excel), 444

Filter command (Excel Data menu), 555

filters see also message rules

creating for Excel lists, 472–473

find and replace see also searches

in Excel, 449–450

in Word, 75–82

Find and Replace dialog box, Go To command

and, 72

Find File button, Open dialog box, 21, 22

Find Related command, 426

Find window, 423

finding see searching

Fkeys, 70

flag for follow up feature (Excel), 562

flagging

contacts, 412

email messages, 338

flagging