1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

MS Excel

Discussion in 'Business Applications' started by Mikeybude25, Apr 7, 2004.

Thread Status:
Not open for further replies.
Advertisement
  1. Mikeybude25

    Mikeybude25 Thread Starter

    Joined:
    Feb 13, 2004
    Messages:
    42
    I have got a spread sheet and i want to print say column A
    and D so i select column A hold down CTRL and highlight
    column D i then go to print, however it prints it out on
    seperate pages, is there anyway to print it on 1 page.

    Thanks Michael
    .
     
  2. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    Select columns B & C, rightclick and hide.

    Print.

    Unhide columns B & C using UnDo.

    Rgds,
    Andy
     
  3. Mikeybude25

    Mikeybude25 Thread Starter

    Joined:
    Feb 13, 2004
    Messages:
    42
    Yeah thats what ive been doing but its a bit of a pain in the A$$ when i have a lot of different columns/rows that i wanted printed. Any other suggestions?

    Thanks

    Michael
     
  4. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    If the "pain in the A$$" is that you have to not print B&C today, & then again tomorrow, etc., etc. ; consider defining custom views (via the View menu).

    Might also help that you can select column D, click on a border then drag it over B&C while holding down SHIFT to slot it between A&B.

    Rgds,
    Andy
     
  5. Mikeybude25

    Mikeybude25 Thread Starter

    Joined:
    Feb 13, 2004
    Messages:
    42
    So basicly there is no way to select the cells i want, put a tick in some obscure box in some hidden options and have it print on 1 page?

    Thanks

    Michael
     
  6. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    Not to the best of my knowledge.

    You could write some code, but this would just automate the Hide -- Set Print Area -- Unhide steps.

    Rgds,
    Andy
     
  7. Mikeybude25

    Mikeybude25 Thread Starter

    Joined:
    Feb 13, 2004
    Messages:
    42
  8. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    Yeah, something like that. It's pretty verbose and for selected ranges ; if you're purely hiding columns &/or rows, you might find

    Sub Show_All()
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, _
    Collate:=True
    Cells.Select
    Selection.EntireColumn.Hidden = False
    Selection.EntireRow.Hidden = False
    End Sub

    vaguely useful for the printing/resetting.

    Rgds,
    Andy
     
  9. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/217999

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice