When you look at a spreadsheet with dozens of rows and columns and hundreds of cells full of numbers, it’s hard to understand everything on the screen.
Colouring cells in Excel helps our group information, or highlight it. We can paint the headers of a table or list of colour and its content with a different one, and it will help us identify everything at a glance.
Similarly, painting the cells of a table or list improves the presentation, if we have to give it to someone as part of a project or an academic or professional work. It’s a very simple task, and at the same time, it’s fun.
In this office tutorial, we explain how to colour Excel cells.
To colour cells in Excel, any version of the application is useful, even the free Excel Online. Only if you want to use custom colours you need a paid version.
Start Excel and open a spreadsheet, or write some data in the cells. Letters and words, as well as numbers, work. For example, you can create a list of expenses including rent, electricity, heating, etc.
Click a cell with your mouse or finger cursor and drag over the cells to select all the ones you want to colour. It can be a single cell, a row, a complete table, etc. For example, we are going to paint the headers of the previous table green, and its contents purple. So drag on the header. The cells will turn grey.
Click on the Home tab and touch the arrow to the right of the Fill Color icon.
Choose a colour, and the selected cells will be painted with that colour. Now select the cells in the table, and paint them with a different one. You can do this in several steps if you want.
The black letters on the purple background don’t look very good, so let’s use the Font Color icon to the right of the previous one to paint the letters with a light colour. To do this click on the arrow to the right of Font colour, to select the colour.
If you want to use custom colours, you must use a paid Excel version. By clicking on the arrow of the Fill Color icon, in the menu that opens there is an extra option called More Colors.
When you click on it, a new menu has the Custom tab, which allows you to select new colours and change their hue by moving the vertical bar. You can also write the RGB code with the exact colour you want.