current location:Home > Technical Articles > Other
- Direction:
- All web3.0 Backend Development Web Front-end Database Operation and Maintenance Development Tools PHP Framework Daily Programming WeChat Applet Common Problem Other Tech CMS Tutorial Java System Tutorial Computer Tutorials Hardware Tutorial Mobile Tutorial Software Tutorial Mobile Game Tutorial
- Classify:
-
- How to extract specified fields in excel
- Method: First select "Formula" on the top toolbar and click "Insert Function"; then enter "left" in the "Find Function" input box and select "OK"; then enter the characters to be extracted in the "String" text box Cell name, enter the number to be extracted in the "Number of Characters" text box; finally click "OK".
- excel 31276 2021-04-26 11:33:57
-
- How to make a word header
- How to make a word header: first insert a "1*1" table into the word document; then click "File" on the top navigation bar and select "Table" in the drop-down list; then select "Draw Slash Header" ;Finally, select the appropriate type in "Slash Cell Type" and click "OK".
- word 33900 2023-01-13 00:43:40
-
- How to clear cell format
- How to clear cell formats: First select the cells whose formats need to be cleared; then click "Start" on the top navigation bar, select "Edit", find and click the "Clear" button; finally select "Clear Format" in the pop-up drop-down list "That's it.
- excel 83890 2023-01-13 00:42:09
-
- How to replace all NA with 0 in excel
- Replacement method: 1. Open the excel document; 2. Select all the NA cells that need to be replaced; 3. Enter the formula "=if(iserror(original formula),0,original formula)" in the edit bar; 4. Press "ctrl+ Press the "Enter key" command to replace all "#N/A" symbols with 0.
- excel 61688 2023-01-13 00:42:08
-
- How to add captions to all pictures at once in word
- Method: First click "Insert "-" Picture" at the top of the page to insert the required picture; then select the picture, right-click, select the "Insert Caption" option, and select "New Label" in the pop-up window; then click on "Tag" "Enter the label content in the text box and click "OK"; finally modify the position according to your needs and click the "OK" button.
- word 29704 2023-01-13 00:43:40
-
- How to delete specified page in word
- Method: First open the document, use the shortcut key "ctrl+g" to enter the "Locate" interface in "Find and Replace"; then select "Page" in the "Locate target" drop-down list, and enter the required page number in "Enter page number" Page number, click "Locate"; then select all the text or spaces in the page number; finally press the "delete" key to delete the content.
- word 24306 2023-01-13 00:43:40
-
- How to keep row height and column width in excel for pasting
- Method: First open the excel table, select the entire table starting from the first row of the table, and copy the data; then paste the table to the specified location; finally, click the inverted triangle button in the "Paste" option on the left side of the data, and click on the drop-down list Select "Keep original column width".
- excel 38243 2023-01-13 00:42:08
-
- Why does the ID number change when I enter it in the form?
- When entering the ID card number in the form, it will change because the input content becomes a scientific numerical recording method. The solution: first enter the WPS form, select the data that needs to be set; then right-click the mouse and click Set Unit in the options. grid format; finally click on the text below the category.
- excel 92645 2023-01-13 00:42:08
-
- How to change the background color of a word document
- How to change the base color of a word document: First open the word document, select the "Page Layout" option in the top menu bar; then select "Page Color" in the "Page Layout" option; finally select a standard color as needed.
- word 28724 2021-04-25 15:21:48
-
- How to remove the dotted box in excel
- The method to remove the dotted frame in Excel is: first open Excel, switch to the [Page Layout] column; then click [Print Area], [Cancel Print Area]; finally click [Office Button], [Excel Options], [Advanced] ] and uncheck [Show page breaks].
- excel 46818 2023-01-13 00:42:08
-
- How to split cells in word
- How to split cells in Word: First open a word document containing a table, select the cells that need to be split; then right-click and select the "Split Cells" option; then enter the "Number of Columns" for "Split Cells" and "Number of Rows"; finally click the "OK" button.
- word 17761 2021-04-27 15:08:32
-
- How to convert txt document into excel table
- Conversion method: 1. Create a new excel document and open it; 2. Click "Data" - "From Text"; 3. In the pop-up window, select the txt file that needs to be converted and click "Import"; 4. In the pop-up window, Check the "Delimiter" item and click "Next"; 5. In the "Delimiter", check the options as needed and click "Next" - "Finish".
- excel 142060 2022-01-12 15:04:27
-
- How to add a column to word table
- How to add a column to a word table: first open the word document and click "Insert" on the menu bar; then click on the table, select the number of rows and columns, and insert a table; finally, right-click the cell where you want to insert a column above or below it, and click "Insert" That’s it.
- word 88852 2023-01-13 00:43:40
-
- How to set inside and outside margins
- Method: First click "Margins" in the "Page Layout" option of the document, and select "Custom Margins" in the drop-down option; then select the "Multiple Pages" option in "Custom Margins" and click " Symmetrical Margins"; then adjust the values of "Inside" and "Outside"; and finally click "OK".
- word 13863 2021-04-25 10:04:06
-
- How to filter red marks with a score below 60 in excel
- Method: 1. Open the excel table that needs to be operated, select the cells that need to be marked, and select "Conditional Formatting" in the "Home" tab; 2. Click "Highlight Cell Rules" and select "Less Than"; 3. Enter "60" in the "Less than" input box, and select "Red Text" in the "Set as" option; 4. Click the "OK" button.
- excel 50668 2023-01-13 00:42:08