PRINTING PORTION OF WORKSHEET.
There are two ways to tell Excel to print a specified area of a worksheet --

1. To print a portion of a worksheet on a one-time basis, select the cells to be printed. Then in the "Print" dialogue box, choose "Selection" from the "Print What" options.
2. To save the designation of the print area with the spreadsheet, open the "Page Setup" dialogue box ("File" menu) and click the "Sheet" tab. Enter the cell range to be printed in the "Print Area" box.

CREATING A CUSTOM AUTOFILL SERIES.
Excel ships with certain commonly-used series programmed into its AutoFill feature and allows you to add to this list through the "Custom Lists" tab in the "Options" dialogue box ("Tools" menu). But you can also create a custom series by providing Excel with an example it can follow in creating the series. Here is how you do it --

1. Enter the first two series values in adjoining cells. For example, to create a series of integers beginning with 5 and increasing by 5 each time enter 5 and 10.
2. Select (highlight) the two sample cells.
3. Place the mouse on the "fill handle" in the lower right corner of the selected area.
4. Drag the mouse across the cells into which you want the series to be entered. In our example those cells would be filled with 15, 20, 25, etc.

AVOIDING GAPS IN CHARTS.
A common problem in creating Excel charts is how to eliminate gaps created by rows and columns in the data worksheet that intentionally have been left empty. Excel treats them as having a value of zero and plots them accordingly.

In many cases you can avoid this problem by entering the data without the empty cells, creating the chart, and then inserting the empty rows or columns. Excel will automatically maintain the linkages between the chart and the correct data cells in the worksheet.

This technique will not work where the insertion adds a category. In those cases you will have to tell the ChartWizard exactly which cells to plot. To do so, go to Step 1 in the ChartWizard and delete the entries in the "Range" box. Then highlight the cells containing the data you wish to plot. To skip empty cells, press the Control (Windows) or Command (Macintosh) key while highlighting the cells you want to include. Be sure to highlight the row and column titles in the worksheet if you want them added to the chart. Then proceed as usual with the remaining steps in creating the chart.

ADJUSTING COLUMN WIDTH TO FIT CONTENTS.
To adjust the width or one or more columns to fit the largest cell entry in each --

1. Select the columns to be adjusted;
2. Place the mouse pointer on the divider between any two column headings within the selected area (the heading is the gray box with a letter inside at the top of each column); and
3. Double click the mouse button.

Each selected column will enlarge or shrink so that it exactly fits the longest entry under it.

LINKING.
To link Excel workbooks easily, let Excel make the necessary entries for you. Here's how:

1. Make sure the source and linked worksheets are saved where you intend to keep them since the linkage records the exact locations of the files.
2. Open both worksheets, placing them side by side. The Arrange command (Window menu) can do this for you.
3. If necessary, scroll through the worksheets until the cells to be linked are both visible
4. Begin the formula in the linked cell.
5. Click twice on the source cell. The first click activates the source worksheet, the second enters the cell reference.
6. Complete your formula; press Enter.