Reset Excel Default Borders

Question

Good, so you know what the spreadsheet looks like when you open a new one in Excel; the borders are light blue. This is only on screen, although if you print a sheet, it will have no borders. Suppose you apply a few different formatting to a sheet (background color, etc.), and these borders disappear by default. My question is: how to return them? Simple execution of Clear Formats will not always work.

In particular, we are talking about Excel 2007, but I believe that all versions do this.

Any ideas?

Thanks Ryan

Answer 1

If you are trying to do this from Excel (and not programmatically), follow these steps:

• In the Orb menu on the ribbon, click the Excel Options button at the bottom of the menu.

• In the list of options on the left, select "Advanced."

• Scroll down until you see the "Display options for this worksheet" heading.

• Check the box next to "Show recommendations."

Answer 2

I had this problem, the grid lines seemed to be missing in some cells.

It was time to realize that the color of these cells was white. I clicked the format cell, pattern, and then selected "no color" (instead of white). The grid lines were visible again.

I hope this helps others, as it took me a while to figure out why.

Answer 3

If you applied a border and / or filled a cell, you need to clear both in order to return to the default borders.

You can use the None parameter as the border parameter and expect the borders to display by default, but this will not happen when the cell is white. It is not immediately obvious that it has a white fill, since unfilled cells are also white.

In this case, apply “No fill” on the cells and you will get the default borders.

What is it. No dirty form, no "Clear Formats", none of these destructive methods. Easy, fast and painless.

Answer 4

Another way: the Page Layout checkbox with the Gridlines []] tab that you want to check.

Answer 5

I had the same problems importing from Excel 2010 into Access by adding an “identical” table. At the beginning of the wizard, he said that not all of my column names were valid, although I checked them. Turns out he saw an “empty” column with no column name. When I tried to use the import wizard to create a new table, it worked. However, I noticed that he added an empty column to the right of my data and named it "Field30". So I went back to the table I was trying to import, selected the columns to the right of the data that I wanted, right-clicked and selected “clear content”. This did the trick, and I was able to import the table by adding it to the table.

Answer 6

My best answer for this is to simply use a layout layout. It can be a little painful, but it works pretty well, since the problem you are facing is that the Gridlines are covered with a bay and other effects that overlap on top. Imagine that there is white paper on the top of your grid, the grid lines are present at the bottom, but they just don't appear.

So try:

• By clicking on a cell in the spreadsheet with the format you need
• Under the ribbons, go to the "Home" section and format the painter, it should be a smaller icon next to the "Insert" button.
• Now select any cell to which you want to apply this format, and set the font, color, background, etc. same as the selected cell. The value will be saved.

From my experience, this is the easiest way to do this quickly. Especially when you put things in and out of excellence.

Again, this is not a software way to solve this problem.

Answer 7

In Excel 2016 for Mac, I clicked on the Excel menu and then clicked "Settings" ...

Then I clicked the View icon.

after which I checked the Gridlines checkbox next to the Color Picker.

Regardless of whether the Gridlines os checkbox is checked or not, if you change the color in the Color Picker drop-down menu, the borders of your cell will become the same. (I believe that the change occurred after I quit Excel and opened the document the next day to continue working on it, but I can’t remember exactly.)

Changing the color selection in automatic mode will return the borders of your cell to the default (black) on the fly.

NB Since I am a beginner, I can’t insert the screenshots that I prepared ahead of time. 😠

Answer 8

you just need to change the color of the line and you can apply it without problems

Answer 9

I understand that this is an old post. But it is programmed. Otherwise, make sure your fill is set to No fill and your borders are set to No Boarder through the user interface shown in previous posts.

Sub clear() Range("A4:G1000").Borders.LineStyle = xlNone Range("A4:G1000").Interior.ColorIndex = xlNone End Sub() 

Answer 10

If anyone else needs a VBA way:

Properties, if you selected something:

 With Selection .interior.pattern = xlNone .Borders(xl<side>).Linestyle = xlNone End Selection 

Where <side> can be, for example, DiagonalDown or EdgeTop , therefore

-> Selection.Borders(xlEdgeTop).Linestyle = xlNone

will reset the top edge.