98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Powerpoint Training and help » Excel
Excel
Resolved · Low Priority · Version 365
Charlotte has attended:
PowerPoint Introduction course
PowerPoint Intermediate Advanced 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
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
PowerPoint tip:Coping slides quicklyRather than using insert / files, have both presentations open. |