Datasheet

384
Excel 2010 For Dummies
Paste Link button (Paste Special dialog
box), 167
Paste Link (N) option (Paste Options
palette), 163
Paste Options palette, 162–164
Paste (P) option (Paste Options palette), 163
Paste Special dialog box, 165–167
pattern
adding  ll color to, 136
changing, 136
removing, 137
selection, 136
PDF (Portable Document File), 91–92, 359
Percent format, 117
Percent Style button, 111
Percent Style format, 117
percentage
converting decimal to, 117
entering in cell, 117
growth rate, 258
interest rate of, 117
number format, 57
style, 117
zoom, 202–204
period (.), 56
Phone Number number format, 121
picture
artistic effect, 306
background, 305
color, 306
compression, 306
correction, 306
editing, 305
importing, 304–305
resetting, 306
style, 307
Picture button, 192
Picture (U) option (Paste Options palette),
163
pivot chart
 ltering, 281–282
formatting, 282
moving, 280–281
summary value, 280
pivot table
adding  eld to, 278
blank grid, 268–269
column, 270, 274–275
creating, 268–271
data source indication, 269
editing, 277–280
external table data, 268
 lter buttons, 272–273, 275–276
 ltering column and row  eld, 274
 ltering the report, 273–274
formatting, 271–273
formatting values in, 272–273
grand total, 271
hiding, 271
layout, 271
moving  eld in, 277
preview, 272
redisplaying, 271
removing  eld from, 277
report  lter, 269
row, 270, 274–275
slicer, 275–276
sorting, 275–276
style, 271–272
subtotal, 271
summary function, 278–279
uses for, 267
value, 270
what to include in, 268
year  eld, 269
PM designation, 60
point-and-click cell selection, 99–102
pointing, 64–65
Portable Document File (PDF), 91–92, 359
Portrait orientation, 180, 182, 184
positive numeric value, 56
power failure, 92–93
preview
chart, 290
comment, 211–212
pivot table, 272
Preview button (Find and Replace dialog
box), 219
Previous Page button (Print panel), 178
Previous tab scroll button, 231
Print Area button (Page Setup group), 182
Print panel, 177–180
Print Preview command (Customize Quick
Access Toolbar), 19
25_489536-bindex.indd 38425_489536-bindex.indd 384 3/23/10 7:56 PM3/23/10 7:56 PM