Charlotte has attended:
PowerPoint Intermediate Advanced course
PowerPoint Introduction course
Excel
Is there a way to divide an excel cell diagonally in Excel and fill with different colours?
RE: To divide an Excel cell diagonally
Hi Charlotte
You can change the formatting for a cell in many different ways and make it look like it has been divided diagonally
To divide an Excel cell diagonally, you can follow these steps
Select the cell you want to divide.
Right-click on the cell, and select Format Cells.
In the Format Cells window, go to the Border tab.
In the Border tab, under Presets, click None.
Now, under Border, click the diagonal border button that goes from the bottom-left to the top-right or from the top-left to the bottom-right, depending on your preference.
Click OK to close the Format Cells window.
Please note that this will only visually divide the cell. It won’t actually create two separate cells or allow you to enter data into each half separately. If you need to enter data into two separate areas within one cell, you might consider entering the first piece of data, pressing Alt + Enter to start a new line in the same cell, and then entering the second piece of data. This won’t be a diagonal division, but it will allow you to separate your data.
Kind regards
Richard
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
