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
further readings, 661
plotting, 564, 565
triangulation precision, 551
TRIM function, 503, 504, 987
TRIMMEAN function, 987
troubleshooting. See also backing up data; recovering data
##### display, 140, 458, 531
bin formulas, 572
bitmap images, 885
boundaries on embedded items, 882
broken links, 889
calculated items, 737
changed cell names, 445
circular references, 464–466
compatibility error messages, 55
Compatibility mode and tables, 670
custom functions, 859–869
dates and serial numbers, 507
decimal point alignment, 314
dependent workbooks, 474–475
Design tab disappearing, 271
#DIV/0! errors, 438, 587, 682, 696
downloading diagnostic files, 109
extracting rows with filters, 689
finding commands and options in Excel 2007, 907–925
fixed-width text imports, 752–753
formulas, 140, 201, 438
hours, numbers of, 530
hyperlinks, 876
inserted cells not in formulas, 435
integers, 606
IS functions, 511
iterative calculations, 466
linking to cell ranges, 897
macros, 833, 859–869
merging scenarios, 594
#N/A error, 438, 581, 682
#NAME? errors, 438, 444, 490, 494, 682, 854
#NULL! errors, 438, 682
#NUM! errors, 438, 467, 540, 545, 682
older files with natural language formulas, 456
overlapping chart labels, 647
page breaks, 421
pasted tables in Word, 893
PivotTable Field List window, 720
PMT function, 539
printed text overflowing columns, 335
Query filtering, 762
random numbers, 575
#REF! error, 438, 682
relative references in macros, 832
rounded values, 467, 501
rounding functions, 501
selecting chart elements, 634
shared workbooks, 792
Solver problems, 611
space characters in conditional sum formulas, 483
system diagnostics, 109
table formatting, 706
trapping errors, 867–869
two-variable data tables, 587
#VALUE! errors, 438, 682, 851, 854
Web site hyperlinks, 874
workbooks not opening, 176
XML files, 756
TRUE function, 491, 987
TRUE value
as arguments, 492
conditional test formulas, 478
in debugging, 865
logical functions and, 508
sorting and, 682
TRUNC function, 502, 987
Trust Center. See also protecting workbooks; protecting worksheets; security
ActiveX settings, 106–107
add-ins, 106–107
Customer Experience project, 109–110
default settings, 103
defined, 103
downloading files, 109
dynamic links to Office Online Web site, 109
external content, 107–108
macro settings, 106–107, 828–830
Message Bar, 107
online Help, 109
overview, 103–105
privacy options, 108–110
reputable developers, 103
security alerts, 104
spoofed Web site detection, 110
suspicious documents, 110
system diagnostics, 109
trusted locations, 105, 816
trusted publishers, 105
Update Featured Links... option, 109
trusted locations, 105, 816
trusted publishers, 105
TTEST function, 987
turning features on or off
AutoComplete feature, 210
automatic recalculation, 463
automatic styles, 255
direct manipulation, 455
drag-and-drop, 209
editing in workbooks, 158–159, 208
fill handles, 209
folders for macro-enabled files, 829
Function ScreenTips, 490
Live Preview feature, 95
macro execution, 827–830
mouse zoom, 210
online connections, 75
percentage formatting, 210
sharing, 797, 798
Track Changes feature, 791
two-dimensional arrays, 470
two-variable data tables, 586–587
TXT (text) file formats, 71, 72
TYPE function, 510, 987
Type Mismatch errors, 868
type styles. See fonts
typing. See also data entry
automatic correction, 227–230
keyboard shortcuts, 937–938