• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Open Excel Workbook/ Layout view

G

GN0001

Member
I open an Excel workbook and then I go to view and then click on Page Layout view and then I go back to Normal view, some line are getting displayed on my worksheet that I don't know how to get rid of them in a fast way, they can't be removed by remove page break, I have to switch to print preview and play around a little bit to get rid of them.

Thank you,

GGGGGNNNNN
 
Good day GGGGG


Excel 2007/2010

1.Click on the Office button (File Button in 2010) in the top left corner.

2.Select the Excel Options button at the bottom right side of the Office menu.

3.Select Advanced in the left column.

4.Scroll down to the Display Options for this Worksheet section.

5.Uncheck the box marked Show Page Breaks.

6.Click OK.


Excel 2003

1.Go to the Tools menu and select Options.

2.Select the View tab.

3.In the Window Options section, uncheck the box marked Page Breaks.

4.Click OK.


I believe that this method is sheet Specific so may need to be done again to other sheets
 
You must log in or register to reply here.
Back
Top