Noncontiguous ranges printed on one page????

  • Thread starter Thread starter ajchula
  • Start date Start date
A

ajchula

My boss swears he knows of a way to print noncontiguous ranges on one
page, without using the "copy/paste picture link" method...of course,
he claims he just can't remember how to accomplish this. I say "no
way...can't be done." Is he correct? Does anyone know of a way to do
this? Oh, and without hiding columns or copying data to a new
worksheet...and no macros, either.
 
I'd insert a new worksheet.
Then select the first range
edit|copy
back to the new worksheet
shift-edit|Paste picture link

Then do the same with the second range.
 
Given all your exclusions, not that I can think of I'm afraid.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 
Given the constraints listed in your post..........No, it cannot be done.


Gord Dibben Excel MVP
 
Without..........

Never mind.



Dave said:
I'd insert a new worksheet.
Then select the first range
edit|copy
back to the new worksheet
shift-edit|Paste picture link

Then do the same with the second range.
Click to expand...
 
LOL :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to print noncontiguous ranges? 1
Print on only one page 5
Printing: page count exceeds pages in tab 1
Set Print Area & print on one page 2
print range won't print 2
In XCEL? How do I set the heading-cells to appear on every page? 1
Printing ranges 1
Number of pages in worksheet doesn't match Print Preview pages 2

Back
Top