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

768 Excel 2013 All-In-One For Dummies
Ribbon (continued) keyboard, selecting
commands with, 24–25 minimizing, 22
mouse, selecting
commands with, 24–25 overview, 16
restoring defaults, 63 tables, formatting from,
139–142 tabs, 23–24 touch, selecting
commands by, 25 right alignment, 158, 286 Right arrow, Touch
keyboard, 95 Rotate option, 531 Rotate Text Down/Up
orientation options, 161 rotation handles on
graphics, 546, 547 ROUND function, 390–392 ROUNDDOWN function,
390–392
rounding off numbers,
functions for, 390–394 ROUNDUP function,
390–391
Row fields, filtering, 682 ROW function, 417, 418 Row Headers option, 677 Row Height dialog box,
138, 139 rows
in charts, switching with columns, 525
deleting, 232–233 formatting, 133, 138–139 Freeze Panes feature,
201–204 hidden, adding to
charts, 528 hiding, 139
inserting, 232, 233–234
range names, creating from headings, 328–329
selecting all cells in, 128 setting as print titles, 282 Table Style options for, 142 Transpose option, 214–215
ROWS function, 417–418 RTD function, 417
ruler, 58, 273
rules for Conditional
Formatting feature, 180–182
S
Save As dialog box, 117–118, 187, 434, 508
Save As screen, 53, 116, 117 Save button, Quick Access
toolbar, 26, 116
Save Chart Template dialog
box, 541
Save dialog box, default
settings for, 53 Save tab, Excel Options
dialog box, 52–54 Save Workspace dialog
box, 261 saving
charts as templates, 541–542
custom themes, 573 default file location,
changing, 120–121 Document Recovery
feature, 122–123 general discussion,
116–118
in other file formats,
119–120
with passwords, 434–436 in PDF format, 508–509 UDFs in add-in files,
741–744
workspaces, 260–262 .xls files, 121–122 in XPS format, 509
Scale to Fit group options, 284–285
scanned images, inserting, 557–558
scatter charts, inserting, 520 Scenario Manager, 652,
654–655, 656, 660 Scenario Summary dialog
box, 656
Scenario Values dialog
box, 653–654
scenarios, 645, 652–657 Screen Clipping option, 572 screen magnification, 56 screenshots, 56, 554, 571–572 ScreenTips, 46, 457, 459 scroll bars, navigating
Worksheet area
with, 31–32 Scroll Lock key, 31 scrolling
in split panes, 235–236 tab scrolling buttons,
247–248
Search Documents text box,
Open dialog box, 189 searching for functions,
Insert Function dialog
box, 310
SECOND function, 374 security. See protecting
data
Select Changes to Accept or
Reject dialog box, 481 Select Data option, 524, 526 Select Data Source dialog
box, 526–528 selecting. See also cell
selections
AutoFit feature for, 136 by cell range names, 134