Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Powerpoint Training and help » Excel


resolvedResolved · Low Priority · Version 365

Charlotte has attended:
PowerPoint Introduction course
PowerPoint Intermediate Advanced course


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


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


Training courses


Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


PowerPoint tip:

Coping slides quickly

Rather than using insert / files, have both presentations open.
1. Windows / arrange all
2. In the Slide view drag the slide you want to copy, and drop it in the other slide view.
3. Then use the smart tag to decide if you keep the formatting.

View all PowerPoint hints and tips

Server loaded in 0.07 secs.

✓ w3speedster