H

h notation (hours), 528, 529

hand cursor, 879

handles

fill handles on data series, 209, 211–213, 215

grouped objects, 386

on shapes, 347, 348, 350–352

on tables, 672

vertices, 351–352

WordArt shapes, 356

hard drive space requirements for files, 53

hard-to-read formulas, 454

hardware

dual processor support, 10

hard drive space requirements, 53

recalculation and, 463

HARMEAN function, 964

header rows

creating styles for, 708

eliminating in imported data, 751

filters in, 684

formatting, 706

printing, 414–415

referencing, 704

sorting and, 676–677

special item specifiers, 458

in tables, 670

headers

default styles, 409

margins and, 407

in Page Layout view, 406

setting up for pages, 408–412

[#Headers] specifier, 458

#Headers tag, 704

headings in text boxes, 352–353

Help

auditing, 242

automatic online connection, 75

contextual tool sets, 36–37

controlling connections, 109

function reference, 487, 488

Help dialog box, 74–79

history of, 76

keyboard shortcuts, 940–941

"more information" indicator, 73

new and changed features, 18

offline vs. online, 74–75

pop-up labels. See ScreenTips

product support for recovering data, 82

Visual Basic Editor, 835

Help dialog box, 74–79

Help menu commands and options, 922

HEX2BIN function, 965

HEX2DEC function, 965

HEX3OCT function, 965

hh notation (hours), 529

hidden data in reports, 596

hidden file extensions, 53

hidden files, 845

hidden rows or columns

after filtering, 692

charts and, 658

displaying or hiding, 337, 940, 944

filtered lists and, 698

hiding. See also displaying

cells, 162–163

columns, 337, 940

comments, 252

fields in queries, 768

formula bar, 42

graphics, 393

keyboard shortcuts, 944

links to comments, 252

Mini toolbar, 95

numbers, 315

objects, 388

outlines, 255

PivotTable Field List window, 720

PivotTable outline controls, 724

PivotTable row and column labels, 724

Query criteria or tables pane, 771

Ribbon, 31

rows, 337, 940

Windows taskbar, 29

workbooks, 175–176

worksheets, 162–163

zero values, 100

hierarchies, SmartArt graphics for, 359

high-low lines in charts, 662–663

highlighting

breakpoints in code, 863

changes to workbooks, 791, 794–797

chart elements, 620

clearing, 795

conditional formatting rules, 284, 287

errors in code, 860

histograms, 553, 570–573

history

Document Information panel, 815

history worksheets, 796

Internet Explorer sites, 876

tracked changes, 794, 795–797, 798

History bar, Internet Explorer, 876

history worksheets, 796

HLOOKUP function, 512–515, 965

holidays, 534

Home key, 930

 Home Price Estimator.xlsx file, 563–564

Home tab commands and options, 909–911, 913, 915, 916, 918, 922–925

 Homes.xlsx file, 691

homograph attacks, 107, 110

horizontal axes, 625

horizontal page layouts, 403

horizontal position, locating, 512–515

HOUR function, 533, 965

hours

as chart base unit, 650

h, hh notation, 529

h notation, 528

limitations on, 530

overview, 521–522

HTM file format, 70

HTML

alt text graphic tags, 391

Compatibility mode and, 893

file format, 70

formatting, 784, 785

pasted tables in Word, 891, 893, 894, 895

HTTP prefix, 874, 876

HTTPS (secure Hypertext Transfer Protocol), 816

 Humongous08.xlsm file, 118

hurdle rates, 536, 540–541

HYPERLINK function, 880, 965

hyperlinks

compared to linking objects, 889

converting from URLs, 228

creating, 191, 874–879

creating documents by clicking, 873, 877–878

creating e-mail messages with, 874, 878–879

deleting, 192

displaying, 191

dynamically updating, 880

editing, 192, 880

formulas and, 880

to local files, 875–877

to locations within documents, 877

overview, 873–874

pasting, 191–192

to related SharePoint information, 815

removing, 876, 880

selecting items without activating, 879

sending by e-mail, 801

in shared workbooks, 792

to SharePoint files, 801, 815

text as, 874–875

troubleshooting, 874, 876

in Web queries, 780–781, 783–784

to Web sites, 875–877

in Word documents, 897

hyperthreaded processors, 463

HYPGEOMDIST function, 965

hyphens (-), 753