Share via

How do I delete a dashed print line from an Excel spreadsheet?

Anonymous
2011-05-03T09:28:32+00:00

I was going to print an Excel spreadsheet, but then changed my mind. Now I cannot for the life of me get rid of a dashed vertical print line in a document. Also when I try to e-mail the spreadsheet as an Excel attachment, it completely changed the format and doesn't even look like a spreadsheet

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2011-05-03T10:14:36+00:00

    Do the following two things:

    1. View Tab > Normal
    2. Office Button > Excel Options > Advanced > clear the Show Page Breaks check box in the Display Options for this Worksheet group,

    100+ people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-05-03T10:57:34+00:00

    There are two thing:

    1. If you want the spreadsheet to function as a spreadsheet to the recipient, then send it as an attachment.
    2. If you want the spreadsheet to look like a nice table in the body of an email, then:  Paste > As Picture > Copy as Picture and then paste in the body of the email
    0 comments
  2. Anonymous
    2011-05-03T10:45:38+00:00

    Thanks very much for your answer! Don't know if you saw the other part of my question? Which is if I get rid of the dashed print line, will it allow me to e-mail my 2007 Excel spreadsheet, so that it remains intact? Right now, when I send it, it's not looking anything like an Excel spreadsheet!

    Thank you!

    0 comments