How to change in excel default grey colour in rows [ 1,2,3..] and columns [A,B,C..]

Question

Hello, In excel am unable to change the default grey colour in rows [ 1,2,3..] and columns [A,B,C..] , by default with grey colour gets highlighted in that particular row & column head, once clicked on any cell . I want to change that default grey colour. Reason why want to change any data modifications while handling large amount of data occupied in sheets, its really difficult which row or column am changing the values .

Answer 1

Hi Venu _G_R

Thanks for posting the thread on our forum.

According to your description, it seems that you want to change the default grey color in rows and columns in Excel.

May I know if my understanding is correct? If so, you can follow the below steps to do that:

Open a Excel sheet>selected the rows or columns you want to change their colors>right click >Format cells>Fill effects>under colors bar, click the color 2 to choose what color you want to use >click OK>OK. > then you can see the rows and columns changed the color to what you want as the screenshot below:

If my understanding is incorrect, please feel free to post back we'll continue to help you in anytime.

Best regards,

Stacey

Answer 2

Hi Stacey,

Thanks for your quick response, am not looking for colour change in cells, its in row & column heads like row - 1,2,3.. & columns A,B,C.. In below image look at the row & column header ie "D" column and row "5" [not the cell] which background got highlighted with grey shade, that i want to change it to different colour. As understood it was available in previous versions of excel, but in MS Office 365 [excel] not available.

Answer 3

colour change in row & column heads like row - 1,2,3.. & columns A,B,C..

In below image look at the row & column header ie "D" column and row "5" [not the cell] which background got highlighted with grey shade, that i want to change it to different colour. As understood it was available in previous versions of excel, but in MS Office 365 [excel] not available.

The grey color is part of the application color scheme. I don't recall being able to change that in earlier versions of Office.

.

You can change it in Windows, by picking a different "Windows Theme". In earlier versions of Windows, that was something we could do, change individual settings. But that is one of many Windows user control settings / features that MS has (dis)"improved" out of recent versions of Windows. In the past we could also create custom "Windows themes". I don't know if that is still possible.

.

There are some DIY fixes for this problem

Highlight the Active Cell, Row, or Column

https://docs.microsoft.com/en-us/office/vba/excel/concepts/cells-and-ranges/highlight-the-active-cell-row-or-column

09/13/2021

The following code examples show ways to highlight the active cell or the rows and columns that contain the active cell. These examples use the SelectionChange event of the Worksheet object.

Excel tricks to highlight selected row, column, heading and more

https://office-watch.com/2019/excel-tricks-to-highlight-selected-row-column-heading-and-more/

3 December 2019

You can make it easier to see your current place in a workbook by dynamically highlighting the selected row, column, cell or headings. Here’s obvious and more subtle highlighting options plus the downside of highlighting, real world tips and

debugging tricks if you’re having trouble.

.

How to auto-highlight row and column of active cell in Excel?

https://www.extendoffice.com/documents/excel/1494-excel-highlight-active-row-and-column.html

When you view a large worksheet with numerous data, you may want to highlight the selected cell’ row and column so that you can easily and intuitively read the data to avoid misreading them. Here, I can introduce you some interesting tricks to highlight the row and column of the current cell, when the cell is changed, the column and row of the new cell are highlighted automatically as following screenshots:

.

How to highlight active row and column in Excel

https://www.ablebits.com/office-addins-blog/highlight-active-row-column-excel/

by Svetlana Cheusheva | updated on December 28, 2021

In this tutorial, you will learn 3 different ways to dynamically highlight the row and column of a selected cell in Excel.

When viewing a large worksheet for a long time, you may eventually lose track of where your cursor is and which data you are looking at. To know exactly where you are at any moment, get Excel to automatically highlight the active row and column for you! Naturally, the highlighting should be dynamic and change every time you select another cell. Essentially, this is what we are aiming to achieve:

Answer 4

Hi Venu _G_R

Thank you for coming back to forum. We also appreciate that you provide the very detailed screenshot.

Sorry for my misunderstanding and inconvenience caused to you.

We searched and test many times about your requirement, but I'm sorry to tell you that we can' t find any solution can change it.

As rohnski2 mentioned, you can try the suggestions he provided in his reply to see if they can meet your requirements.

Meanwhile, we kindly suggest you to send feed back about it by Excel · Community (microsoft.com) to share your ideas and help us hear your voice to improve our product better.

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Regards,

Stacey

Answer 5

Hi Stacey , Rohnski2

Sorry for late reply from my end as got stuck up in other key things.. Thanks for your help and understanding about the issue & addressing the same in quickly time.

As suggested KuTool is helping out in resolving my issue, am using as of now. Only hassle is some times excel application getting hung up with enabling the KuTool options, otherwise its fine.

Thanks a lot for your help :-) Am expecting Microsoft will help in future in enabling such option in excel application itself.

Thanks & Regards.

Venu