+ Reply to Thread
Results 1 to 2 of 2

Thread: How to print only text and not borders in a preprinted excel document?

  1. #1
    Registered User
    Join Date
    02-11-2010
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    1

    How to print only text and not borders in a preprinted excel document?

    I have created an excel document and I am wanting to have it printed on a three part form. How can I only print the inputs to the form. I am wanting the the document on the screen to look like the form. Is it possible to change the borders and heading titles to white and only print the text.

  2. #2
    Forum Guru 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Vienna, VA, USA
    MS-Off Ver
    Excel 2003, 2007
    Posts
    2,257

    Re: How to print only text and not borders in a preprinted excel document?

    Where are the borders located? To eliminate borders is easy--just click in the upper-left corner to select all cells then blank out the borders. These will permanently remove them; I know of no way to do this only for printing.

    To print without headers, you can select the area you want to print and "set print area."

    As is usually the case, it would be immensely helpful to attach your workbook.

+ 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.2.0