How to Print Part of a Spreadsheet (SS)

This is a portion of an article that originally appeared in the ClarisWorks Journal, the monthly publication of the ClarisWorks Users Group, Box 701010, Plymouth, MI 48170; (313) 454-1969; Fax: (313) 454-1965. Copyright ClarisWorks Users Group; reprinted with permission.

This information was provided by Claris Corporation on 16 March 1998, and incorporated into Apple Computer's Tech Info Library.

How to print a spreadsheet the way it appears on the ClarisWorks screen instead of printing the whole spreadsheet

Q. I use ClarisWorks' "pane" feature to split my spreadsheet screen and keep different parts of the spreadsheet in constant view. Is there any way to print the spreadsheet the way it appears on the ClarisWorks screen instead of printing the whole spreadsheet? If not, is there another way for me to print separate parts of the spreadsheet at one time?

A. There are at least two ways to get the output you want. One approach is to capture an image of your screen. A second technique is to "hide" the unwanted columns or rows in your spreadsheet.

The screen capture feature built into all Macintosh computers makes it easy to capture an image of any ClarisWorks screen. Press Shift- Command-3 any time you want to capture the screen; your Macintosh will create a Paint file called "Screen 0" (if you use System 6) or "Picture 0" (if you use System 7) . Your computer automatically names successive files "Screen 1", "Screen 2", and so on.


Then you can use ClarisWorks to view and print the image. Select "Open" from the ClarisWorks File Menu, click on the Import Options lever, and click on the Graphics Button. Then navigate to the root directory of the drive you use to store ClarisWorks and select the "Screen 0" or "Picture 0" file. ClarisWorks will create a new document that contains the screen image (see Figure 1). You can then print, rotate, or resize the image.

This is a bit-mapped image, so you cannot use ClarisWorks to edit the image. However, the article on page 4 of this issue of the ClarisWorks Journal describes how you can use a paint program to modify these screen-shot graphics.

Although it is easy to capture a screen image, your resulting output will include all the elements on the screen, including the ClarisWorks menus and the ÒframeÓ of the window. In addition, the bit-mapped image you capture does not produce high quality printing.

A more elegant approach is to "collapse" the spreadsheet rows and columns you do not want to appear in your printout. To do that, select the columns (or rows) you want to collapse and choose "Column Width" (or "Row Height") from the Format Menu. Type a zero in the dialog box and click on "OK". The columns and rows seem to disappear (see Figure 2).


For example, suppose you only want to print columns A through C and N through P. That means you want to collapse columns D through M. Select columns D through M and set their column widths to zero. When you print the spreadsheet, columns D through M will not print.

To restore (or "un-collapse") the columns, select the columns on either side of the collapsed section (in this case, columns C and N), and set the column width to its original size.

Figure 1

Figure 2

Published Date: Feb 18, 2012