Another efficient method to do the same is by using the method of drag and drop. Whenever we type something in a cell in excel, we can always cut it from one place to another by first right clicking on the cell and pressing on cut, and then pasting it in some other cell.
Moving and Copying Data To and From Cells. One catch here is that we’ll need to take care of the alignment of our text above and below the diagonal line using spacebar.ģ. To add text above and below the diagonal line, we’ll need to enter something in the cell and then press Alt+Enter to take it to the next line, and then type something else in the second line that we need to have below our diagonal line. Pressing ok after selecting the diagonal line as the border style will create a diagonal line in the cell that we intended to put our diagonal line in.