Efficiently using printing area.
Efficiently using printing area.
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Efficiently using printing area.

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Is there a setting that will allow you to efficiently use the print area on a page? For example, I have one or two long columns of data that I want printed, but I don't want to print one column per page for hundreds of pages. Any ideas?


  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Solution #1
    Maybe not the best solution, however, I would turn the column into multiple columns. I typically keep columns limited to 50 rows in Portriat.

    The quickest way to accomplish the breakdown of a long column would be as follows:

    If your list starts at A2 goto B2 and enter
    =A51
    Copy that cell and past it down to B50. Continue that process in C2, D2, etc. until finished. Upon finishing copy the whole page and save special "values". Finally, delete A51 thru A65000. (hint- hold the shift key at A51, hit the end key, then down arrow.)

    For two long columns, I would simply use the borders to identify the continued data.

    Solution #2
    If you have several columns of data and only a few are long, I would suggest selecting the column header row to be continued on all pages in the page setup.

    I hope this will provide as an aid, until a better solution is made.

    -Dave

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com