Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.printing,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Print on only one page

Hi all

How can select part from more worksheet print on olny one page without copy-paste

bong
  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.printing,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,514
Default Print on only one page

Hi all

How can select part from more worksheet print on olny one page
without copy-paste

bong


Select the range to print and choose the 'Selection' option in the
'Print what' box of the Print dialog, ..perhaps!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 621
Default Print on only one page

You cannot print ranges from more than one worksheet onto one sheet of
paper without copy/paste

You can print disparate parts of one worksheet by hiding areas between
the parts.

Gord

On Tue, 3 Dec 2013 13:37:52 +0100, "bong" wrote:

Hi all

How can select part from more worksheet print on olny one page without copy-paste

bong

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,514
Default Print on only one page

You cannot print ranges from more than one worksheet onto one sheet
of
paper without copy/paste


Ah.., so that's how it translates! Thanks for clarifying, Gord!!!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Print on only one page

"Gord Dibben" wrote in message
...
You cannot print ranges from more than one worksheet onto one sheet of
paper without copy/paste

You can print disparate parts of one worksheet by hiding areas between
the parts.

Gord


Thanks
Sorry for my english
Can I do it on other way.
Print on PDF and combine on one a single page?
Any idea?

Bong



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,514
Default Print on only one page

"Gord Dibben" wrote in message
...
You cannot print ranges from more than one worksheet onto one sheet
of
paper without copy/paste

You can print disparate parts of one worksheet by hiding areas
between
the parts.

Gord


Thanks
Sorry for my english
Can I do it on other way.
Print on PDF and combine on one a single page?
Any idea?

Bong


The usual process is to pull data from source sheets to a summary
sheet, arrange as desired, then print. You could probably use the macro
recorder to provide an automated method after recording your manual
actions if the process gets repeated...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do you print single page multiply times with increasing page . aliasmith Excel Worksheet Functions 2 September 26th 08 12:30 AM
Setting the print area in page set up to print 1 page wide by 2 pages tall EA[_2_] Excel Discussion (Misc queries) 2 July 12th 07 08:39 PM
PRINT PAGE BREAK VIEW AS WATERMARK FIOR EACH PAGE RALPH Setting up and Configuration of Excel 3 March 16th 06 11:08 PM
Active cell counting in particular print page (one sheet having different print area) ananthmca2004 Excel Worksheet Functions 1 November 24th 05 11:29 AM
How do I print a one page spreadsheet multiple time, each with its own page number? lhsallwasser Excel Discussion (Misc queries) 4 August 17th 05 03:00 PM


All times are GMT +1. The time now is 02:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"