labels. See also text; values
chart axes, 626–627, 642–643, 645, 648
chart data, 623–624, 652–653
chart dates, 645, 648–651
editing, 657
header rows in tables, 670
hiding in PivotTables, 724
hyperlinks, 875
moving on charts, 635, 647
overlapping in charts, 647
PivotTable data, 715
PivotTable fields, 723
rank-and-percentile analysis, 573
selecting in charts, 634
tables, 669
Lambda parameter, 578
landscape page layouts, 403
language settings, 755
LARGE function, 557, 970
largest numbers, 569
last cell, jumping to, 133
layers
of objects, 882
of shapes, 387–393
Layout tab commands and options, 914, 921, 925
layouts
charts, 619–620
PivotTable reports, 722
SmartArt, 360, 361
LCM function, 970
LEFT function, 506, 970
LEFTB function, 970
legends
charts, 619, 622–623
moving, 635
selecting, 634
Shape Styles feature, 630
text boxes, 352–353
LEN function, 503–504, 970
LENB function, 970
length of text, 503–504
less than operator (<), 458, 478
less than or equal to operator (< =), 478
level bars, 256
life of assets, 542
lighting effects, 380
limitations
arrays, 10
change tracking, 793
characters in functions, 491
customizing, 92
data size, 212
hours, 530
iterative calculations, 608, 611
merging workbooks time limits, 799
numeric values, 467
Solver add-in time limits, 608, 611
Limits report, 610
line breaks in formulas, 454
line charts, 635–637
line feeds, 458
Linear data series, 216
linear gradient fills, 376–377
linear optimization models, 608–609, 610
linear regression, 559–566
linear trend data series, 215
linear trendline charts, 660
lines
around embedded objects, 384
chart axes, 642
chart elements, 635–637
drawing, 348–351
drawing constrained objects, 348
formatting, 376–377, 635–637
Shape Styles feature, 630
LINEST function, 560–564, 566, 970. See also LOGEST function
lining up. See alignment
linking cells
to custom properties, 62
formulas for recovering data, 67
pasting links, 185
to text box contents, 353
linking objects
broken links, 889
captured images of worksheets, 395–397
compared to hyperlinks, 889
data from the Clipboard, 883–886
editing linked objects, 886
Excel tables in Word documents, 892–893
icons, 886
managing links, 888–889
multipage documents, 882
named ranges, 897
Object command and, 886–888
pasting data into Word, 896–897
pictures from other applications, 366
updating links, 889
vs. embedding, 881–882
linking workbooks
formulas, 473–477
to objects or other documents, 476
opening linked workbooks, 476
links. See hyperlinks
Links panel, 815
listing
linked objects, 888–889
names in worksheets, 450–451
PivotTable fields, 716
lists. See also tables
bulleted, 360, 361
filtering, 684–699
new and changed features, 17, 19
SmartArt graphics for, 358
literal characters in filters, 689
Live ID authentication, 803, 806
Live Messenger, 808, 811
Live Preview feature. See also previewing
chart formatting, 639
defined, 34, 36
enabling, 95
formatting changes, 375
LN function, 970
loading models in Solver add-in, 607
Loan Amortization.xlsm file, 238
Loan.xlsx file, 434
locations, trusted, 829
locking objects, 393–394. See also security
LOG function, 970
LOG10 function, 971
logarithmic scaling, 626, 645
LOGEST function, 566, 971
logging on to external servers or sources, 745, 760
logical functions, 507–510
logical operators, 507–510
logical values
A functions and, 556
as arguments, 492
data entry, 136
sorting and, 682
LOGINV function, 971
LOGNORMDIST function, 971
logos, 398–401
LOOKUP function, 515–516, 971
lookup functions, 512–520, 971
Lookup Wizard, 478–479, 483–485
Lookup.xlsx file, 514
lotteries, 500
Lotus 1-2-3 support, 17–18
LOWER function, 503, 505, 971
lowercase text, 503, 505, 683–684, 971