+ Reply to Thread
Results 1 to 5 of 5

Define A Printable Page From Work Sheet

  1. #1
    Registered User
    Join Date
    12-20-2004
    Posts
    88

    Define A Printable Page From Work Sheet

    Is it possible to eliminate all the extra rows and columns from a work sheet so that only the used area is shown.

    I have a form that uses:
    ROWS: 1-17
    COLUMNS A - F

    Can I eliminate the rest of the work sheet?

    Thanks,
    Travelersway

  2. #2
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    Yes. Highlight the area you want to print, then from the File menu select Print Area>Set Print Area

    Next go to File>Print Preview to review your selection. Is it what you wanted? If not, click Setup... at the top of the screen and adjust as desired (fit to one page, portrait/landscape, etc.)

    HTH
    Bruce
    The older I get, the better I used to be.
    USA

  3. #3
    Registered User
    Join Date
    12-20-2004
    Posts
    88
    Thanks Bruce, but it's not the print that I need. I would like to have only the form that I've created displayed on the screen with the balance of rows and columns removed. Is it possible?

    Travelersway

  4. #4
    Forum Contributor
    Join Date
    08-23-2004
    Posts
    210
    One way is to hold down the control key and highlight any unwanted columns and rows by clicking on the row numbers and the column letters. Then use Fill Colour set to white to hide any unwanted gridlines.

  5. #5
    Registered User
    Join Date
    12-20-2004
    Posts
    88
    Cycling-rod,
    Thanks, but that's not what I need either. I phrased it wrong. I see from another thread that I should have said "Limit the scrolling".

    Gord Dibben had the answer to code the work book.

    Private Sub Work Book_ Open()
    sheets("Your sheet").ScrollArea = "A1:F17"
    End Sub

    That worked Great! But now I want to do multile forms within the work book and I can't make it happen, Any Ideas?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1