T | MicrosoftВ® Office ExcelВ® 2007 Inside Out (Inside Out (Microsoft))

T function, 985

tab-delimited files, 751

Table of Contents in Help, 77

table styles

applying, 705

AutoFormat options, 874

creating, 707–709

overview, 668

themes and, 706–707

Table Tools tab commands and options, 911

tables. See also PivotTables

Access data and, 749–750

adding fields to, 767

adding or removing from queries, 766

autoexpansion, 667

banding, 271, 668, 708

chart data tables, 624

charts based on, 654

citing in formulas, 10

column specifiers, 455, 457

columns, 9, 10

converting back to cell ranges, 670

correlating, 575

creating, 669–673, 746–747

current row, 702–703

deleting rows, 272

duplicate data in, 668

expanding, 671–672

exporting to SharePoint sites, 818–820

external data and, 746–747

filling cells and, 460

filtering features, 10, 667, 684–699

formatting, 5–6, 269–275, 705–709

formula replication, 667, 672

formulas and, 699–705

handles, 672

headers, 10, 269–271, 670

HTML, 785

identifying, 670

inserting into Word, 897–899

inserting rows, 272

joining in Query, 767

LOOKUP function and, 515

maintaining formatting, 273

names, 455, 457, 671

new and changed features, 9, 10, 12–13, 667–668

number of rows and columns, 9

organizing, 669

overview, 667–668

PivotTables. See PivotTables

printing, 418

in Query window, 766

range names, 12–13

referencing, 701–705

removing formatting, 273

selecting data for charts, 616

selecting entire tables, 673

selecting in Query, 761

selecting rows or columns, 673

in shared workbooks, 792

sorting

case-sensitive text, 683–684

cells with formulas, 680–682

custom lists, 682–683

dates, 682–683

features, 667, 675–676

multiple-column sorting, 677–678

partial lists, 678–679

rows, 679–680

single-column sorting, 676–677

sources for mail merge, 902

special item specifiers, 455, 457, 458

structured references, 10, 454–461, 667, 701–705

styles. See table styles

summary rows, 270–271

table specifiers, 457

Table Tools Design tab, 271

themes and, 620, 706–707

total rows, 673–675

using in Word, 891–899

VLOOKUP and HLOOKUP functions, 512–515

tabs (characters), 458

tabs (Ribbon), 907–925

tabs (worksheets)

colored, 101

grouping worksheets, 237, 240

illustrated, 26

invisible, 153

maximum length, 148

rearranging, 149

scrolling, 27

selecting worksheets, 148

viewing, 28

Tabular PivotTable format, 722

tall pages, 403

TAN function, 985

TANH function, 985

targets

sensitivity of, 609–610

Solver add-in, 603–604

task panes, 18, 236, 945

taskbar, 29, 30

tasks, assigning and monitoring, 812–814

Tasks panel, 812–814

TBILLEQ function, 547, 985

TBILLPRICE function, 547, 986

TBILLYIELD function, 547, 986

TDIST function, 986

team members. See collaboration

Team Sales.xlsx file, 253

telephone calls, 808

telephone numbers, 306–307

templates

charts, 631–632

defined, 340

file format, 56–57

folder for, 49–50

installed, 47

installing, 48–49

location, 48–49

new and changed features, 7

personal, 46

sharing, 51

storing formats in, 340–341

tabs, 49–50

Templates folder, 49–51

testing. See also conditional test formulas

macros, 831–832, 843

VBA statements, 866

text. See also text boxes

in 3-D shapes, 381

alignment, 142

alt text tags, 391

in balloons, 355–356

case-sensitive, 683–684

in charts, 628–629, 641–642, 645, 648. See also labels; legends; titles

concatenating, 507

conditional formatting, 287

counting occurrences of, 507

in data labels, 653

file formats, 71–72, 750–755

filters, 688

fonts, 629

formatting, 306, 371–373, 382–384, 641–642

in formulas, 436–437

in graphics, 371–373, 382–384

in headers or footers, 408–412

hyperlinked, 873–875

labels for hyperlinks, 875

length of, 503–504

number formatting, 306

numeric, 436

pasting tables into Word as, 892, 894, 895

