Datasheet

385385
Index
Print Preview feature, 178
print title
deleting, 187
report header versus, 185
row/column designation as, 186
Print Titles button (Page Setup group), 182
printer, 179
printing
chart, 317
comment, 213
current worksheet only, 180–181
ease of, 175–176
formula, 198
help topic, 32
Page Layout View, 176–177
Page Setup group, 181–187
Print Area feature, 180
from Print panel, 177–180
Quick Print button, 180–181
Scale to Fit feature, 188
Sheet Options group, 188–189
Product function, 279
Protect Shared Workbook dialog box, 227
Protect Sheet dialog box
description of, 224
leaving cells unlocked, 226
opening, 225
password protection, 225–226, 372
removing protection, 229
worksheet layout protection, 225–226
Protection tab (Format Cells dialog box), 113
pull-page view (Print panel), 178
• Q •
query
Access database table, 340–342
external data, 340
Web page, 342–344
question mark (?), 66, 219
Quick Access toolbar
adding button to, 19, 43–46
adding Form button to, 321–322
adding non-Ribbon command to, 21
adding Ribbon command to, 20
assigning macro to, 357
basic description of, 12
customizing, 18–21
grouping button on, 21
location of, 6, 18
moving button on, 20
Quick Access Toolbar button, 18–19
Redo button, 18
removing button from, 19, 21
running macro from, 21, 48
Save button, 18, 87
Undo button, 18
Quick Access Toolbar button, 18–19
Quick Launch toolbar, 31
Quick Print button, 180–181
Quick Print command (Customize Quick
Access Toolbar), 19
• R •
range of cells, 79
read-only, 151
Ready mode, 51–52
Recent command (File menu), 149
Record Macro button, 351
recording macro, 351
recovery. See AutoRecover feature
Redo button
Customize Quick Access Toolbar, 19
Goal Seek dialog box, 261
Quick Access toolbar, 18
Redo feature, 152
#REF! error value, 67
re ection effect, 295
relative cell reference, 158
Repair button, 152
replace. See Find and Replace dialog box
replacement entry, 69
report
 ltering, 273–274
summary, 265–266
Research task pane, 222, 2234
Review tab, 16
Ribbon interface
about this book, 3
assigning macro to, 356–357
basic description of, 13–14
command, adding to Quick Access
toolbar, 20
command button, 15
command shortcut, 5
25_489536-bindex.indd 38525_489536-bindex.indd 385 3/23/10 7:56 PM3/23/10 7:56 PM