tips for printing and viewing electronic copy
tips for printing and viewing electronic copy
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: tips for printing and viewing electronic copy

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I want to print my excel worksheet with the least amount of space between the cells (but still be able to see seperation) and then also be able to see, in the electronic copy, the actual number (NOT the pound sign because the numbers won't fit in the cell). Is this possible? Is there some relationship between the GUI and what is printed? Is there a font that is better for printing and viewing?

    Thanks,

    Dave

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Brampton
    Posts
    328
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Select all cells and apply autofit for columns:

    Cells.Select
    Seleaction.Columns.Autofit

  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi davers5:
    In addition to what Corni suggested, you may also want to try print settings as follows:
    1) adjust your column widths and font sizes so you can actually see the numbers and not the # signs
    2) Then FILE|PAGE_SETUP|PAGE|choose the option FIT_TO say 1 page wide by 1 page tall or to suit your needs

    HTH
    Please post back if it works for you ... otherwise explain a little further and let us take it from there!

    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

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