Excel for Marketing Managers

Cartesian Coordinate Grid

Cartesian
Coordinate
Grids

Handout Sheet...............................................................................................................

To make a handout sheet with six grids per side, do the following:

1. Select and copy the grid.
   Highlight the grid, and copy it by pressing Ctrl+C. Click on cell A18 and
   press Ctrl+V (paste); then click on cell A35 and press Ctrl+V.


2. Copy and paste the first column of the grid.
   Highlight all three grids on the left, and press Ctrl+C. Click on cell R1, and
   press Ctrl+V.


3. Set the column width.
   Unfortunately, using copy and paste does not adjust column width. How-
   ever, you can copy column widths using Paste Special. Once again, high-
   light the three grids in the first column and press Ctrl+C. Click on cell R1.
   From the drop down menu, select Edit → Paste Special → Column Width
   and press Enter.


4. Highlight all six grids, and then select File → Print Area → Set Print Area.


5. Adjust the margins to fit.
   From File → Page Setup → Margins, adjust all the margins to .5”, and cen-
   ter both horizontally and vertically. Click on Print Preview, and see what
   you have. Depending on your specific printer, this should work, but you
   may want to adjust margin spacing, or the amount of space between the
   grids on the worksheet.