Page 20 - Excel Progamming Weekend Crash Course

540629 FM.qxd 9/2/03 4:10 PM Page xvii

Contents xvii

SESSION 14–Formatting a Worksheet ..........................................................171
Cell Formatting ..................................................................................171
Number Formatting ...........................................................................173
Font Formatting ...............................................................................175
Alignment and Orientation of Data ........................................................176
Cell Borders .....................................................................................178
Cell Backgrounds ..............................................................................181
Changing Row and Column Size .............................................................184
SESSION 15–Find and Replace Operations ...................................................187
Finding Data ......................................................................................187
The Find Method ..............................................................................188
The FindNext and FindPrevious Methods .................................................189
Replacing Data ..................................................................................192
SESSION 16–Creating Custom Toolbars ........................................................195
Customizing Toolbars in Excel ...............................................................195
Displaying and Hiding Toolbars ............................................................195
Creating a New Toolbar .......................................................................197
Adding and Removing Toolbar Buttons ...................................................198
Running Programs from Toolbar Buttons .................................................199
Distributing Toolbars ...........................................................................202
Hiding and Displaying Toolbars in VBA Code ...........................................203
PART IV–Saturday Evening ................................................................208
SESSION 17–Introduction to Charts ............................................................209
Embedded Charts and Chart Sheets ........................................................209
Embedded Charts ..............................................................................211
Chart Sheets ....................................................................................211
The Chart Object .................................................................................212
Identifying Data to Be Plotted .............................................................212
Specifying Chart Type ........................................................................214
Controlling Chart Appearance ...............................................................216
Displaying Chart Titles .......................................................................216
Chart Axis Titles ...............................................................................217
Working with Fonts in a Chart ..............................................................219
The ChartWizard Method ......................................................................222
SESSION 18–Advanced Charting Techniques ................................................225
Naming and Referencing Charts ............................................................225
Locking Charts ...................................................................................226
The ChartObject Object .........................................................................227
Using Scatter Charts ............................................................................231
Scatter Chart Types ...........................................................................233
Changing Axis Range .........................................................................234
Printing Charts ..................................................................................235