Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Printing multiple ranges on one page

4 views
Skip to first unread message

Joe McLain

unread,
Jun 3, 1999, 3:00:00 AM6/3/99
to
Hello all!

We have an Excel 97 spreadsheet that we'd like to print portions of.
Sounds easy enough, right? The problem is that we want to print
multiple discontiguous ranges on the same page. We've searched and
searched and come to the conclusion that it can't be done but it's
important enough that I thought I'd consult the collective knowledge
of the Usenet to see if anybody out there knew of a way.

Here's a visual of what we have:

****************************************************
* -------- -------- -------- *
* | | | | | | *
* | R1 | | R2 | | R3 | *
* | | | | | | *
* -------- -------- -------- *
****************************************************

Here's a visual of what we want:

****************
* -------- *
* | | *
* | R1 | *
* | | *
* -------- *
* *
* -------- *
* | | *
* | R3 | *
* | | *
* -------- *
****************

If anybody out there can help us out, *please* do so; we'd really
appreciate it.

Thanks in advance for the help -

Joe McLain
System Administrator
Please Mail To joecm...@yahoo.com <------NO SPAM

DMcRitchie

unread,
Jun 3, 1999, 3:00:00 AM6/3/99
to
Hi Joe, (posted with email copy)

Not sure how far you want to go with compressing multiple ranges on one page.

First would think that you want headings top and left to show and line up.

You can hide rows and hide columns.
Format -> Row --> Hide
Format -> Column --> Hide

You can hide a lot of rows OR columns at one time, don't try to do both at once
or you will see nothing. By selecting multiple columns using the Ctrl key to
select noncontiguous columns if necessary and then using
Format --> Column--> Hide
similar for hiding selected rows.
Format -> Row --> Hide

If you print at this point you will not print hidden cells.

Having done the above, should you want to do something with only the visible
cells like pasting only the visible cells into another spread sheet.

1). Select the upper left cell
2). extend the selection to the last cell
Ctrl + End
3) select only the visible cells
ALT+SEMICOLON
I like to use the button for this looks like 4 rectangles.
4) Copy cells -- Ctrl+C
5) Create new spreadsheet
6) Paste into new sheet -- Ctrl+V

don't paste into current sheet, at least not into area with hidden rows or
columns.
and then you can copy (Ctrl+C) and paste them (Ctrl+V) onto another
spreadsheet.

Another thing that might also be useful in a pinch to add to the above, takes
more storage space, but you can create a picture of cells and move it around.

-- select cells
-- hold down the SHIFT key and then menu Edit --> Copy Picture
-- copy cells Ctrl+V
--- move the picture around the spreadsheet

You may want to change to or from Landscape when printing.

Incidentally after making a selection of visible cells from within a selection
of cells you can apply a shading or font change, bold for instance, to the
selected cells. Which could improve your master list as to what was included.

You can UNHIDE everything by using the Select ALL key and then using either of
Format --> Columns --> Unhide or Format --> Rows --> Unhide, whichever is
easier

Hide selected rows CTRL+9
Unhide selected rows CTRL+SHIFT+(
Hide selected columns CTRL+0 (zero)
Unhide selected columns CTRL+SHIFT+)
.

HTH, I had not read complete note before replying so missed your graphic
example, for that it would probably be simpler to simply create a new page.
Select Region 1 and paste to second page, select region2 and paste to second
page.

Along similar lines of saving paper that is, look for Snake macro which can be
located from my home page.

David McRitchie
My Excel Pages: http://members.aol.com/dmcritchie/excel/excel.htm

Bob Flanagan

unread,
Jun 3, 1999, 3:00:00 AM6/3/99
to
Joe, yes it can be done. For each range, do the following:

highlight it
while holding down the shift key select Edit, Copy Picture
Go to a new sheet and do an Edit, Paste
Select the picture
type an equal sign (=) and then highlight the original range.

Repeat for the other ranges. Arrange the pictures the way you want them.
The purpose of last step, creation of a formula, is to update the picture
for any changes in values in the original range.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros

Joe McLain <joecm...@NOyahoo.comSPAM> wrote in article
<3756dd28...@butch.lmms.lmco.com>...
> Hello all!

0 new messages