DJI Computer Solutions

Software Applications for Microsoft Excel

The most unique, full featured spreadsheet applications on the web. These are not your father's spreadsheets!

Visit Checkbook on Facebook

Visit Handicap Manager on Facebook

Handicap Manager Help

• Introduction
• Welcome
• Registration
• License Agreement
• Disclaimer
• Installation
• New Features
• Administrator Mode
• Member Mode
• Instructions
• Getting Started Quickly
• Overview
• Handicap Format
• Program Options
• Golf Courses
• Golf Course Information
• Golfer Information
• Golfer Information
• Golfer Statistics
• Scores
• Enter Scores
• Editing Scores
• Deleting Scores
• Handicaps
• Calculating Handicaps
• Handicap Calculation Methods
• Course Handicap Calculator
• Handicap Sheets
• Handicap Cards
• Teams
• Team Assignments
• Entering Team Scores
• Reports
• Golfer Reports
• Scoring Reports
• Team Report
• Date Report
• Tournament Sheet
• Web Reports
• Appendix
• Format Changes
• Troubleshooting and Tech Support
• Miscellaneous Information
• Limited Stroke Control (LSC)
• Import Previous Version
• Definitions
• Networking
• Enabling Macros

 

 

Troubleshooting Handicap Card Printing

The first page of handicap cards print correctly but the information shifts down the page on subsequent pages. What adjustments can I make to fix the problem?

With the wide variety of printers and print drivers on the market, adjustments are necessary to make the cards print correctly on some printers. This problem can often be fixed by adjusting the page breaks or page margins as follows:

Go to the handicap card sheet and on the Excel command ribbon select the View tab and click Page Break Preview.

To adjust the page margins, select the Page Layout Tab and click Margins - Custom margins. To move the page break down, decrease the bottom margin to 0. To move the page break up, increase the bottom margin. Click OK to close the dialog box.

Look at the Page Break Preview again and see if the page break has moved to the correct position. Continue adjusting the bottom margin until it appears in the correct location.

Many inkjet printers do not support bottom margins as low as 0.5 inches. If you have already adjusted the bottom margin to zero and the page break is still too high, you will need to adjust the paper size using your printer driver as follows.

Use the Page Setup dialog box in Excel to set the page size as follows:

Select "Custom" as the paper size selection and enter 8.5 inches as the width and 11.25 inches as the length. Click OK and OK again to close both dialog boxes. (If your printer driver does not have a "Custom" paper size option, select legal size 8.5 x 14 inch paper.)

Look at the Page Break Preview again and see if the page break has moved to the correct position. Continue adjusting the paper size until it appears in the correct location.

If you have to use a custom paper size to print the handicap cards correctly, you may need to set the page size each time you want to print handicap cards.

The information on the handicap cards does not print in the correct position even on the first page. What adjustments can I make to fix the problem?

Make sure you are using Avery Inkjet (8371) or Laser (5371) business cards or equivalent. Business card sheets that are not this exact specification will not work correctly.

If the card rows are spaced correctly but are all shifted up, down, left or right, you will need to adjust the margins as follows:

Go to the handicap card sheet and on the Excel command ribbon select the View tab and click Page Break Preview.

To adjust the page margins, select the Page Layout Tab and click Margins - Custom margins.

If the card data needs shifted down, increase the top margin accordingly. If the card data needs shifted up, reduce the top margin accordingly. You may need to adjust the bottom margin an equal amount in the opposite direction. If the card data needs shifted left, decrease the left margin accordingly. If the card data needs shifted right, increase the left margin accordingly. You may need to adjust the right margin an equal amount in the opposite direction.

Look at the Page Break Preview again and make sure the dotted line showing the page break between pages 1 and 2 is located just above the first row of handicap cards on page 2. If it's closer to the numbers at the bottom of the last row of handicap cards on page 1 or somewhere else on the page, the bottom margin needs adjusted. (Don't worry about this adjustment if you are not printing a full sheet or more of handicap cards.) Click here for information on adjusting the bottom margin.

If the cards are not spaced correctly, i.e., the first row is correct but rows near the bottom are too far up or down, you will need to adjust the row heights in the Handicap Card sheet as follows:

In the upper left hand corner of the sheet, click the sheet selection block to select all the cells in the worksheet. (The selection block is located just above the 1 and just to the left of the A.)

Using the Home tab on the Excel ribbon click  Format-Rows-Row Height and enter a new value for the row height. The default value is 13.8. Increase the value to 14.4 to shift the bottom rows of handicap card data lower on the card sheets or decrease the value to 13.2 to shift the data higher on the card sheets.

Adjusting the row heights may affect the page size and require an adjustment to the bottom page margin. Click here for information on adjusting the bottom margin.