replace default grids

Topic

New Reply

I have a section that lost the standard grids lines. If I add lines using “format/borders”, the grid lines are different than the default grid lines. How can I replace these grids without deleting the cell themselves?

Reply | Quote

Replies

Skipro,

Try selecting the area where the grid lines are missing.
Right-Click then select: Format cells -> Border
Under Presets click the None box.
Click: OK
37686-Borders
This should reset all the lines leaving just the background grid.
HTH :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Thanks RG but this did not work. The reason I lost the grids is that I color filled the area and that removes the grids. To re-ask the question, how do I color fill and not lose the grids?

Reply | Quote

A fill hides the grid. If you follow Retired Geeks Instructions you can add borders to those cells which will be over the fill and act as a grid.

Steve

Reply | Quote

Skipro,

Try highlighting the cells then press:

Ctrl-Shift-7

Followed by:

Ctrl-Shift-

That should reset it.

Another option would be to use a keyboard shortcut (eg, Ctrl-z) to run a macro that uses the SendKeys method to send the key combinations above. Place in a standard module.

Code:

Public Sub ResetBorders()
    SendKeys “^+7”, False
    SendKeys “^+_”, False
End Sub

On the Developer tab> Macros> select “RestBoarders”> click Options> Enter a “z” (without the quotes)> OK> Cancel. Now Highlight your affected cell and press Ctrl-z

HTH,
Maud

Reply | Quote

Sorry, following RG’s lead.

to put the borders back in place you can use the following combination sequences:

Ctrl-Shift-7
Ctrl-Shift->
Ctrl-Shift-, “, False
SendKeys “^+<", False
SendKeys "^+7", False
End Sub
[/CODE]

Again, set this code to run with the keyboard combo Ctrl-z.

HTH,
Maud

Reply | Quote

Thanks everyone for your input but I did not state my question clearly. I am trying to replace the “default” grid which apparently is not an option in “format/borders”. Is this possible?

Reply | Quote

SkiPro,

As Steve said in post #4 fill hides the grid.
If you want borders similar to the grid in a fill area:
37697-LtGreyGrid
Use these settings:
37698-NewBorders
Otherwise, I for one don’t know what you are asking. HTH :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Skipro,

Although I can’t duplicate it now, I have seen this happen that after performing some function, the gridlines disappear leaving you with a block of white area. It has nothing to do with filling the cells with a color, it seems almost random.

If you go to an unused section of the sheet and copy a range of cells then paste over the missing cells by Right click>Paste Options: Formatting, you should get your borders back. Paste Formatting will not paste over your data just the formatting

Maud

Reply | Quote