Microsoft Office Professional 2010 Step by Step eBook

(Ben Green) #1
Today button, 705
Toggle button, 632
Toggle Filter button, 852, 854, 857, 861
toggling filters, 852
Toolbar, Mini, 65, 312, 439, 440
character formatting with, 111
hiding, 18
toolbar, navigation, 509-510
Toolbar, Quick Access
buttons, adding, 31-32, 244, 251
buttons, positioning, 245
customizing, 5, 32, 521
exporting customizations, 245
improving efficiency with, 6
legacy commands, adding, 7
location, 244
moving, 5
overview of, 3
printing from, 34
removing buttons, 245
resetting, 32-34, 245
specifying for active document, 33
tools, data entry
AutoComplete, 257
AutoFill, 256
AutoFill Options button, 258, 260
FillSeries, 256
overview, 255
Pick From Drop-Down List, 257, 259
tools, formatting. See formatting
tools, research, 270. See also Research task pane
Top 10 AutoFilter dialog box (Excel), 349, 352
Top 10 filter, 349
total rows in tables, 161, 276
totals, viewing with AutoCalculate, 355, 359
tracer arrows, 301-302, 304, 306
hiding, 302, 305-306
tracing dependents to identify errors, 302
tracing precedents to identify errors, 301, 304
transitions
adding to presentations, 479, 483
animating, 481
dynamic content, 480
exciting, 479
removing animation, 481
sounds, adding, 482
subtle, 479
timing, 483
viewing, 482
Translate button (PowerPoint), 417
Translate button (Word), 82, 86
translating text, 271, 273, 417
entire documents, 84
in Excel, 271

in OneNote, 520
options for, 86
in Word, 82, 86
Translation Language Options dialog box
(Word), 84
transparencies, 486
transparent graphics, 920
transposing data in paste operations, 263
troubleshooting formulas, 286
Troubleshooting paragraphs, xx
troubleshooting People Pane, 633
Trust Center (Access), 759
Trust Center dialog box (Word), 25
Trust Center (Word), 24-25
trusted locations, setting, 25, 758-759
turning effect in slide transitions, 479
two monitors, 508
typos. See spelling, checking

U
Underline button (Word), 113
underlining text, 113, 439
undo actions, changing default number of, 403
Undo button, 5, 68, 70, 270, 353, 402, 404, 750
undocking OneNote, 533
undoing editing
keyboard shortcut for, 67, 402
procedure for, 68, 70, 270, 402, 837
undoing table data, 798
Unfiled Notes section (OneNote), 528
unfreezing fields, 807
Ungroup button (Publisher), 962
ungrouping publication objects, 962
ungrouping shapes, 478
Unhide Columns dialog box, 807
Unhide dialog box (Excel), 234, 236
unhiding fields, 806
unhiding rows/columns, 238
unique identifiers, 823. See also primary keys
unique values
displaying, 358, 359
and headers, 359, 360
units of measurement, 905
unread messages, 619
updating charts automatically, 468
updating meetings, 697
updating pictures automatically, 449
updating task status, 726
uppercase. See case
user-defined fields, 666
user input in exercises, xx

user input in exercises 1027

Free download pdf