Page 782 - Excel 2013 All-in-One For Dummies

764 Excel 2013 All-In-One For Dummies
orientation
Format Cells dialog box,
setting with, 161 overview, 159
Ribbon, setting with, 145,
160–161
setting for printing,
270, 281
of text boxes, 563 TRANSPOSE function,
changing with, 418–419 Orientation button, 277 outline color, 529, 564 Outline feature
creating outlines, 238–240 custom views, creating,
246–247 displaying and hiding
outline levels, 241–244 manually adjusting outline
levels, 244–246 overview, 237–238 removing outlines, 246–247 styles, applying, 240–241
P
Page Break Preview feature, 34, 292–294
page breaks, 58, 292–294, 599
page layout
margins, 278–280 orientation, 281
overview, 277
Page Setup group options,
277–278
Print Area, setting and
clearing, 278
print titles, 282–284
Scale to Fit group options,
284–285
Sheet Options group
options, 285
Page Layout tab, Ribbon, 23 Page Layout view, 13, 34,
272–273
Page Number button, 288 page numbers, in headers
and footers, 288, 291 Page Setup dialog box
chart options, 544
margin settings, 279–280 Print Area settings, 278 print title settings, 282–283 removing cell errors
before printing, 360 Page Setup group options,
277–278
panes, splitting worksheets
into, 234–237
paper size, 270, 277 parsing text files, 628–631 passwords
changes, entering to make, 438–439
changing, 439–440 deleting, 439–440 entering, 437–438
Info screen, setting from,
436–437
overview, 433–434 setting when saving files,
434–436
to unprotect worksheets,
setting, 444
Paste Link option, Paste
Special dialog box, 214 Paste option buttons, Paste
Special dialog box, 213 Paste Options palette, 210 Paste Special dialog box,
212–216, 505
Paste Values section, Paste
Options palette, 210 pasting options, 209–211 patterns, 167–168
Payment (PMT) function, 379–382
PDF (Portable Document File) format, 120, 494, 508–509
Pen and Touch dialog box, 32
pen options, 486
percent sign (%), 89, 153 Percent style, 147, 170 periods (.), 89, 100 Permissions dialog box,
447–448
Personal Macro Workbook,
710, 724, 726
personal settings, saving, 475 personal templates folder, 80 personalization settings
for Office, 47
Picture button, 289 Picture Styles group, 560 pictures
downloading from Web, 556–557
editing, 558 formatting, 559–560 inserting, 554, 556–557
pie charts, inserting, 520 pinning Excel, in Windows,
38–39 pivot charts
creating from pivot tables, 693
filtering, 694–695 formatting, 695 importing Access data
to, 624
moving to separate
sheets, 693–694 pivot tables. See also
PowerPivot add-in creating manually, 672–676 with data from external
queries, 641