L

L input mask character, 870

label controls

adjusting fonts for report, 1031

editing report, 1047–1049

setting up column labels, 1032–1033

labels

configuring comment balloon, 315

constants and, 352

language settings for Word, 221

Large Mail folder, 676, 677

Last Custom Settings (Margins gallery), 209

Launchbar (Groove)

about, 85, 135–137

Contacts area of, 189–190

sending message to contact with, 137–138

setting up file-sharing workspace from, 169–170

Layout view

building reports, 1052–1071

adding grouping and sorting, 1054–1058

adding totals to records, 1066–1069

applying AutoFormats, 1069–1071

previewing reports, 1070

starting with blank report, 1052–1054

usefulness of, 1059

working with control layouts, 1059–1066

modifying Report Wizard reports in, 1045, 1046–1052

opening Form window in, 973–974

usefulness of building reports in, 1059

layouts

Access control, 1059

customizing PowerPoint, 540–541

fixed, 530

fundamentals of document, 256–257

list of options in Word, 275

PivotTable report, 496

selecting Report Wizard report, 1043–1044

SmartArt options for, 568

standard PowerPoint, 540

LDAP (Lightweight Directory Access Protocol), 656

LEFT function, 470

legal blacklines, 334–336

LEN function, 467

less than (<)

input mask character, 871

operator, 444, 869

less than or equal to (<=) operator, 444, 869

libraries.

See also document libraries;

Slide Library

adding content to, 83

Excel data connection, 6

MSDN Library, 1115, 1141

SharePoint

about, 80–81

accessing content in, 81–82

connecting with Outlook, 750–751

downloading files from, 751–752

uploading files to document, 730

viewing editable list of, 82

Lightweight Directory Access Protocol (LDAP), 656

Like comparison operator for queries, 916–917

LIKE operator, 869

line breaks

adding to formulas, 420

creating in VBA message boxes, 1133

Line Labels, 1125

line numbering, 231–233

Line Numbers dialog box, 232, 233

line spacing

report, 1034

text box, 548

line styles for borders, 281–282

line width of partial borders, 284

lines

adding blank, 289

breaking

in formulas, 420

in VBA message boxes, 1133

customizing appearance of changed, 329–330

horizontal, 292–294

numbering, 231–233

spacing

report, 1034

text box, 548

styles for borders, 281–282

thickness of form control border, 993

width of partial borders, 284

Link Child Fields property, 878, 880

Link Master Fields property, 878, 880

Link To pane (Edit Hyperlink dialog box), 954–955

linked media, defined, 605

linked text boxes.

See also floating frames

breaking links, 273

copying or moving, 272–273

creating links between text boxes, 270–271

deleting without losing text, 273–274

linking when Text Box Tool tab missing, 274

linking.

See also linked text boxes

action items in Meeting and Calendar tools, 157

movies to presentations, 574

tables, 881

workbooks, 439–443

copying, cutting, and pasting data, 442–443

editing external links, 441–442

opening dependent workbooks, 440–441

saving linked workbooks, 439–440

links

adding to notebooks, 98

creating to Groove note pages, 162

embedding file reference in notebook, 108

sending other users shared notebook, 124

list boxes

creating control for, 979

using, 1011–1012

lists

Auto Lists, 1090–1091, 1093–1094, 1099–1100

completing variables from, 1093–1094

selecting constants from, 1099–1100

using, 1090–1091

bulleted

converting to SmartArt graphics, 553–556

working with text box, 548

Daily Task List, 634

field, 974, 983–984

shared from SharePoint sites, 726

undoing actions in, 363

viewing using query in Excel, 82

Live Preview

about, 9–10, 25

galleries support of, 39, 40

Live Sharing Sessions

creating, 89

initiating, 127–130

password-protected sections not accessible in, 128

locked notebook sections, 125–126

Locked text box property, 994–995

locking

cells, 373

control buttons, 983

entries in cells, 352

logical functions, 471–474

about, 471

AND, OR, and NOT, 472–473

IF, 472

nested IF functions, 473

SUMIF, 472

logical operators in conditional test formulas, 444

logical values

about, 352

arguments for, 458

Lookup & Reference button, 476

LOOKUP function

arguments for, 476–477

vector and array form of, 476–477, 479–480

Lookup properties, 909, 937

lookup and reference functions, 476–484

about, 476–477

ADDRESS, 480

AREAS, 484

arguments for LOOKUP, 476–477

CHOOSE, 480

creating automatic lookup formulas, 476

INDEX, 481–483

INDIRECT, 483

LOOKUP, 476–477, 479–480

MATCH, 480–481

ROW and COLUMN, 483

ROWS and COLUMNS, 484

TRANSPOSE, 484

VLOOKUP and HLOOKUP, 477–479

Lookup Wizard

about, 857, 858

conditional test formulas for, 444–445

formulas created with INDEX and MATCH functions, 449–451

loops, 1106–1111

deleting objects from Word with, 1110

Do, 1107–1110

For…Next loops, 1106–1107, 1108–1110

For Each…Next, 1106–1107

nesting multiple, 1110

variable counters in, 1091, 1092

LOWER function, 466, 469