Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
tikchye_oldLearner57
 
Posts: n/a
Default printing data from different location in same worksheet

hi community

is it possible to print data from different location example: i want to
print colum B and data from colum H

when I used ctrl+select and do a Print Preview, I can see both columns

But when I use Print Option: "Print Selection", I can only see column B and
column H
now goes to next page

can anybody please tell me how to do such that I able to view both columns
in the same Preview Page taken from the File Menu Print....

thanks community for the help :)
--
oldLearner57
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Barb Reinhardt
 
Posts: n/a
Default printing data from different location in same worksheet

Did you try File - Page Setup - Sheet Tab
Select the column B data for Columns to repeat at left
Select the Column H data for Print Area

"tikchye_oldLearner57" wrote:

hi community

is it possible to print data from different location example: i want to
print colum B and data from colum H

when I used ctrl+select and do a Print Preview, I can see both columns

But when I use Print Option: "Print Selection", I can only see column B and
column H
now goes to next page

can anybody please tell me how to do such that I able to view both columns
in the same Preview Page taken from the File Menu Print....

thanks community for the help :)
--
oldLearner57

  #3   Report Post  
Posted to microsoft.public.excel.newusers
tikchye_oldLearner57
 
Posts: n/a
Default printing data from different location in same worksheet

thanks :) now i got it and also able to apply to different cell ranges at
different location.

much appreciated :-
--
oldLearner57


"Barb Reinhardt" wrote:

Did you try File - Page Setup - Sheet Tab
Select the column B data for Columns to repeat at left
Select the Column H data for Print Area

"tikchye_oldLearner57" wrote:

hi community

is it possible to print data from different location example: i want to
print colum B and data from colum H

when I used ctrl+select and do a Print Preview, I can see both columns

But when I use Print Option: "Print Selection", I can only see column B and
column H
now goes to next page

can anybody please tell me how to do such that I able to view both columns
in the same Preview Page taken from the File Menu Print....

thanks community for the help :)
--
oldLearner57

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 I reference data from one worksheet to another using combob caricc New Users to Excel 0 December 17th 05 09:58 PM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Excel 2003, Convert EXISTING Worksheet Data to XML? [email protected] Excel Discussion (Misc queries) 4 November 16th 05 04:45 AM
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM


All times are GMT +1. The time now is 12:57 PM.

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

About Us

"It's about Microsoft Excel"