L

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