ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   HOW DO I CHANGE THE AUTOMATIC BORDER COLOR IN EXCEL? (https://www.excelbanter.com/excel-worksheet-functions/17930-how-do-i-change-automatic-border-color-excel.html)

mhbento

HOW DO I CHANGE THE AUTOMATIC BORDER COLOR IN EXCEL?
 
In Excel, under Format/cells/border - the automatic color indicates "black";
however, in the "Style" preview box all items displayed are in Grey. I have
to go into the color drop down menu and click on "black" each time.

How can I correct this?

mhbento

Andrew


I'm not 100% on what your after
but if you select the cells you want
then go to
FORMATCELLSBORDER
Select the color you want "black"
the select from 'presets' (still in Border option)
'Outline' and 'Inside' it will alter the border colour to black

Hope this helps


--
Andrew


All times are GMT +1. The time now is 11:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com