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.

enter text in Excel

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.

enter text in Excel

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?

Leave a Reply

Your email address will not be published. Required fields are marked *