Now insert a triangle-shaped object in that box by choosing the Shapes option under the Insert tab while pressing the Alt on the keyboard. Before doing the same steps above, make the height and width of the targeted cell larger by dragging it and set the alignment of the 1 st word on top.
Let’s do the same thing briefly by inserting a box for a better view. This is how you can split a single cell diagonally. By this, you will get to see the words aligned diagonally in a single cell. Now for aligning the words perfectly put some extra space between your words. Select the Superscript option under Effect and choose the font size and style you want and then press OK.įollowing the same procedure select the second word and under the Effect, bar click on the Subscript option and then press OK. A new dialogue box of Format Cells option will come up which will only highlight the fonts. Now for adjusting the positions of the words, select the first word “Up” and click on the drop-down option of Font under the Home tab. You will see a diagonal line has appeared. Under the Format Cells dialogue box, click on the Border option and then select the diagonal border and press OK. To begin the operation, 1 st select that targeted cell and click on the right button of your mouse to select the Format Cells option. You wish to split that two words diagonally in a single cell. Suppose you have a single cell where two words are written. How to Split a Single Cell Diagonally in Excelįor splitting a single cell diagonally, you need to get the help of the format cells option. All you can do is select the merged cells together and click on the Unmerge Cells option on top.
There is an easy way to unmerged/split these cells. While working on an imported excel file, you may find that some of the cells of your imported spreadsheet are merged together. Related Readings Splitting Cells by Using the Unmerge Cells Option in Excel
0 kommentar(er)
