Excerpt
Symbols, Numbers
& (concatenation) operator, 102
` (backtick) key with Ctrl key, 137, 230-231
! (bang) in names, 131
, (union) operator, 108
$ (dollar sign) in addressing, 136
= (equal sign) for formulas, 140
3-D effects with AutoShapes, 70
3-D names, 132-133
A
About menu item, 14
absolute cell references, 136-138
access (see security)
Access forms, 290
AccessData tools, 279
active sheets, name and index of, 202
Actors folder, 88
Add Procedure dialog, 167
Add Text option, 67
"Add/Modify FTP Locations" option, 239
add-in programs, 154
auto-loading workbooks and, 207
installing, 6-7
list of, 7-8
Address box (Web toolbar), 245
addressing, types of, 136-138
Advanced button, 20
Advanced Filter feature, 296
alert messages (see dialog boxes)
alignment
angular text orientation, 104
default, by content type, 101
Formatting toolbar buttons for, 85
long text strings and, 104
"Allow cell drag and drop" box, 112
Alt key
AutoSum feature with, 142
macro keyboard shortcuts, 208
Page Up/Down keys with, 33
alternate startup file location (ASFL), 19, 268
"Always ask before opening workbooks with macros" box, 214
"Always create backup" box, 272
animated menus, 51
annoyances, types of, 2
anti-virus software, 215
API, Windows, 194
arguments, function, 140
arithmetic operators, 108
arrays, 236
arrow keys
auto-repeating nudge operations, 67
Ctrl with (zapping), 32-33
art (see images; Office Art)
ASFL (alternate startup file location), 19, 268
Audio Compression component, 90
audio effects, 89-91
audit trails, 215-219
Auditing toolbar, 222-229
adding Go To Special to, 238
flipping sheets button, 231
R1C1 style button, 233
Auto List Members feature, 170
Auto Quick Info feature, 171
AutoCalculate box, 15
AutoEntry feature, 110-112
AutoFill feature, 112-116
AutoFilter feature, 294-297
AutoFit option, 98
AutoFormat feature, 247-249
auto-loading workbooks, 207
AutoShapes (Office Art), 63-67
connecting AutoShape objects, 71-72
positioning objects, 73
text and links with, 67-69
toolbar control for, 81
AutoSum feature, 80, 141-143
B
backup files, 272
backward compatibility, 95
bang (!) in names, 131
Begin a Group menu item, 55
blank cells, 17, 101
Go To Special for, 235-236
lists and, 281
Bold button, 85
book-level names, 130
Borders button, 86
borders, style of, 222
breaking passwords, 278-279
breakpoints, 176
browser, Excel as, 80, 245-246
browser, object, 204-205
bugs when printing charts, 260
buttons
Button Editor dialog box, 54
IntelliPoint SnapTo feature, 41
on toolbar (see controls)
C
capitalization, 281
captions, dialog box, 184
cascading menus, 45
case sensitivity, sorting and, 281-282
CD-ROMs, key number for, 10
Cell Note dialog box (see comments)
cell references
range names for, 134
reference operators, 108
reference style, 136-138, 232-234
relative, 149
types of, 136-139
cells
AutoFill feature and, 112-116
blank (empty), 17, 101, 235-236
borders for, 86
comments in, 217
content alignment by type, 101
current region of, 236
data validation, 116-119, 227-229, 238
deleting vs. clearing contents, 120-121
field content, 281
Go To command for, 31
last cell, 237
long strings and, 103-104, 109
merging, 105-106
navigating to (see navigating)
programming at cellular level, 26
protection for, 277-278
ranges of (see ranges)
removing zeros from, 17
size limitation on, 35-38
styles for, 249-251
text in, 102-104
"Visible Cells Only" option, 237-238
(see also columns; rows)
Center and Merge button, 85, 105
centering text, 85
Change Button Image menu item, 54
character limits on cell data, 35-38
charts, 256-261
Chart toolbar, 259
Chart Wizard, 81, 256-258
events associated with, 209-211
child menus (see cascading menus)
Circle Invalid Data button, 224-227, 229
class modules, 209
Clear Validation Circles button, 224-227, 229
clearing cell contents, 120-121
clipboard (see cut/copy/paste)
Close button, 51-52, 77-78
Code Window, 157-159
code, obtaning updates of, xii
color-coding ranges, 35
colors, 86
borders, 222
columns
AutoFill feature and, 112-116
headers as drop-down controls, 294-297
hiding, 98-99, 252
labels for, 281
long numeric values and, 107
maximum number of, 38
naming, 129
"raised" headers for, 43
size of, 97-99
sorting as entirely text, 293
(see also cells; rows)
Comma Style button, 85
command
buttons for (see controls)
command bars, 44, 46-62
controls on (see controls)
creating new toolbars, 51-55
commands
adding to toolbars, 51
Auto List Members for, 170
comments, 15, 217-218
Go To Special for, 235
object-level protection and, 277
Shared Workbooks for, 279-280
comparison operators, 108
compatibility, 95
computer vs. human languages, 167
concatenation (&) operator, 102
Concept virus, 9, 213
conditional
formats, 107, 222
Go To Special for, 238
statements (see =IF( ))
connecting AutoShape objects, 71-72
connecting to Internet, 239-246
Connectors feature (Office Art), 71
constants (see numeric values)
Constants option (Go To Special), 235
content-level protection, 277
controls, 47
button controls, 47-49
column headers as, 294-297
drag-and-drop to toolbars, 52
on drawing layer, 100
images for, 51, 53
menus and menu bars, 55-60
placing on dialog boxes, 184-185
positioning, 48
VBA types for, 61-62
(see also toolbars; under specific control function)
conveyance controls, 79
copying
button control images, 53
controls to toolbars, 52
sheets, 28, 97
Standard toolbar button for, 79
"Create a copy" box, 97
Criteria option, 284
Ctrl key
` (backtick) and, 137, 230-231
arrow keys with (zapping), 32-33
AutoFill and, 113
copying sheets with, 28
drag-and-drop with, 123-124
End key with, 33
Enter key with, 143
Home key with, 33
for macro keyboard shortcuts, 208
Nudge operations and, 67
Page Up/Down keys with, 33
selecting multiple sheets, 28
Currency Style button, 85
current region, definition of, 236
cursor (see mouse)
customization
CD-ROM key number, 10
command bars for, 44, 46-62
creating new toolbars, 51-55
Custom Lists, 114
dialog boxes, custom, 183-185
filtering queries, 295
formats, custom, 222
important settings, 9-22
Office Assistant, 88
of OSB, 23
sound effects, 89-91
startup switches, 92-93, 266
toolbar menus, 56-57
toolbars (see toolbars; under specific toolbar)
views, custom, 251-253
Customize dialog box, 51
cut/copy/paste
cell contents, 121-123
names and, 132-133
Paste Function option, 80, 140
Paste Names command, 80, 133-134
Paste Special command, 122-123
toolbar buttons for, 79
(see also copying)
D
data forms, 282-285
Data Refresh option, 255
data validation, 116-119, 227-229
Go To Special with, 238
workbook forms and, 291
databases, types of, 280
dates, 107
dboxes (see dialog boxes)
DDE (Dynamic Data Exchange), 18
debugging
breakpoints for, 176
Debug button, 174
Debug toolbar, 160
decimal buttons, 86
declaring variables, 161
Decrease Decimal button, 86
Decrease Indent button, 86
decryption, 279
default file location, 13-14, 19
Default Style menu item, 54
Define Name dialog box, 128-129, 132
Delete menu item, 54
deleting cells, cell contents, 120-121
Delta virus, 213
dependents, trace, 225-226
design notes, 215-216
design time, 187
development environment, 92
diagonal text, 104
dialog boxes
custom (VBA), 183-185
data validation messages, 118
Excel settings, 15
Go To, 31
Go To Special, 119, 234-239
for invalid data errors, 227-229
magically shrinking, 34
Properties dialog, 19-20
virus warning message, 9, 214
disabling (see enabling/disabling)
Display Pane, 205
docking windows, 159
documentation
comments, 217-218
design notes, 215-216
(see also help and resources)
dollar sign ($) in addressing, 136
DOS programs, 194
double-clicking, AutoFill and, 115
drag-and-drop
"Allow cell drag and drop" box, 112
button controls, 52
creating toolbar shortcuts with, 23
manipulating cell contents with, 123-125
sheets and, 97
drawing, 35
drawing layer, 99-101, 261
Drawing toolbar, 63, 81
(see also images; Office Art)
drop-down menus, 45
Dynamic Data Exchange (DDE), 18
dynamic links, 20
E
/e startup switch, 93, 266
Edit Button Image menu item, 52, 54
editing
AutoShapes (see AutoShapes)
cell contents, 119-125
within cells, 102-104
charts, 259
multiple sheets, 28
password requirement for, 273
undoing, 34, 43-44
VBA/Excel Editor for, 151-166
Einstein character (see Office Assistant)
embedded charts, 258, 260
empty cells (see blank cells)
enabling/disabling
comments, 15
Find Fast, 10-11
formula bar, 109
IntelliPoint SnapTo feature, 42
Lotus transition navigation keys, 20
MRU list, 18, 23
type-ahead features, 171
(see also visibility)
end cell, 237
End key, 33
Enter key, 110-112
equal sign (=) for formulas, 140
errors
error tables, 221
Find Fast and, 10
in formulas, 144
overflow, 174
tracing, 226-227
traps for, 220-222
Escher (see Office Art)
events, 186-189
workbook-related, 209-211
Excel 97
Add-ins (see add-in programs)
backward compatibility and, 95
as Web browser, 80
connecting to Internet, 239-246
current version of, 14-15
development environment, 26
Excel Object Model, 190, 192-195
improvements over Excel 95, 33-39
installing, 3-8
launching, 265-266
most important files, 3-8
sound effects, 89-91
startup switches, 92-93, 266
as Web browser, 245-246
Excel/VBA language (see VBA)
exclamation point (!) in names, 131
Exit Edit Text command, 68
Expense Report template, 5
explicit intersection, 145
extensions, filename, 12-13
F
F2 key, 204, 218
F5 key, 31
F8 key, 176
F9 key, 143
fblnNullMenuState( ) example, 196
field content, 281
files
alternate startup file location, 19, 268
backup files, 272
default location for, 19
Excel's most important, 3-8
filename extensions, 12-13
formats of, compatibility and, 95
via FTP (see FTP)
fully qualified workbook paths, 199-200
help (see help and resources)
property information for, 19-20
protection levels, 272-275
read-only access, 274-275
recently used file list, 18, 23
shortcuts to, 23
web query, 243-244
Fill Color control, 86
Fill Effects dialog box, 70
filtering
Advanced Filter feature, 296
AutoFilter feature, 294-297
for backward compatibility, 95
custom queries, 295
lists, 292
Find Next, Find Prev options, 284
finding (see searching)
fintWorkbookCountHidden( ) example, 198-199
Fit Selection option, 219
flat file databases, 280
flipping sheets, 17, 137, 230-231
floating menus, 58-59
Focus feature (IntelliMouse), 41
Font Color control, 58-59, 86
For statement, 172
format, file, 95
formatting
AutoFormat feature, 247-249
AutoShape objects, 66, 70
AutoShape text, 68
cell-level protection, 277-278
conditional, for numbers, 107
custom/conditional, 222, 238
Format Painter button, 79
Formatting toolbar, 83-88
control properties, 83-84
multitude of options for, 246
presentation strategies, 246-253
styles for, 249-251
forms
Access forms, 290
forms^3 (see dialog boxes, custom)
for inputting lists, 282-291
templates for, 285-290
for the Web, 244
workbook forms, 291
formula bar, long strings and, 109
formulas
data validation and, 116-119, 227-229, 238
error traps, 220-222
errors in, 144
flipping sheets, 137, 230-231
Formula Palette, 80, 140-141
functions, 109
Go To Special for, 235
as names, 135
numbers as text and, 103
operators for, 108-109
R1C1 reference style, 136-138, 232-234
sheets and, 99
sorting, 282
Standard toolbar buttons for, 80
URLs in, 241-242
Formulas box, 17
FreeStuff page, 15
fstrActiveWorkbookName( ) example, 201
FTP (File Transfer Protocol), 239-241
full module view, 159
full screen view, 87
fully qualified paths, 199-200
Function Wizard (see formulas, Formula Palette)
functions, 26, 109, 140
Paste Function option, 80, 140
fvntWorkbookNames( ) example, 199
G
Gallery tab, 88
General tab, 18-22
geography (see maps)
Go To command, 31
Go To Special dialog, 119, 234-239
GPFs (see errors)
graphs (see charts)
gridlines, 17, 87
grouped subtotals, 298-299
H
handling events, 186-189, 209-211
hard copy (see printing)
headers of rows/columns, 43
height (see size)
help and resources, 3, 304-306
contacting Microsoft, 15
in VBA/Excel, 151
(see also Office Assistant)
"Hide MS-DOS file extensions for file types that are registered" box, 12-13
hiding (see visibility)
hierarchical menus (see cascading menus)
Home key, 33
HTML code generation, 242
human vs. computer languages, 167
hyperlinks
to AutoShape objects, 67-69
in formulas, 241-242
Insert Hyperlink button, 80
to maps, 254
sheets and, 100
I
=IF( ), 141
trapping errors with, 220-221
"Ignore other applications" box, 18
images
drawing layer, 99-101
Drawing toolbar, 81
Office Art, 62-73
Standard toolbar buttons for, 81-82
for toolbar controls, 51, 53
Immediate Window, 161, 178
implied intersection, 145
Increase/Decrease Decimal buttons, 86
Increase Indent button, 86
increment, AutoFill, 113-114
indentation of cell contents, 104
indenting text, 36, 86
Index property, 202
Information validation level, 229
Insert Hyperlink button, 80
inserting sheets, 27-28
installing
Excel 97, 3-8
Microsoft Query, 283
Office 95 sounds, 90
IntelliMouse, 40-42
IntelliPoint software, 40
Focus feature, 41
SnapTo feature, 41
Internet Assistant Wizard, 242
Internet connection, 239-246
intersection of ranges, 144-145
intersection operator, 108, 144
invalid data (see validating data)
Invoice template, 5
=ISBLANK( ), 102
Italic button, 85
K
key number, CD-ROM, 10
keyboard shortcuts
macros as, 208-209
showing with ScreenTips, 49
L
labels, 126
changing conditionally, 220
for columns, 281
creating names from, 129
"Large icons" box, 50
Laroux virus, 213-214
last cell, 237
launching Excel 97, 265-266
layout, 218-219
charts (see charts)
merging cells, 105-106
page breaks, viewing, 16
presentation strategies, 246-253
limits on length (see size)
links (see hyperlinks)
lists, 280-299
Custom Lists, 114
filtering, 292
forms for inputting into, 282-291
sorting, 292-294
subtotals, 298-299
"Ln X, Col Y" button, 160
loading workbooks, 207
Locals Window, 161, 178
Locked cell protection, 277
Lookup Wizard, 297-298
Lotus transitional settings, 20-22
M
"Macro virus protection" box, 18, 214
macros, 8-9, 146
assigning to menu bars, 208
keyboard shortcuts for, 208-209
recording, 148-150
toolbar buttons for, 207
VBA for (see VBA)
viruses (see viruses)
where to put, 207
maps, 253-256
Map control, 81
master templates, 267-269
math operators, 108
menu bars, 45, 60
macros on, 208
menus, 44-45
cascading (hierarchical), 45
drop-down menus, 45
"Menu animations" list, 51
pop-up (shortcut) menus, 45, 60
tear-off (floating), 58-59
on toolbars, 55-60
Merge and Center button, 85, 105
merging cells, 85, 105-106
merging styles, 271
messages (see dialog boxes)
methods, 191-192
Microsoft Excel (see Excel 97)
Microsoft Map (see maps)
Microsoft Product Support, 304
Microsoft Query, installing, 283
Microsoft, contacting, 15
mixed addressing, 138
models, definition of, 92
Modify Selection menu, 51-55
modifying (see editing)
mouse
IntelliMouse, 40-42
manipulating cell contents with, 123-125
pointers, list of, 23-25
zapping with, 32
moving
cell data between cells, 121-123
My Documents folder, 13-14
sheets, 97
(see also navigating; positioning)
Mr. Clipit (see Office Assistant)
MRU list, 18, 23
MsgBox command, 172
msoControl... types, 61-62
msoControlButton, 48, 61
msoControlComboBox, 47, 61
Multimedia component, 90
My Documents folder
relocating, 13-14
renaming, 14
N
Name field (Modify Selection menu), 54
names
cell ranges, 126-135
printing and, 261-262
relative, 138-139
zooming and, 30
columns and rows, 129
dialog box captions, 184
of files (see files)
for formulas, 135
My Documents folder, 14
Name box, 31, 127
Paste Names command, 80, 133-134
projects, 154-156
sheets, 28-29
for styles, 250
types of, 130-132
workbook sheets, 202-204
workbooks, 93, 201
navigating, 29-33
Go To command, 31
Go To Special, 119, 234-239
keys for, 20
sheets, 27
zapping to cells, 32-33
nested subtotals, 299
=NETWORKDAYS( ), 107
New button, 77-78
Notes feature (see comments)
Nudge menu, 67
"null menu mode" condition, 196
numeric values, 106-107
charts of, 256-261
conditional formatting, 107
data validation, 116-119, 227-229, 238
dates, 107
Go To Special for, 235
precision and rounding, 106
subtotals, 298-299
as text, 102
(see also text)
O
Object box (Code Window), 158
objects, 191-192
Excel Object Model, 190, 192-195
Go To Special for, 236
graphics (see images)
map (see maps)
Object Browser, 204-205
object-level protection, 277
objects oriented programming, 192
properties (see properties)
obtaining
current version of Excel, 15
example source code, 195
free Microsoft stuff, 15
updated code listings, xii
Office Art, 62-73
AutoShapes, 63-73
Office Assistant, 39
customizing, 88
toolbar control for, 82
Office Shortcut Bar (OSB), custom, 23
Offset( ), 165
Omit options, 135
OOP (object oriented programming), 192
opening files
default location for, 13-14, 19
passwords for, 273
operators, 108-109
Option menu item, 15-22
orientation of text, 104
OSB (Office Shortcut Bar), custom, 23
overflow error, 174
P
/p startup switch, 93, 266
page breaks, 16
Page feature (PivotTable menu), 301
page numbers, 263
Page Setup settings (see printing)
Page Up/Down keys, 33
Palette (see formulas, Formula Palette)
paper clip (see Office Assistant)
parameters, Auto Quick Info for, 171
passwords, 273-277
circumventing, 278-279
Paste Function option, 80, 140
Paste Names command, 80, 133-134
Paste Special command, 122-123
pasting (see cut/copy/paste)
Pause button, 160
Percent Style button, 85
performance
disabling Find Fast, 10-11
Map applet and, 255
shortcuts (see shortcuts)
templates to improve, 266-271
Personal.xls workbook, 153, 207
pivot tables, 299-303
Play button, 160, 164
pointers (see mouse)
points, in 2-D charts, 258
pop-up (shortcut) menus, 45, 60
positioning
AutoShape objects, 66, 73
button controls, 48
Formatting toolbar alignment buttons, 85
PostIt notes (see ScreenTips)
PowerOfTwo subroutine example, 173-177
precendent, trace, 224-225
precision and rounding, 106
presentation strategies, 246-253
PrintCbarsControlList program example, 178-181
printing, 261-264
charts, 260
print area, 17, 261
Report Manager and, 262-264
settings for, 252
Standard toolbar buttons for, 78
Procedure box (Code Window), 158
procedure view, 159
programming, 26
programs (see macros; VBA)
Project Explorer, 151-154
Debug toolbar button for, 161
projects
definition of, 152-154
names for, 154-156
"Prompt for workbook properties" box, 19
properties, 154-156, 191-192
Formatting toolbar controls, 83-84
Properties dialog box, 19-20
property information, 19-20
Standard toolbar controls, 75-77
Properties Window, 154-156
Debug toolbar button for, 161
Protect Workbook option, 275
protection levels, 272-278
"Provide feedback with sound" box, 90
Purchase Order template, 5
Q
query files, web, 243-244
R
/r startup switch, 93, 266
R1C1 reference style, 136-138, 232-234
Range( ), 165
ranges
color-coding, 35
current region, definition of, 236
finding in embedded charts, 260
Go To command with, 31
intersection of, 144-145
names of, 126-135
printing and, 261-262
relative, 138-139
zooming and, 30
printing (see printing, print area)
Range Finder feature, 139, 260
styles for, 249-251
Read Only button, 274
read-only files, 274-275
"Read-only recommended" box, 274-275
recently used file list, 18, 23
recording macros, 148-150
records (see data forms)
Rectangle objects, 63
Redo button, 80
redoing (see undoing changes)
reference operators, 108
references (see cell references)
References list (VBA/Excel Editor), 162
"Refers to" text box, 128
refreshing data, 255
relational databases, 280
relative addressing, 136-138, 149
range names, 138-139
relocating (see moving)
Remove All Arrows button (see Auditing toolbar)
renaming (see names)
"Replace current subtotals" box, 299
Report Manager, 262-264
"Require Variable Declaration" box, 161
Reroute Connectors feature, 72
Reset Button Image menu item, 54
Reset menu item, 54
resizing (see size)
resources (see help and resources)
review cycle, 279-280
Reviewing toolbar, 218
right mouse button
AutoFill and, 116
drag-and-drop with, 125
on toolbars, 52
Robert (see Office Assistant)
rounding numbers, 106
rows
AutoFill feature and, 112-116
hiding, 98-99, 252
maximum number of, 38
naming, 129
"raised" headers for, 43
size of, 97-99
(see also cells; columns)
run time, 187
"Run Web Query" option, 243
S
sActiveWorkbookSheetNames example, 202-204
Save As command options, 272-275
scenario-level protection, 277
ScreenTips, 49-50
searching
with AutoFilter, 294-297
coding ranges with color, 35
for data form records, 284
default file location, 13-14
Find Fast, disabling, 10-11
Lookup Wizard for, 297-298
for property information, 20
Range Finder feature, 139
for ranges in charts, 260
sections, report, 262-264
security
audits, 215-219, 222-229
breaking passwords, 278-279
error traps, 220-222
FTP and, 241
passwords, 273-277
protection levels, 272-278
viruses, 9, 18, 213-215
Select( ), 165
selecting cells, Go To and, 31
Series command, 112
Set Print Area command, 261
settings
dialog box for, 15
Lotus transition navigation keys, 20
Lotus transitional settings, 20-22
print area, 17, 252, 261
Snap, impermanence of, 67
sticky, definition of, 50
VBA/Excel Editor, 161-163
Shadow menu control, 70, 86
shapes (see AutoShapes)
Shared Workbooks, 279-280
"Sheet tabs" box, 27
sheets, 96-101
3-D names, 132-133
active, name and index of, 202
default number of, 38
dragging-and-dropping between, 125
drawing layer and, 99-101
editing multiple, 28
for error tables, 221
flipping, 17, 137, 230-231
inserting, 27-28
layout (see layout)
naming, 28-29
protection for, 276-277
sheet-level names, 131, 133
sorting names of, 202-204
tabs for, 27-29
using formulas with, 99
Shift key
drag-and-drop with, 124
Enter key with, 110
F2 key with, 218
macro keyboard shortcuts, 208
navigating sheets with, 27
selecting multiple sheets, 28
Tab key with, 112
shortcut menus (see pop-up menus)
shortcuts
AutoFill feature, 116
to frequently used files, 23
FTP navigation and, 240
keyboard (see keyboard shortcuts)
to launch Excel, 265-266
shrinking dialog boxes, 34
size
AutoShapes, 66
cell contents limitations, 35-38
columns (see columns)
comment text length limit, 217
data forms, 284
number of rows/columns, 38
points in 2-D charts, 258
"Refers to" box limitations, 128
rows (see rows)
sheet tab display, 27
workbook, 22
Snap To Grid option, 67
SnapTo feature (IntelliMouse), 41
sorting
column as entirely text, 293
field content and, 281-282
lists, 292-294
numeric values vs. text, 103
Standard toolbar buttons, 81
workbook sheet names, 202-204
sound effects, 89-91
space (see whitespace)
space character operator, 108, 144
Special button (see Go To Special dialog)
speed (see performance)
spelling toolbar button, 78
split screen and dragging, 125
Spreadsheet Solutions tab, 6
Standard toolbar
control properties, 75-77
customizing, 75-82
formula buttons, 80
for VBA/Excel editor, 160-161
Standard Width dialog box, 98
starting up Excel 97, 265-266
startup files
alternate location for, 19, 268
startup switches, 92-93, 266
status bar, 15
Step Into button, 161, 176
stepping AutoFill, 113-114
sticky settings, 50
Stop button, 160
Stop Recording toolbar, 149
Stop validation level, 227-228
Style drop-down control, 84
styles
formatting with, 249-251
merging between templates/workbooks, 271
submenus, 45, 58-60
(see also cascading menus)
subtotals, 298-299
=SUM( ), 142
Summary panel, 19-20
SuperAutoEntry feature, 111-112
switches, Excel startup, 92-93, 266
T
Tab key, 112, 278
tabs for sheets, 27-29
tear-off menus, 58-59
templates, 266-271
for forms, 285-290
installing, 5-6
merging styles between, 271
Template Wizard, 285-290
testing if cell is empty, 102
text
alignment of, 85
for AutoShape objects, 67-69
on button commands, 55
data validation, 116-119, 227-229, 238
editing within cells, 102-104
Formatting toolbar buttons for, 85
indenting, 36
long strings, 103-104, 109
orientation of, 104
sorting entire column as, 293
wrapping, 104
=TEXT( ), 102
three-dimensional names, 132-133
tilt handles, 67
tilting text, 104
Toggle Gridline button, 87
toolbars, 46
Auditing (see Auditing toolbar)
buttons on (see controls)
Chart toolbar, 259
controls on (see controls)
creating new, 51-55
customizing, 74-75
Debug toolbar, 160
Drawing (see drawing, Drawing toolbar)
Formatting toolbar, 83-88
images for controls, 51, 53
macros as buttons, 207
menus on, 55-60
PivotTable toolbar, 301
Reviewing toolbar, 218
right-clicking on, 52
Standard (see Standard toolbar)
Standard toolbar (VBA/Excel Editor), 160-161
Stop Recording toolbar, 149
Web toolbar, 80, 245-246
Tools¿Option menu item, 15-22
ToolTips (see ScreenTips)
Trace Dependents button, 225-226
Trace Errors button, 226-227
Trace Precedents button, 224-225
"Transition navigation keys" box, 20
Transition tab, 20
troubleshooting (see audit trails; errors)
turning on/off (see enabling/disabling; visibility)
U
Underline button, 85
Undo button, 44, 80
undoing changes, 34, 43-44
union (,) operator, 108
"Unique records only" box, 297
updated code, obtaining, xii
URLs in formulas, 241-242
"Use as default for new maps" box, 255
"Use Continuous Page Numbers" box, 263
"Use row and column names" box, 134
user forms (see dialog boxes, custom)
V
validating data, 116-119, 227-229
Go To Special with, 238
workbook forms and, 291
values (see numeric values)
variables, declaring, 161
Variant data type, 199
VBA (Visual Basic for Applications), 146-150
control types, 61-62
creating new programs, 166-171
custom dialog boxes, 183-185
events, 186-189, 209-211
help files for, 3
where to put macros, 207
VBA/Excel Editor, 151-166
Debug toolbar, 160
docking windows, 159
settings to fix now, 161-163
Standard toolbar, 160-161
VBAProject Properties option, 154
vbExclamation constant, 173
vbOKOnly constant, 173
vbYesNoCancel constant, 173
versions, Excel 97, 14-15
"View Microsoft Excel" button, 153
View tab, 15-17
viewing
custom views, 251-253
data form records, 284
VBA code, 159
viewing, full screen, 87
Village.xlt file, 5
viruses, 9, 213-215
anti-virus software, 215
"Macro virus protection" box, 18, 214
visibility
cell-level protection and, 277
columns and rows, 98-99, 252
comments, 15
counting visible workbooks, 197-199
filename extensions, 12-13
formula bar, 109
formulas, 137, 230-231
gridlines, 17
page breaks, 16
Properties and Project Explorer windows, 159-160
shrinking dialog boxes and, 34
status bar, 15
Visible Cells Only option, 237-238
workbook tabs, 27
zeros in cells, 17
(see also enabling/disabling)
W
warning messages (see dialog boxes)
Warning validation level, 228
Watch Window, 161, 178
Web (see World Wide Web)
weight, border, 222
wheel button (see IntelliMouse)
whitespace
blank cells, 17, 101, 235-236
Indent buttons, 86
leading spaces and sorting, 282
in sheet names, 29
width (see size)
Windows API, 194
wizards
Chart Wizard, 256-258
Internet Assistant Wizard, 242
Lookup Wizard, 297-298
Template Wizard, 285-290
Web Form wizard, 244
Word Concept virus, 9, 213
Word macro viruses (see viruses)
workbooks
associated events to, 209-211
auto-loading, 207
book-level names, 130
checking if open, 196-197
compatibility and, 95
counting number visible, 197-199
default number of sheets, 38
determining names of, 201
fully qualified paths for, 199-200
merging styles between, 271
naming, 93
Personal.xls, 153, 207
Project Explorer and, 152-154
property information for, 19-20
protection for, 275-276
Shared Workbooks, 279-280
sheet tabs for, 27-29
sheets (see sheets)
size of, 22
sorting sheet names, 202-204
startup switches, 92-93, 266
templates for, 266-271
workbook forms, 291
worksheets
events associated with, 209-211
functions (see functions)
layout of (see layout)
maximum number of rows/columns, 38
navigating (see navigating)
zooming, 29-30
World Wide Web
HTML code generation, 242
spreadsheet sites on, 306
Web Form Wizard, 244
web query files, 243-244
Web toolbar, 80, 245-246
(see also hyperlinks)
WOW (Woody's Office Watch), 306
wrapping text, 104
X
xlmain8.hlp file, 3
Xlscan.xla file, 214
Xlstart folder, 19, 153, 268
Y
"Yes to All" button, 34
Z
zapping, 32-33
"Zero values" box, 17
zooming, 29-30
sheet layout and, 219
Zoom control, 47, 82
END