Thread: Excel Question
View Single Post
Old 06-27-2007, 07:08 PM   #2 (permalink)
PC Hobbyist
Platinum Member
 
PC Hobbyist's Avatar
 
Join Date: Jun 2006
Posts: 548
Default

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.
__________________

PC Hobbyist is offline   Reply With Quote