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

772 Excel 2013 All-In-One For Dummies
Tips for Tablets topic, Excel Help window, 35
titles of charts editing, 534–535 formatting, 536–538 repositioning, 532
TODAY function, 364–365 Top 10 AutoFilter dialog
box, 607, 608–609 Top alignment option,
145, 158
Top/Bottom Rules option,
174, 176–177 Totals & Filters tab,
PivotTable Options
dialog box, 692 Totals feature on Quick
Analysis tool, 304–305,
318
Touch keyboards, data
entry with, 94–95 Touch/Mouse Mode button,
Quick Access toolbar,
16, 25, 26, 42 touchscreen devices
AutoFill feature on, 103–104 cell references in
formulas, inputting, 318 cell selection on, 129 column width, manually
adjusting with, 136 data entry on, 94–95 gestures supported by
Excel, 35
marking up with digital
ink, 486–488 mini-toolbar, displaying
on, 149
naming cell ranges, 134 Quick Access toolbar, 16 quitting Excel on, 39 range names, advantages
of, 324
removing panes on, 237
Ribbon Display Options, 16 row height, manually
adjusting with, 138 scrolling in worksheets, 32 selecting Ribbon
commands with, 25 SkyDrive app for Apple
devices, 499
Start Inking command, 483 zooming on, 199
Touchscreen icon, 9 Trace Dependents option,
347, 348, 352–353 Trace Precedents option, 347, 348, 349–352
tracking changes, 475–479, 481
training videos, 35 Translation option, 226 TRANSPOSE function, 417,
418–419
Transpose option, Paste
Special dialog box,
214–215
Trig functions. See Math &
Trig functions
TRUE function, 341 TRUNC function, 392–393 Trust Center dialog box,
717–718
Trusted Locations tab,
Trust Center dialog, 718 Twitter, posting SkyDrive
workbook links on, 493 two-digit years, 91, 355 two-dimensional arrays, 319 two-variable data tables,
649–651
two-way lookups, 413–417 TYPE function, 423
U
UDFs. See user-defined functions
unattached text, 517
UNC (Universal Naming Convention), 462
underline formatting, 145, 563
Undo command, 26, 60, 163, 191–193
Ungroup button, 244–245 ungrouping graphics, 552 Unhide dialog box, 254 unhiding Personal Macro
Workbook, 724, 726 union operator, 306 Unique Records Only
option, 613
Units option for chart
axes, 539 Universal Naming
Convention (UNC), 462 Universal Resource Locator
(URL), 456, 462 Unlink option, 642 Unlocked Cells Containing
Formulas check box, 356 Unprotect Sharing dialog
box, 454 Unprotect Sheet dialog
box, 445 unprotecting
shared workbooks, 454
worksheets, 444–445, 450 unsaved versions, options
for, 464–465
Update Changes option, 475 UPPER function, 425
URL (Universal Resource
Locator), 456, 462
U.S. calculation method, 368 Use GetPivotData Functions
for PivotTable References check box, 50
Use in Formula button, 327 Use Row and Column
Names check box, Apply Names dialog box, 331