"Automatic" Border Coloring Overwritten

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • I have several excel sheets in a workbook where the "automatic" (that is, the default) border coloring has somehow been overwritten from the usual black to a pale gray. When I'm selecting border colors it still shows Automatic as being black, but the linetypes and the borders themselves are this annoying (and useless) gray.

    I know that this is a property inherent to the worksheet and not the workbook because I can insert a new worksheet, Ctrl-A and copy everything in the original worksheet, and paste it all into the new worksheet and the Automatic border color will be black, as it should be. I'd rather not copy-paste each worksheet into new worksheets if I don't have to because I've got macros and print settings customized for each sheet and those don't get picked up by Ctrl-A.

    Does anyone know where/how I can reset this "Automatic" Line Color back to the original black for these worksheets? Thanks ahead of time.


  • Re: "Automatic" Border Coloring Overwritten

    Hi Phlu,
    Maybe under |Tools |Options |View |Gridlines Color?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!