Excel Question

Platinum

Platinum

New Member
Hey, so in Excel when you go to print something, or print preview - these dotted lines come up after, which shows the printable area of the spreadsheet. Almost like a page break but not. It shows what cells will be printed on the page based on the dotted lines. Is there anyway to remove it? Some people here in the office were saying it's annoying. I'd google it, but I don't even know what it's called. It's not a page break (I searched "remove page break excel" on google), so I don't even know what to search.

Thanks in advance!
 
What version of Excel are you using? 2003 or 2007?
In either case, it is similar. Make sure you are not in "page break" view, but rather in "normal" view (or else the options to not show page breaks will be grayed out). FYI - Page break view shows you the thick blue lines where the page will break and allows you to drag those lines to a different place. Normal view shows you the page breaks but in thin black dotted lines (which I assume is what has been annoying you).

Ok, so once you are in Normal view:
Go to Tools--Options--View (Page breaks) and there you have to take the check mark off so that page breaks are not shown. (I am going off of memory here, so it could be that the steps are not identical - but close enough).

In Excel 2007 - click on the Office button, then on Excel Options at the bottom right. Then choose the Advanced tab and scroll down to Display Options For This Worksheet. Take the check mark off of "show page breaks".


Your thin black dotted lines should be gone now.
 
I have one other question:
I've created a rule to have any e-mail I send to person X moved to a specific folder. The problem is, the e-mail gets moved to that folder if person X is in 'Cc' as well, not just 'To:' - I only want it to go to that folder if the persons e-mail is in the 'To:' box

Is there a way to specify that? Or am I just stuck with it like that, and I'll hafta manually delete it from the folder?
 
Platinum said:
I have one other question:
I've created a rule to have any e-mail I send to person X moved to a specific folder. The problem is, the e-mail gets moved to that folder if person X is in 'Cc' as well, not just 'To:' - I only want it to go to that folder if the persons e-mail is in the 'To:' box

Is there a way to specify that? Or am I just stuck with it like that, and I'll hafta manually delete it from the folder?
Click to expand...

I assume you are now talking about MS Outlook?

Hmm, I read somewhere, that rules do not apply to recipients in the Bcc (blind carbon copy) field. I don't know if Microsoft has changed this. But, instead of putting the address in the cc field, try putting it in the bcc field. Of course if you need for others to see that person X also received a copy of that email, well then you might be stuck with your rule moving that email to a given folder.

The Bcc field is not always shown by default. However that can be changed (at least in Outlook 2007 for sure). If you need to know how, let me know what version of MS Outlook you are using.
 
No, that's alright. Thanks for your help though. I appreciate it.

Edit: PS... sorry for the sudden change in topic. I completely changed from excel to outlook without even thinking nor telling you hahaha.
 
You must log in or register to reply here.
Back
Top