P

Page Border tab (Borders And Shading dialog box), 278, 279, 287–288, 292

page borders

adding, 223, 286–288

prints incorrectly, 292

suppressing on first page, 287

page breaks, 215–219

manual, 216

removing in outline, 251

unwanted, 219

Page Layout tab

about, 7

illustrated, 208

Page Number gallery, 223–224, 225

page numbers

report, 1035–1036, 1068

Word document, 223–224

Page Numbers dialog box, 1035, 1068

page orientation

selecting report, 1043–1044

Word document, 211

page setup.

See also Page Setup dialog box

options for Word documents, 208

planning document, 208

saving Word settings to template, 213–214

Page Setup dialog box

adding page or section borders, 223

aligning content vertically between margins, 222–223

illustrated, 213, 220

multiple page settings, 221–222

setting varying page options in, 219–221

Page Setup group (Design tab), 626

pages.

See also page setup

adding and editing Groove notepad, 160–161

borders

adding, 223, 286–288

prints incorrectly, 292

suppressing on first page, 287

breaks, 215–219

manual, 216

unwanted, 219

displaying drawing grid on, 230–231

notebook

adding and grouping, 99–100

adding hyperlink to notebook, 114

date and timestamp for, 101

opening and viewing, 94

numbering

report, 1035–1036, 1068

Word document, 223–224

OneNote templates for, 99–100

orientation

report, 1043–1044

Word document, 211

searching, linking, and printing Groove note, 162

setting up

multiple, 221–222

planning setup, 208

using Word options, 208

from Word template, 213–214

panes.

See also Group, Sort, And Total pane; Navigation Pane

Blank Database task, 847, 848, 895–899

Custom Animation task, 573, 576–578

freezing, 368–370

Link To, 954–955

Notebooks navigation, 92, 95–96

Notes, 588

Password Protection task, 125

Reading, 686, 687, 719, 723, 724

Reviewing, 307, 308, 314, 315, 326

Selection And Visibility, 564–565

simultaneous freezing and splitting of, 369

SmartArt text, 554, 555, 569

splitting worksheet windows into, 367–368

Synchronization Tasks task, 168, 171

visibility of frozen, 370

Workspace Members, 143, 145

paper size, 211–212

paper source, 212–213

paragraphs

accepting or rejecting edits by, 333

applying shading to, 298–300

borders applied to, 289, 290

formatting PowerPoint, 548

parentheses ()

added in functions automatically, 404

including in expressions, 926

negative constants in Excel, 354

placement of, 394

specifying values for VBA arguments in, 1098

surrounding function arguments with, 456

partial borders, 284, 285

Participant role, 173

Passport. See Microsoft Passport

Password Protection task pane, 125

passwords

applying to encrypted workbooks, 392

assigning to notebook section, 124–126, 128

case sensitivity of, 378

cell range, 375–378

document, 69–71

forgotten, 313

setting, changing, and removing, 70–71

weak, 69

protecting presentations with, 592–593

VBA macro, 1128

worksheet or workbook, 70, 378, 391–392

Paste button, 466

Paste command, 951

Paste Name dialog box, 416–417

pasting

comments into Notes pane, 588

data

in subdatasheets, 950–952

between workbooks, 443

parts of outlines, 249–250

paths

allowing trusted location remote or network, 607

displaying Outlook, 652

locating CRL, 713–714

pausing communications, 180

PDF file format, 530–532

pen device, 116

pencil icon, 946, 949

percentage sign (%), 355

performance of spelling proofing tool, 558–559

Permission dialog box

illustrated, 67

More Options button in, 67, 68

setting PowerPoint file permissions, 590–592

permissions

changing workspace member, 147

Groove role, 88, 147, 176

Manager, Participant, and Guest, 173

managing SharePoint workspace, 84

restricting

Outlook files, 721–723

PowerPoint files, 590–592

setting for folders in shared workspace, 176

specifying worksheet, 376–377

steps for restricting, 67–69

Permissions dialog box, 376

Permissions tab (Properties dialog box), 147

personal information

avoiding phishing schemes, 71–73

removing from files, 60, 61–65, 623

phishing

avoiding schemes for, 71–73

defined, 608–609

Outlook protection against, 637

Photo Album dialog box, 622

photo albums, 621–624

adding captions to pictures, 623

creating, 621–622

editing, 623

publishing to Web, 623–624

photographs. See pictures

PI function, 457

Picture Border tool, 295–296

Picture Styles group, 563–564

pictures

adding to Groove workspace, 162–163

adjusting, 563

borders for, 295–296

captions for photo album, 623

downloading

blocked, 686, 687, 688

to hard drive, 566, 622

editing placeholder logo file for, 1171–1172

Excel table copies only as, 603

