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: quot;Print Selectionquot;, 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 gt; Print....
thanks community for the help
--
oldLearner57
Did you try File -gt; Page Setup -gt; Sheet Tab
Select the column B data for Columns to repeat at left
Select the Column H data for Print Area
quot;tikchye_oldLearner57quot; wrote:
gt; hi community
gt;
gt; is it possible to print data from different location example: i want to
gt; print colum B and data from colum H
gt;
gt; when I used ctrl select and do a Print Preview, I can see both columns
gt;
gt; But when I use Print Option: quot;Print Selectionquot;, I can only see column B and
gt; column H
gt; now goes to next page
gt;
gt; can anybody please tell me how to do such that I able to view both columns
gt; in the same Preview Page taken from the File Menu gt; Print....
gt;
gt; thanks community for the help
gt; --
gt; oldLearner57
thanks now i got it and also able to apply to different cell ranges at
different location.
much appreciated :-gt;
--
oldLearner57quot;Barb Reinhardtquot; wrote:
gt; Did you try File -gt; Page Setup -gt; Sheet Tab
gt; Select the column B data for Columns to repeat at left
gt; Select the Column H data for Print Area
gt;
gt; quot;tikchye_oldLearner57quot; wrote:
gt;
gt; gt; hi community
gt; gt;
gt; gt; is it possible to print data from different location example: i want to
gt; gt; print colum B and data from colum H
gt; gt;
gt; gt; when I used ctrl select and do a Print Preview, I can see both columns
gt; gt;
gt; gt; But when I use Print Option: quot;Print Selectionquot;, I can only see column B and
gt; gt; column H
gt; gt; now goes to next page
gt; gt;
gt; gt; can anybody please tell me how to do such that I able to view both columns
gt; gt; in the same Preview Page taken from the File Menu gt; Print....
gt; gt;
gt; gt; thanks community for the help
gt; gt; --
gt; gt; oldLearner57
- Nov 03 Mon 2008 20:47
printing data from different location in same worksheet
close
全站熱搜
留言列表
發表留言
留言列表

