Microsoft Excel is an important instrument in ordering your work and has a wide variety of routines, since it is a very powerful and individualized spreadsheet, which perhaps at first you will find it somewhat difficult to manipulate. This is the case, when the moment comes when we get the dotted lines that we do not require or ‘the grid lines ‘. And the idea is not to have them, so that our work yields better results.
How to Remove Dotted Lines from my Excel Step by Step
How to remove dotted lines from my Excel? To answer this question, this article will look at four points . ‘First, what is the function of dotted lines in Excel spreadsheets. Second, Methods to remove page breaks in Excel from your display. Third, how do I prevent the dotted lines from being generated later in my spreadsheet. And, fourth, What other actions can be performed with Excel page breaks’.
Index( )
- What is the function of the dotted lines in Excel spreadsheets?
- Methods to remove page breaks from your display in Excel
- Using MACROS
- With VBA programming
- Through the immediate window
- How do I prevent dotted lines from being generated later in my spreadsheet?
- What other actions can be performed with Excel page breaks?
- view all
- move them manually
- remove only one
What is the function of the dotted lines in Excel spreadsheets?
‘The function of the dotted lines in Excel spreadsheets’ when we open the dialog box to Print, is to indicate until which sheet you are going to make said print. Those dotted lines, what it does is show you up to which part the page breaks will make you for later printing . They state where the pages will be separated; that is, they reveal the set of sheets that are going to be printed in the same Excel document or PDF document. So what you should do is enter the File menu and then click on the Print option.
Methods to remove page breaks from your display in Excel
When working in the Excel spreadsheet, many times we see page breaks that we really don’t want to see, and they appear when we left click on the mouse and select the Preview page break option in the tab, later in View and finally clicking the left side of the mouse where you will click on Normal, the lines appear, however, the page breaks in Excel do not disappear automatically .
As you can see, these page breaks in Excel are not very easy to remove by just clicking on the left side of the mouse and choosing a remove option, sadly you can’t do that. To remove page breaks from your display in Excel you have to use the following Methods that only the Excel spreadsheet gives you so you can disable them. And these methods are: ‘Using MACROS, With VBA programming and Through the immediate window’.
Using MACROS
As we already indicated, ‘To remove page breaks from your display in Excel is somewhat difficult, since they do not disappear automatically, but in this part, we are going to indicate which MACROS you must activate and which you must Use to remove them and is the following:
Sub Macro2() Dim sh As Worksheet For Each sh In ActiveWorkbook.Worksheets sh.DisplayPageBreaks = Not sh.DisplayPageBreaks Next sh End Sub. It should be noted that said ‘MACROS’ will also help you to show page breaks in Excel, in case they are not seen and on some occasion if you want to view them.
With VBA programming
‘To remove page breaks from your display in Excel With VBA programming ‘, is similar to the one we use to remove blank spaces in our Excel document, this time you just have to follow these simple steps:
- First,when you enter Excel you must write the data you want to empty, covering about three sheets and press the ALT+F11 key , this procedure will allow you to start with the Visual Basic editor.
- Second, in the menu titled Insert, select the Module option and write the following codein the bar : Sub SetAttributes()For Each xWorksheet In ActiveWorkbook.Worksheets xWorksheet.PageSetup.Orientation = _ Worksheets(“Sheet1”).PageSetup.Orientation Next xWorksheet End Sub.
- Third,press the ALT+F11 key again to switch to Excel and choose Sheet1. Then go to the menu titled File and click on the Page Setup option. It should be noted that in Excel 2007, you must click on the launcher of the dialog box, then on the Page Setup group of the tab, followed by Page Layout and Click on Orientation, Landscape and finally on OK.
- Fourth,go to the menu titled Tools, choose the Macro option and then click on Macros. Click on SetAttributes and then on Execute and that’s it.
Through the immediate window
To remove page breaks from your display in Excel Using the immediate window is even simpler, since it is only done in two steps:
- First,you must click anywhere in the Excel spreadsheet to delete the print area you want.
- Second,go to the Page Layout option, then click on the selection titled Page Setup and proceed to click on Clear Print Area and that’s it.
How do I prevent dotted lines from being generated later in my spreadsheet?
To prevent the dotted lines from being generated later in my spreadsheet, you just have to follow these simple steps:
- First,Proceed to click the File icon that is in the upper part of the left corner of the screen.
- Second,you will see a list of options that you will also see on the left side of the screen, which you must choose the selection titled
- Third,scroll down until you see the option Display options for this worksheet and proceed to uncheck the box next to the option titled Show page breaks and you’re done.
What other actions can be performed with Excel page breaks?
The dotted lines turn out to be annoying because they make our data visualize as if it were working in the first spreadsheets and deactivating them is a bit difficult. Even if you don’t take ‘other actions that can be done with Excel page breaks’ they would hurt the spreadsheet completely.
That is why you could choose to deactivate them, clicking on the option titled View that you will find at the top and proceed to look for the check mark in the box called Grids and in the box proceed to Uncheck it. Now, there are “other actions that can be performed with Excel page breaks” such as: View all, Move them manually and Remove only one, which we will explain how to do below.
view all
To ‘View all Excel page breaks’ and at the same time eliminate them, you must follow these simple steps and thus obtain an optimal result in your work:
- First,click the File option that is located in the upper left corner of the ribbon, then a list of choices will be displayed, choose the one titled Options.
- Second,find the Advanced option and click on it and then scroll to the bottom and click on the option titled Show options for this worksheet and you will see the last option Show page breaks, which you should uncheck and that’s it.
move them manually
To ‘Excel page breaks to move them manually ‘ and at the same time eliminate them, it is very simple, you just have to follow these steps and thus be able to obtain an optimal result of your work done in said spreadsheet:
- First,head over to the menu called View and then click on the option titled Page Break Preview.
- Second,hover the pointer over the ‘Page Breaks’ line until it changes, then move the ‘Page Breaks’ line to a new place. When making the movement of a page break automatically, it will change you to Manual mode .
remove only one
As we already mentioned, the dotted lines turn out to be annoying, and that is why we want to eliminate them. But there are times when we don’t want to remove all of ‘Excel page breaks’, just ‘ Remove only one ‘ . If this is your case, we will tell you that it is very simple, you just have to follow these steps and thus be able to obtain an optimal result of your work done in said spreadsheet:
- First, you must go to the option titled View that you will find at the top of your screen and click on it.
- Second, you will see a list of options, proceed to look for the check mark in the box called Grids and in the box that it has, proceed to Uncheck it and that’s it.