filling SmartArt shape with, 570–571

inserting

before or behind text, 564–565

in presentations, 561–562

as watermark, 260

sharing picture libraries, 726

sizing presentation, 565–566

styles for, 563–564

Pictures tool, 162–163

PivotCharts, 516–518, 1003

PivotTable Field List window

about, 490

displaying, 494

illustrated, 491

pivoting data from, 493–494

PivotTables, 485–516

about, 485–489

ad hoc item groupings for, 512–513

calculated fields and items in, 508–512

changing numeric format of data, 496

creating, 489–493

custom calculations for, 506–508

data grouped by date or time ranges, 513–515

displaying

details behind calculations, 515–516

empty cells for, 497

fields

dragging in, 495

filtering, 502–505

rearranging, 493–495

sorting, 501–502

filtering categories on, 488–489

formatting, 497–498

hiding outline controls, 498

hiding Row Labels and Column Labels headings, 498

illustrated, 493

merging and centering field labels on, 497

quick create commands for, 1003

refreshing, 495

report layout options, 496

retaining sort specifications on update, 502

row and column axes for, 487–488

single-axis tables, 487

summary functions

applying multiple functions to field, 506

changing, 505–506

totals and subtotals for, 498–501

placeholders

custom slide layouts with, 540–541

SmartArt picture, 571–572

underscore and decimal as, 871

playing OneNote audio and video recordings, 111

plus (+) sign

addition operator, 393, 921, 923

concatenating strings with, 920

expanding outlines, 244

starting formula with, 353

subdatasheet and data expansion with, 941, 943–946

POP3 (Post Office Protocol 3)

about, 654

IMAP vs., 654–655

leaving messages on server with, 655

Popular category

Access Options dialog box, 829–830, 894–895

PowerPoint Options dialog box, 526

ports used by SMTP/POP3 protocol, 654

Post Office Protocol 3. See POP3 (Post Office Protocol 3)

postmarking e-mail, 637

.potx file format, 584

PowerPoint, 521–626.

See also PowerPoint Options dialog box; presentations; slides

adding text box to slide, 545–548

add-ins for playing video DVDs in, 605

animation in, 576–578

AutoRecover options for, 543

blocking/unblocking external content, 605

character spacing for, 547, 550

charts for, 579–582

checking for changes on Slide Library slides, 585–587

collaborating and sharing in, 583

command locations for, 521–523

compatibility with earlier PowerPoint versions, 530, 599–602

converting bulleted lists to graphics, 553–556

copying Access content with screen capture, 604

customizing, 523–527

Quick Access Toolbar, 524–525

slide layouts, 540–541

theme fonts, 550–551

digital signatures in, 14

Document Inspector for, 62–65

earlier features unsupported in 2007, 601

Excel 2007 tables in, 602–603

file formats, 527–532, 543

PDF and XPS, 530–532

types and extensions by version, 529

finding

errors opening ZIP package, 1162

and replacing text in, 548–549

headers and footers for slides, 556–558

Home tab commands on, 29–30

importing multimedia into, 605

improvements in, 13–14

macros written but not recorded in, 1077

Office 2003 diagrams with, 581

Open XML Format

folders required for, 1157

required files for, 1157

saving files in XML, 527–528, 543

using, 10–11

XML customization hidden on opening, 1182

XML prefix in, 1145

photo albums, 621–624

presentations

adding comments to, 587–588

editing and deleting comments, 589

flair in, 561

formatting, 532–533

inserting Access tables and objects, 603–604

marking as final, 594

opening in earlier versions, 529

password security for, 592–593

searching comments, 595

sound added to, 573–574

tables in, 537–539

WordArt in, 551–553

Presenter view in, 619–621

proofing tools in, 558–559

restricting permissions to content with IRM, 590–592

saving files

earlier PowerPoint version, 529

fast saves unavailable, 593

in XML, 527–528, 543

security alerts and trusted publishers for, 608–609

slide libraries, 542–543

SmartArt in, 567–573

templates for, 583–585

themes in, 14, 535–536

trusted locations for, 606–608

two Design tabs on Ribbon, 539

viewing ZIP packages in, 1150

views, 533–535

workflow with Office SharePoint Server, 14

working with pictures in, 561–566

PowerPoint Options dialog box, 531

Add-Ins category, 527

Advanced category, 526

customizing Quick Access Toolbar, 32–33

illustrated, 525

Popular category in, 526

Proofing category, 526

Save category, 526

Trust Center, 606

Trust Center category, 527

Use Contextual Spelling check box, 559

ppt folder, 1157

.pptx files

about, 528, 529

required folders for, 1157

Prepare command, 590

presentations.

See also slides

add-ins for playing video DVDs in, 605

animation in, 576–578

charts

