How do I change the automatic border color back to black in Excel?

Question

I took over a position where most of the files that I use have been created by someone else, a lot of them years ago. In some files the automatic border color is grey and it's getting tedious to go and change the border color to black. I have no idea how the automatic border color changed, but I need to turn it back. I tried using the Microsoft help, but they were going in the wrong direction. Can anyone provide me with some assistance please?

Right now the automatic border color is grey.

Answer 1

Run this macro and tweak accordngly.
Sub Changebordercolors()
Dim cell
For Each cell In Selection.Cells
If cell.Borders(xlEdgeTop).ColorIndex <> -4142 Then
cell.Borders(xlEdgeTop).ColorIndex = vbBlack
End If
If cell.Borders(xlEdgeBottom).ColorIndex <> -4142 Then
cell.Borders(xlEdgeBottom).ColorIndex = vbBlack
End If
If cell.Borders(xlEdgeLeft).ColorIndex <> -4142 Then
cell.Borders(xlEdgeLeft).ColorIndex = vbBlack
End If
Next
End Sub

Answer 2

If as you assert you opt for a White border round your documents - then choose the Column/s outdoors your documents and use Fill command - white Repeat for Rows above and below documents then use choose Print section to contain the factors you've filled - then use Print Preview - web page Setup - Margins to Centralise documents Vertically and or Horizontally as you want. HTH