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

758 Excel 2013 All-In-One For Dummies
graphics (continued) overview, 545 screenshots, 571–572 slicers, 641, 683–685 SmartArt, inserting,
568–571
text boxes, adding, 562–566 themes for, 573
WordArt, inserting, 567–568
graphics effects
for chart titles, 537–538 for charts, 530
for text boxes, 564 themes, 573
GRG (Generalized Reduced Gradient) Nonlinear method, 662, 665
gridlines
on charts, 517
default settings for, 58–59 positioning graphics with,
547–548 printing, 285 removing, 165
Group button, 244–245 group editing in
workbooks, 253 Group option, 531
Group or Ungroup dialog
box, 245
grouping graphics, 551–552 groups, Ribbon, 21, 62, 63
H
handwritten signatures, 465 Header & Footer Tools
contextual tab, 286, 288 headers
for alternating even and odd pages, 292
creating custom, 288–290 first-page, creating unique,
290–291
general discussion, 285–286
stock, selecting, 286–288 heights of rows, 138–139 Help on This Function link,
Insert Function dialog
box, 310
Help window, 34–35, 354 Hidden protection format,
440, 441–442
hidden rows and columns,
adding to charts, 528 hiding
comments, 484 graphics, 553
outline levels, 241–244 rows, 139
tabs on Ribbon, 62 worksheets in
workbooks, 254 Highlight Cells Rules
option, 174, 176–177 Highlight Changes dialog
box, 476–478 highlighted changes,
accepting or rejecting,
481–482 highlighting duplicate
values in cell ranges,
179–180 HLOOKUP function,
410–413
Home tab, Ribbon, 23, 144 Horizontal Axis Crosses
option for chart
axes, 539
horizontal axis, formatting
options, 540 horizontal scroll bar, 31 horizontal text alignment
options, 157–158 Horizontal window
arrangements, 257
hot keys
for custom tabs on
Ribbon, 65
from Lotus 1-2-3, using
with Excel, 61
for Ribbon commands, 25 for selections in pivot
tables, 680
HOUR function, 374 .htm file format, 119 .html file format, 119 HTML files, 119, 508,
510–512
HYPERLINK function, 417,
461, 462 hyperlinks
adding, 456–459
clearing, 194
editing, 460–461
following, 459
general discussion, 455–456 HYPERLINK function,
461, 462
overview, 455
for screenshots, 56 sending workbooks as, 494 sharing workbooks on
SkyDrive with, 492–493 UNC addresses, 462
URL addresses, 462
I
Icon Sets option, 174, 175 icons, Open dialog box, 186 icons, used in book, 8–9
IF function, 307, 341, 342,
343–345
IFERROR function, 341 IFNA function, 341 Ignore buttons, Spelling
dialog box, 222