Index
from Start screen, 153–154
from a template, 166–168
exporting data to Power Query, 852–853
file extension, 4
finalizing, 778
inspecting, 779–780
linking, 637–646
changing link source, 643
changing startup prompt, 642–643
creating external reference formulas, 638–640
creating links to unsaved workbooks, 640–641
intermediary links issue, 646
modifying source workbook, 644–645
moving source workbook, 644
opening workbook with links, 641–642
overview, 637–638
phantom links, 432
renaming source workbook, 644
Save As command issue, 644
severing links, 643
updating links, 643
marking as final, 778
opening, 154–157
automatically, 157
Open event, 1000–1001
requiring password, 774–775
with external reference formulas, 641–642
Workbook_Open procedure, 1000–1001
overview, 4–5, 4–7
protecting, 59, 769, 774–777
adding digital signatures, 780
sav ing, 27–28, 157–159
as add-in files, 1030, 1035
AutoRecover, 159–160
BeforeSave event, 1000, 1002
containing volatile functions, 54
as CSV file, 159
as template, 171
using VBA, 1020
workbooks containing macros, 920–921
WORKDAY.INTL function, 279–280
worksheet events, 997, 1003–1006
BeforeRightClick, 1006
Change, 1003–1005
SelectionChange, 1005–1006
worksheet outlines
adding data, 635
adjusting symbols, 635–636
creating automatically, 632
creating manually, 632–634
displaying levels, 634–635
hiding symbols, 636
overview, 627–631
vs. PivotTables, 630–631
preparing data for, 631–632
removing, 635
Worksheet_BeforeRightClick procedure, 1006
Worksheet_Change procedure, 1003–1005
Worksheet_SelectionChange procedure, 1005–1006
worksheets
activating, 54–55
adding to workbooks, 55
comparing, 61–62
consolidating, 646–654
example, 650–653
refreshing consolidation, 653–654
sources, 654
using external reference formulas, 647–648
using the Consolidate dialog box, 649–650
using the Paste Special dialog box, 648–649
copying, 57–58
data entry
AutoComplete, 40–41
AutoCorrect, 41–42
AutoFill, 39–40
data forms, 42–44
dates, 33–34
Enter mode, 33
numbers, 38–39, 42
numeric values, 31–32
text, 32–33
times, 34
date-stamping, 44
deleting, 55–56
filling gaps, 606–607
formatting, 117–118
borders and lines, 128–130
colors and shading, 127–128
conditional formatting, 131–142
document themes, 147–151
fonts, 120–122
named styles, 143–146
text alignment, 122–127
with the Format Cells dialog box, 119–120
with the Home tab, 118
with the Mini toolbar, 118–119
hiding, 58
mov ing, 57–58