creating in, 580

types available for, 579–580

clip art in, 566–567

comments

adding, 587–588

editing and deleting, 589

searching contents of, 595

copyrighting, 612

creating basic custom shows, 614–615

finding and replacing text in, 548–549

formatting, 532–533

headers and footers for, 556–558

inserting, spreadsheet in, 538

keeping viewers’ attention, 611

marking as final, 594

movies in, 574–576

password-protecting, 592–593

pictures

adjusting, 563

arranging before or behind text, 564–565

inserting in, 561–562

picture styles, 563–564

sizing, 565–566

unable to download directly, 566, 622

Presenter view for, 619–621

restricting permissions with IRM, 67–69

running in Office Groove 2007, 587

saving

before publishing to Slide Library, 542

in different PowerPoint versions, 600

screening hidden data in shared, 63, 594–597

securing when complete, 612–613

slide masters added to, 534–535

slides

adding from Slide Library, 586

developing templates for, 583–585

modifying printed, 626

transition, 617–619

writing on, 556

SmartArt in, 567–573

sound in, 573–574

tables

adding, 537, 603–604

copying from Word or Excel, 538

drawing in, 537–538

styles for, 539

Presenter view

enabling multiple-monitor support for, 620

features of, 619

using, 620–621

Preview, 25

previewing

e-mail attachments, 636

encrypted messages unavailable, 719

page background color, 258, 259

partial borders, 285

reports, 1036, 1045–1046, 1070

slide show materials, 624–625

table definitions before printing, 900

Primary Key button, 874–875

primary keys

automatically assigned, 851

defining, 874–875

setting up for linking tables, 882

table sorting by, 957

PrimerSamples.bas sample file, 1085

Print dialog box, 626

Print Layout view

comments illustrated in, 308

displaying document in Outline and, 247–248

solid line in margins space, 215

Print Preview command

going to Print dialog box from, 626

previewing slide show materials with, 624–625

Printed Watermark dialog box, 260, 262

printing

comments, 321–322

files to OneNote, 105–106

Groove note pages, 162

marked-up documents, 333–334

outlines, 239, 251

slides, handouts, notes, or outlines, 625

table definitions, 899–900

warning before printing tracked Word changes or comments, 60

privacy.

See also Trust Center

allowing downloading of diagnostic updates, 1199

avoiding phishing schemes, 71–73

Office statement of, 61

options in Access, 761–762, 780–781

PowerPoint Trust Center options for, 527

removing personal information from files, 60, 61–65, 623

setting options for, 58–60

Word-specific options for, 60

Privacy Options dialog box (Access), 761–762

private keys

digital certificates and, 690

exporting, 695, 696

procedures

starting, 1086–1087

VBA, 1082

viewing in Code window, 1083

PRODUCT function, 462

product key

entering, 1192

required for full use of Office, 1195

Project Explorer

about, 1083–1084

illustrated, 1083

toggling between UserForm and code in, 1139

Project Server, 17, 22

projects

folders found with, 1084

sharing macro, 1128

VBA, 1082

promoting headings, 238, 247

Proofing category

Access, 834

PowerPoint, 526

proofing PowerPoint presentations, 558–559

PROPER function, 466, 469

properties

adjusting line’s, 293–294

Allow Layout View, 999

Auto Expand, 1015

available for UserForms, 1135

Caption field, 910–911, 933–934

changing

Outlook shortcut, 666, 667–669

report, 1049–1050

creating query for Record Source, 986–988

Datasheet view for checking query field, 910

displaying form’s, 996–997

field Description, 856

label, 995–996

modifying text box, 994–995

object-oriented systems and, 970

read-only, 1090

setting

Access field, 861–865

form, 984–988

query’s field, 909–911

subdatasheet, 943–944

sorting lookup, 937

subdatasheet table, 878–881

VBA, 1087–1088, 1102–1103

working with contact’s, 187

Properties dialog box, 147

Properties window (VBE), 1084–1085

property sheet

displaying setting form properties, 996–997

opening or closing in Design view, 986

working with, 984–988

Protect Sheet dialog box, 373

Protect Structure And Windows dialog box, 375, 391

Protect Workbooks button, 390

protecting

workbooks, 374–375, 390–391

worksheets, 372–379

locking cells, 373

passwords for cell ranges, 375–378

preventing workbook changes, 374–375

unlocking individual cells, 373–374

protocols. See messaging protocols

.pst files, 650–651

public keys

digital certificates and, 690

obtaining and installing, 717

Publish Pages command, 130

Publisher, 16

publishing

digital certificates to GAL, 700

Groove forms, 202–203

notes and notebooks, 130

photo albums to Web, 623–624

schedules to Web sites, 645–646

slides to Slide Library, 542–543