WPS Word questions, see Question Supplement 100 for details

sub macro1()

dim nations as variant

nations = array("american", "china", "british", "Germany", "Russia")

commandbars("forms").visible = true

range:=, type:=wdfieldformdropdown

withname = "dropdown1"

for i = 0 to ubound(nations)

with .

add name:=nations(i)

end with

nextend with

end sub

Wrote a vba to compile through, where nations are arrays that store country names, and data can be added according to your needs.

To use it, click the "Tools-Macro-Visual Basic" tool, "Insert-Module", paste **into the VB** device, select the cell you want to add the form field, and then run this paragraph**.

This, it seems that there is no shortcut, only one by one, one by one.

Summary. If you have the problem that the carriage return is blank after entering the formula when using the wps formulator, you can try the following methods to solve the problem: confirm whether the text box of the formulator is large enough.

If the text box is too small, it will cause the problem of blank carriage return after the formula is entered. You can try increasing the size of the text box, or reducing the size of the formula font. Check if there are unnecessary spaces in the formula.

In some cases, extra spaces included in formulas can also cause the issue of blank carriage returns. You can try removing extra whitespace, or adjusting the spacing and alignment between the individual elements in the formula. Upgrade or reinstall WPS.

In some older versions of WPS, there are certain bugs and problems with the formulator, and there may be a blank carriage return. Upgrading to a newer version of WPS, or reinstalling the latest version of WPS, can resolve these issues. Use a different formulator.

If none of the above methods solve the problem, you can try to use other formulators, such as Latex, Mathtype, etc., which have more complete formula input and typesetting functions to better meet the needs of users.

Hello, what is the specific problem, you can tell me the specific problem and requirements.

What do you mean? After using the formulator, there is a blank carriage return, and it is useless to change the line spacing.

If you have the problem that the carriage return is blank after entering the formula when using the wps formulator, you can try the following methods to solve the problem: confirm whether the text box of the formulator is large enough. If the text box is too small, it will cause the problem of blank carriage return after the formula is entered.

You can try increasing the size of the text box, or reducing the size of the formula font. Check if the formula contains unnecessary spaces in front of the sting. In some cases, extra spaces included in formulas can also cause the issue of blank carriage returns.

You can try removing extra whitespace, or adjusting the spacing and alignment between the individual elements in the formula. Upgrade or reinstall WPS. In some older versions of WPS, there are certain bugs and problems with the formulator, and there may be a blank carriage return.

Upgrading to a newer version of WPS, or reinstalling the latest version of WPS, can resolve these issues. Use a different formulator. If none of the above methods can solve the problem, Lao Peiqing can try to use other formulators, such as Latex, Mathtype and other programs, which have more complete formula input and typesetting functions, which can better meet the needs of users.

Hello, glad to answer for you!

1. In the background, you can use the drawing software to add the grooming style on the left side to ensure that this style is integrated with the **; You can also insert a **-shaped text box and move it to a suitable position;

2. Insert **, set the vertical border for **, and set the horizontal border to none;

3. The text border line can be set to the same color as the background color, so that it can visually present a non-existent style.

WPS members enjoy the office, one-to-one VIP professional services, details: ?from=qy

1.The book-loading line can be made first and pasted to the corresponding position.

2.Insert 1 vertical text box. Enter text. Double-click the text box and adjust the line color to the wireless bar color or white.

3.Insert the Shape Line and drag it to the appropriate position.

4.Refer to the second.

Does it mean the yellow undertone in the second row? If so, there are two possible caves:

1. Select the Chinese character Napi, click to highlight and select no guess bend.

<>2. Select Chinese words, click on the border and shading.

<> pay attention to the scope of application.

1. Delete the blank line at the bottom of the second page, and move the lower ** line up.

2. If it hasn't been called back, select the text of this cell, and set the line spacing to a fixed value and a little smaller in the beginning - paragraph. (You can also delete a little less text) and then move the lower ** line up.

3. In the page settings, appropriately adjust the upper and lower margins.

Make a new ** like this yourself, and it's normal to copy the content into it. I've encountered this problem before, and I can't explain why.

Question 1: If a number with a decimal is involved in the operation, the result will of course be a decimal. You can take a few decimal places if you need a few decimal places, either by setting the number in the cell format to determine the number of decimal places, or by using round to take how many decimal places.

The former method only changes the display, and the internal data is still a floating-point number with multiple decimal places, while the latter method really intercepts the required number of digits.

Question 2: The trouble is self-inflicted, the sum of excel, or the operation of the operator can only calculate the number, you now add a good end of a number in the K column to add a master "20", it can be said that it is completely a snake to add a snake! The data in column k has been indicated in the title is (m2) 20cn, and then add a "20" to the number below, what is the point?

Mixing numbers and text in the same cell is really taboo in Excel! Not only is it pointless, but it also adds to the trouble of data processing.

Of course, if you insist on adding this snake foot to column K, then find a way to remove the snake foot when summing it:

k11=-sum(-left(k5:k10,len(k5:k10)-3))

Press the Ctrl+Shift+Enter keys at the same time to enter the array formula.

Circular reference refers to the direct or indirect reference to oneself in an excel formula, such as the following formula C10 = Sum(C6:C10).

The sum set in c10 includes its own cell.

How can I quickly find the address of a formula that is referenced in a circular manner?

Workaround: Check and fix the incorrect references in the formula.

Refer to: Circular Reference Warning: One or more formulas may not be calculated correctly.

Hello, glad to answer for you!

Please check the file size, if the file is too small, your document is likely to have been corrupted, the more common reasons are:

1. Often document directly on U disk and other media;

3. The working document has been closed due to violence.

You can try to restore it on your original computer by using the following methods:

1. Click the "WPS Text ** Presentation" button in the upper left corner of the program and select "Backup Management"; You can also try the "View Other Backups" feature below on the right side if you want;

2. Click "Start-Run" and enter "%temp%" in the box to find the system temporary file directory to try.

Win a Mi Box.