Excel

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