current location:Home > Technical Articles > Other

  • How to extract specified fields in excel
    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
    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 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
    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
    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
    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
    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?
    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 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
    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
    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
    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 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
    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
    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

Tool Recommendations

jQuery enterprise message form contact code

jQuery enterprise message form contact code is a simple and practical enterprise message form and contact us introduction page code.
form button
2024-02-29

HTML5 MP3 music box playback effects

HTML5 MP3 music box playback special effect is an mp3 music player based on HTML5 css3 to create cute music box emoticons and click the switch button.

HTML5 cool particle animation navigation menu special effects

HTML5 cool particle animation navigation menu special effect is a special effect that changes color when the navigation menu is hovered by the mouse.
Menu navigation
2024-02-29

jQuery visual form drag and drop editing code

jQuery visual form drag and drop editing code is a visual form based on jQuery and bootstrap framework.
form button
2024-02-29

Organic fruit and vegetable supplier web template Bootstrap5

An organic fruit and vegetable supplier web template-Bootstrap5
Bootstrap template
2023-02-03

Bootstrap3 multifunctional data information background management responsive web page template-Novus

Bootstrap3 multifunctional data information background management responsive web page template-Novus
backend template
2023-02-02

Real estate resource service platform web page template Bootstrap5

Real estate resource service platform web page template Bootstrap5
Bootstrap template
2023-02-02

Simple resume information web template Bootstrap4

Simple resume information web template Bootstrap4
Bootstrap template
2023-02-02

Cute summer elements vector material (EPS PNG)

This is a cute summer element vector material, including the sun, sun hat, coconut tree, bikini, airplane, watermelon, ice cream, ice cream, cold drink, swimming ring, flip-flops, pineapple, conch, shell, starfish, crab, Lemons, sunscreen, sunglasses, etc., the materials are provided in EPS and PNG formats, including JPG previews.
PNG material
2024-05-09

Four red 2023 graduation badges vector material (AI EPS PNG)

This is a red 2023 graduation badge vector material, four in total, available in AI, EPS and PNG formats, including JPG preview.
PNG material
2024-02-29

Singing bird and cart filled with flowers design spring banner vector material (AI EPS)

This is a spring banner vector material designed with singing birds and a cart full of flowers. It is available in AI and EPS formats, including JPG preview.
banner picture
2024-02-29

Golden graduation cap vector material (EPS PNG)

This is a golden graduation cap vector material, available in EPS and PNG formats, including JPG preview.
PNG material
2024-02-27

Home Decor Cleaning and Repair Service Company Website Template

Home Decoration Cleaning and Maintenance Service Company Website Template is a website template download suitable for promotional websites that provide home decoration, cleaning, maintenance and other service organizations. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-05-09

Fresh color personal resume guide page template

Fresh color matching personal job application resume guide page template is a personal job search resume work display guide page web template download suitable for fresh color matching style. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-29

Designer Creative Job Resume Web Template

Designer Creative Job Resume Web Template is a downloadable web template for personal job resume display suitable for various designer positions. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-28

Modern engineering construction company website template

The modern engineering and construction company website template is a downloadable website template suitable for promotion of the engineering and construction service industry. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-28