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

Index 769
graphics, 546
templates, 76–77 Selection Pane option, 531 Selection task pane,
managing graphics in,
552–554
selections, cell. See cell
selections
Send Backward option, 531,
549, 550
Send to Back option, 550 Sensitivity reports, 665–666 separators, adding to Quick
Access toolbar, 43 serial numbers
for dates, 361, 365, 366–367
for times, 361, 373–374 Series dialog box, 104 series formula, 516 servers, saving files on, 54 set cells, 658
Set Hyperlink ScreenTip dialog box, 457
Set Precision as Displayed option, 59
Settings dialog box, 239, 240, 241
Shape Effects option, 530, 564
Shape Fill option, 529, 564 Shape Height option, 532 Shape Outline option,
529, 564
Shape Styles gallery, 529,
564, 566
Shape Width option, 532 shapes, inserting, 554 Shapes gallery, 561–562 shaping handles on
graphics, 546, 547 Share command, File
menu, 20
Share screen
IM, sending workbooks
by, 494–495 inviting others to
view workbooks on
SkyDrive, 490–493 presenting workbooks
online, 495–496 Share Workbook dialog
box, 472–475, 480, 482 SharePoint Services
software, 54 SharePoint Team website,
opening workbooks
saved on, 185 Sharing links, creating,
492–493 sharing workbooks
advanced options, 474–475 change tracking, turning
on, 475–479 comments, 483–486
data sharing techniques,
499–501
editing online, 496–499 with e-mail, 494 exporting to other file
formats, 507–512 file sharing, turning on,
472–473
general discussion,
470–472
with IM, 494–495 marking up with digital
ink, 486–488 merging changes from
different users, 479–482 overview, 489
with PowerPoint 2013,
506–507
presenting online, 495–496 removing users from
shared workbooks, 483
reviewing online, 499 security, 453–454
on SkyDrive, 490–493 stopping sharing, 482–483 with Word, 501–506
Sheet Background dialog box, 250, 278
Sheet Name button, 289 Sheet Options group
options, 285 Shift keys, Touch keyboard, 95
Short Date format, 362–363 shortcut keys
for formatting, 147
for macros, 711, 712
for Ribbon commands, 25
Show All Properties link, Info screen, 19
Show Formulas option, 348 Show Margins check box,
Print screen, 280 Show Mini Toolbar on
Selection check box, 46 Show Quick Analysis
Options on Selection
check box, 46 Show the Start Screen
When This Application
Starts option, 48 Show Trial Solution dialog
box, 662
Shrink to Fit option, 158 shutting down Excel, 39 Sign dialog box, 467–469 Signature Setup dialog
box, 467 signatures, digital, 18,
465–470, 716–718 Single File Web Page file
format, 119 Size button, 277
sizing handles on graphics, 546, 547