HOW TO IMPLEMENT SUCH A FEATURE IN EXCEL 10

You can do it without a VBA:

Point first"tools"->"option"->"Recalculate", selected"Automatic recalculation"with"Iterative calculations", will"Maximum number of iterations"Set to 1 and enter the formula: in cell b1

if((cell("row")=1)*(cell("col")=1),a1+b1,b1)

When this is set, the values entered in A1 will automatically accumulate in the B1 cell, and the values in the B1 cells will not change when the values are entered in other cells.

This one. Do you use VBA?

Open Tools-Macro-VB.

Double-click on sheet1 on the left to open its ** window and enter in it:

private sub worksheet_change(byval target as range)

if = 1 and = 1 thentarget(1, 2) = target(1, 2) +target(1, 1)

end if

end sub

You can achieve the effect you want.

Also, let's say A1 is 32 now, if you double-click A1 and you're going to change it, and then suddenly you don't want to change it. You can't press enter, otherwise b1 will still add a 32...To press esc...

Let's use circular references.

Tools option, Recalculate, check Iteration Calculation, Maximum number of iterations, enter 1b1=a1+b1

If there is an error in the input of A1, for example, if you have entered the wrong value of 20, press esc to cancel before pressing Enter to confirm, if it has been confirmed, to clear this value, just enter -20 in A1 and press Enter to confirm.

1. Data analysis and powerful computing functions.

2. Graphical data is clear and obvious.

3. Pivot table Data classification statistics are simple and clear.

4. Automated office VBA

There are too many waits, in a word, as long as you want to do it, you can basically achieve it.

It's very simple to do this, it's just a lot of content, so I'll just talk about how to do it:

First of all, according to the diagram you showed me, this table only uses 4 of the controls in excel (group box, option button, combo box and command button), I will explain it to you as follows:

First, right-click on the blank space on the right side of the Excel column, and left-click on the "form" to pop up the form toolbar.

1) Group boxes.

The group box is used with the option button, there is a group box icon in the form toolbar just now, click once, and then drag and drop a square on ** to create a group box (the following is the same), then right-click the group box, click "Text" to change the name of the group box to "gender" (as in your figure).

2) Options button.

Use the same method to create an option button, but this time you have to drag and drop it inside the quad box of the group box, so that the group box and the top button are related to each other, and then drag and drop an option button in the combination box in the same way (more than two must be meaningful), the same method as the first one. After creating the option button, right-click it, click "Format Control" under "Color and Line" to set the background color line, etc., under "Web" you can change the button content (such as "Male", "Female"), fill in "$a$1" in the "Cell Connection" under "Control", or click the icon on the right, and then click on the A1 cell, and finally click OK, first click the blank space to make the option button return to the normal state, try to click the two option buttons alternately, you will see that A1 will be displayed alternately"1", "2", which is different when the value is not selected.

3) Combo box.

After the same combination box is created, right-click the combination box, click "Set Control Format", set B1 to B4 as the data source in the same way in the "Data Source Area" under "Control", and set C1 as the reverse address in the "Cell Connection", and then "OK", fill in the words in each of the 4 cells from B1 to B4 (write a few words at will), okay, now click the drop-down arrow of the combination box to see, the content of B1 to B4 is displayed in the drop-down table, and the C1 reverse return value is different if you choose differently.

4) Command button.

Well, the method is done in this way, it is difficult to explain clearly here, see the cool! Below is a reference diagram, I hope you can learn it!

I originally made a gif animation, but I can't show it here.

Add me to teach you 21888841

Hi I'll send me a similar ** to my mailbox, and I'll do it for you.

Hehe, learn this from the beginning...

The method is to set the F1 cell first, and after setting it, copy the cell and paste the format selectively downward.

The values of the first two directly select cells, greater than -15 and less than 15, and then set the color (in the format) according to the figure.

The third one is the formula and enter: =and(f1<>"", f1<=15, f1>=-15), and finally set the format.

Basically, the same as heping956 downstairs, you can do it with conditional formatting, and you don't need to choose a formula for the third, you only need to select the "greater than", "less than" option as "between", between -15 and 15. Set the format yourself.

This result is a blank grid, which will also change to a gray bottom, but if you use a formula like heping956, then if the data is really 0, it will not become a gray bottom.

Select this column of data first, set the font to black, and set the fill to gray.

Then click Format --- Conditional formatting.

In the dialog box, set as follows, and then OK.

The normal version of Excel is relatively weak for text processing, and there are only two ways to achieve this purpose: one is to add punctuation to auxiliary columns, and the other is VBA. The 365 version of Office can be easily implemented using the Super Text Connect function.

Here's how to add punctuation to a hypertext function and a helper column

b1=textjoin("、",1,b2:b5).

2. How to add punctuation to auxiliary columns:

In the blank column on the right side of the data, press even number (it can also be odd number - as long as there is an interval number), when there are few data rows, you can enter it directly, and when there are many data rows, enter two and fill it; In the blank line below, press Odd (if the preceding is an odd number, here it is an even number - corresponds to the previous number).

2.Sort by auxiliary columns to interlace the original data with blank rows.

3.Add punctuation points to the blank cells in the sorted data, drag and drop to select the data area, press Ctrl+G, click "Positioning Condition", and select "Null Value" to select all blank cells. Enter the punctuation marks, here is the tonnage (,) press Ctrl+Enter, and enter the tonnage in all blank cells.

4.Concatenate text, b1=phonetic(b2:b8).

The right-pull VBA method will not be introduced.

excel such as Zen orange what limb to rent He hunger group is good?

The function of the poor Feng accompanied the tutorial stupid she came to shout.