How to split a table into two with a slash and enter text in Excel. When we make tables in Excel, sometimes we need to enter two kinds of data in one table, so what should we do? The editor will share with you how to divide an Excel table into two with a slash and enter two types of text.
1. Click to select the cell to be divided into two diagonal lines.
2. Right-click the mouse and click “Format Cells”.
3. Click the “Border” function.
4. In the border settings, select the last slash border, you can see the preview effect above, click “OK”.
5. The cell is set to be divided into two slashes
6. Enter the two texts we want, use Alt+Enter key to wrap, and then use spaces to adjust the position.
How to convert numbers into normal numbers in Excel?
select your cell
Enter the excel software interface, press your left mouse button to select the number cell you want to change.
Click the triangle
Click the Start tab in each function tab above, click the triangle symbol on the right of the cell format below, and a drop-down menu will pop up.
Click on the text option
Click the last text option in the drop-down menu, go back to the cell interface, and double-click the cell with the left mouse button to change the table numbers into normal numbers.
Select the cell to be changed
Enter the excel software interface, press your left mouse button to select the number cell you want to change.
press single quote
Gently press the quotation mark button on your computer keyboard, a single quotation mark will pop up, and then press your left mouse button and click the blank space to make the number normal.
custom settings
select number cells
Enter the excel program interface, select the number cell you want to change, and press the right mouse button to pop up a shortcut menu.
Click on custom options
Click the Format Cells option inside, and then click the last custom option in the left navigation bar.
Click the OK button
Enter the number 0 in the information box in the middle, click the OK button, and then drag the cell to the appropriate length to see the normal number.
right click settings
select your number cell
Enter the excel software interface, press your left mouse button to select the number cell you want to change, and then press your right mouse button to pop up the shortcut settings menu.
Click to format cells
Click the Format Cells option in the shortcut settings menu to enter the cell settings interface.
Click the OK button
In the navigation bar on the left, click the value option, and then click the OK button below to return to the cell interface, and drag the cell to the appropriate length to make the number normal.
In the navigation bar on the left, click the value option, and then click the OK button below to return to the cell interface, and drag the cell to the appropriate length to make the number normal.
How to drop down numbers in excel sheet?
In the excel table, you can achieve incremental filling by setting the sequence fill, and set the table to fill in the arithmetic sequence to complete the drop-down number increment.
selected area
Select the area to be filled in the table.
Click Sequence Fill
Click Fill in the upper toolbar and select Sequence Fill.
set value
Select the arithmetic sequence, set the step value to 1, and click OK.
complete filling
The incrementing sequence is filled.
Recommended reading:
Which is the latest version of FM WhatsApp?
How can you tell if someone is pretending you’re offline on Fouad WhatsApp?