recognizing and extending dates, 525

replacing, 506–507

resizing, 383

saving queries as plain text, 783

in shapes, 353, 384, 387

size, 629

in SmartArt, 359–360

sorting and, 682, 683–684

strings, 505–507, 517

text functions, 502–507

Text Import Wizard, 750–755

text panes, 360

TXT file format, 71, 72

values. See text values

WordArt, 356–358

wrapping, 141

text boxes

in charts, 628–629

creating, 352–353

in dialog boxes, 935

formatting, 382–384

in graphics, 382–384

keyboard shortcuts, 935

text files, 71, 72, 750–755

text filters, 688

TEXT function, 491, 503, 986

Text Import Wizard, 750–755

text panes, 360

text strings, 505–507, 517

text values

as arguments, 491

filtering, 689

functions and, 559

A functions and, 556

in imported text files, 753

PivotTable field assignments and, 717

Sampling tool and, 580

sorting and, 682

textures, 377, 640–641

themed cell styles, 279

themes

applying, 275

caution, 27

cell styles, 278

chart styles, 620

custom, 277–278

formatting with, 275–278

new and changed features, 6

pasting, 185, 187

Shape Styles feature, 630

table styles, 706–707

WordArt, 630

Thesaurus button, 234–236

[#ThisRow] specifier, 458

three-dimensional arrays, 470

three-dimensional cell references, 448–449

three-dimensional charts, 651–652

three-dimensional formulas, 453–454

three-dimensional graphic effects, 378–381

three-dimensional rotation, 370, 371

threshold values in conditional formatting, 284–285

thumbnail images of clip art, 363

tick-mark labels, 635, 643

tick marks

chart axes, 628

on depth axes, 651

gridlines and, 646

moving labels, 635

repositioning, 642–643, 644

rescaling, 649

tilde (~), 225, 689

tiling pictures, 640, 641

TIME function, 986

time limits

change tracking functions, 793

for merging workbooks, 799

for Solver add-in calculations, 608, 611

times

##### error display, 531

as chart base units, 649

current, 531–532

customizing formats, 527–530

default, 522

elapsed time display, 526, 528–529

entering, 522–526

entering with macros, 833

formatting, 526–530

in formulas and functions, 530–534

grouping items by, 738–741

in headers or footers, 410

keyboard shortcuts, 938

overview, 521–522

time-scaled axes, 645, 648–651

TIMEVALUE function, 533, 986

TINV function, 986

title bar on workbooks, 26

titles

chart axes, 626–627

charts, 619, 621–622, 635

rank-and-percentile analysis, 573

Shape Styles feature, 630, 631

tables, 279

TODAY function, 531–532, 986

tolerance settings, 608

toolbars. See also Quick Access Toolbar; Ribbon

attaching to workbooks, 92–94

disappearing, 94

finding options in Excel 2007, 907–925

hyperlinks and, 879

Mini toolbar, 42, 95

new and changed features, 38–39

tools, finding in Excel 2007, 907–925

Tools menu commands and options, 916–917

top alignment, 320

top n items, filtering, 686

top or bottom rules in conditional formatting, 285, 287

total rows

adding to tables, 672, 673–675

customized styles, 708

formatting, 706

referencing, 704

totals

automatic, 45

grand, 724–725

PivotTables, 724–727

Query, 764, 775

running, 733

[#Totals] specifier, 458

#Totals tag, 704

tracer arrows, 248, 465

tracing

cell references, 245–246

dependents, 247–248

errors, 249–250

precedents, 248–249

references to other worksheets, 250–251

Track Changes feature, 794–797, 916

tracking changes

advanced options, 793–794

locking on, 796

reviewing changes, 797

to scenarios, 589, 593

turning on or off, 791

Transactions.xlsx file, 738

translating text, 234–236

transparency

chart backgrounds, 637–638

embedded objects, 882

lines in charts, 636

TRANSPOSE function, 520, 987

transposing cells, 190

trapping errors, 867–869

Treasury bills, 547

Treeorders.xlsm file, 847

Trend feature, 216

TREND function, 564, 565, 987

trendlines

in charts, 660–661

formatting, 635–637