In Excel, how to enter one cell and then the other is automatically displayed at the same time?

It's very simple. Method 1: 1. Select the F12 cell in sheet2 and press "=".

2. Press sheet1 (the label of the table).

3. Press the F12 cell in sheet1 again, and then press the enter key and it's OK.

It should be displayed in the formula bar.

sheet1!f12

Method 2: Enter the formula =sheet1!. in F12 in Table 2f12: If you still want to make F13 in sheet2 equal to F13 in sheet1, pull the fill handle and so on.

If you want to use the date to represent the last time, you can use the now function and the data validity.

to do it. 1. Enter the formula =now() in any cell, this example uses cell i1.

2. Create an auxiliary column in the blank column of the data edge to set the data validity. The method is: select the column, click Data - Data Validation, in the setting command, allow the condition to select the sequence, ** is equal to i1, and click OK to set up.

3. After entering the data, click on the auxiliary column with the mouse to record the current time, and it will not change. The now function and the today function are volatile functions, and every time you open the worksheet, it will automatically change with the system time of the computer, so that the setting will not have this problem, and it is a good way to record the last time.

As shown in the figure below: Suppose the state of matter of the input content in the D3 single-cover imitation source element grid, and display it in F3 by the following method:

Select cell F3 and enter "=d3"."Can.

It's a basic cell reference that can be wild. For example, if you enter the formula = A1 in cell E1, you will enter the content in cell A1 and it will be displayed in cell E1.

This is the main reference to the cell. For example, in cell E1, type the formula =A1 to enter the contents of cell A1 and display it in Single Argument Cell Closed E1 at the same time.

In excel, after entering the content of one cell, the other will be automatically displayed at the same time, and the specific operation steps are as follows:

First, the first step, open Excel, and then select a cell such as C4, click Data - Data Validity.

This is shown in the figure below.

Second, the second step, the next pop-up box, and then select the sequence below the beam accompaniment, and then fill in the required selection content above **, separated by a lowercase comma (,), such as yellow, red, green, blue, as shown in the figure below.

3. In the third step, fill in the colors and things on the F and G columns respectively, and they should correspond to the left and right one by one, as shown in the figure below.

4. Step 4, fill in the formula (e.g. d4) on the cell you need to transform: =vlookup($c$4,$f:$g,2,0), and press enter.

This is shown in the figure below.

5. The fifth step is to select the color in C4, and then the corresponding thing will be automatically displayed in D4, as shown in the figure below.

Sixth, the sixth step, complete the rendering, as shown in the figure below.

In Excel, hold down the Ctrl key on the keyboard, click the left mouse button at the same time to select the cells you want to enter the same content, and then enter the content you want to display, and then press the Ctrl+Enter key to enter the same content in multiple cells in Excel at one time. For details, see the following steps.

1. Open the required excel** file on the computer and enter the main interface.

2. Hold down the Ctrl key on your keyboard and click the left mouse button to select the cell you want to enter the same content.

3. Enter the content to be entered directly in the end of the cell, do not have other operations, just enter directly.

4. After all the contents are entered into one cell, press the Ctrl+Enter key to see that the selected cells have become the same content.

5. After completing the above operations, you can enter the same content in multiple cells in excel at one time, and finally save the other content after completing the entire content.

1. Open Excel, select a cell such as C4, and click Data - Data Validity.

2. Pop up the box, select the sequence under Allow, fill in the required selection content above, separated by a lowercase comma (,), such as yellow, red, green, blue, <>

3. Fill in the colors and things on the F and G columns, and to correspond to the left and right, <> 4, and then fill in the formula (for example, d4) on the cells you need to transform: =vlookup($c$4,$f:$g,2,0), press the enter key.

5. Then select the color in C4, and the corresponding thing will be automatically displayed in D4, <> 6, complete the rendering.

I guess you're aligning - horizontal alignment, set it to padding, just change it to normal.

Select the cell, press Ctrl+1, the "Format Cell" window will pop up, and look at the cell settings in "Numbers".

View, cancel the column.

Select the cell.

Right-click to format the cells.

Alignment. Set.

Horizontal each other way, select Fill.

Are you sure. If column A is not allowed to be repeated, then select column A and set the data - validity - custom: formula input:

countif(a:a,a1)=1

Suppose you enter 1234 in A1 and 1234 in A2, you will be prompted that the value is invalid.

Select these cell ranges--- right-click --- set the cell format --- change"Text"for"General"Are you sure.

Then double-click to enter each formula cell enter.

Use "Data Validity".

Steps:1Select the range of cells you want to add to the options.

2.Execute the "Data Validity" action to open the "Validity" dialog block.

3.Under the Settings tab, select Sequence in the Allow field, enter Male and Female (without quotation marks, separated by a half-comma in the ** field), select Ignore Null Values and Provide Drop-down Arrows, and click OK (if you do not provide a drop-down arrow, you can't select it).

At this time, click the mouse in the selected cell area, a drop-down button will appear on the right side of the cell, click the drop-down button to open the list box to select the option input. When entering an item outside the list (only [male] or [female] can be entered here), the system will automatically send a warning.

With this example, you can draw inferences about other restrictions.

It may be that the formula sets the protection, it is all hidden, the tool, the protection, the revocation of the protection is fine.

Here's how excel restricts cells to only n or y inputs:

1. Open the excel file to be processed, 2. Click on the information in the menu.

3. Effectiveness in the menu toolbar, select Settings in the pop-up window, Allow (sequence), 4. Enter n,y in the ** box, 5. Click the OK button.

It should be noted that the comma between n and y must be a half-shaped comma.