current location:Home > Technical Articles > Other

  • What is the excel ranking formula?
    What is the excel ranking formula?
    The excel ranking formula is the rank function; the specific method is: first enter the formula "=RANK (cell, numerical area of ​​ranking)" in the specified cell; then press the "Enter key" on the keyboard; then place the mouse on the cell In the lower right corner of the grid, the mouse style changes; it is best to hold down the left mouse button and pull down.
    excel 87362 2021-05-31 13:57:14
  • How to type the ellipses in the document directory?
    How to type the ellipses in the document directory?
    Method: First open the word document that needs to be operated, right-click the specified paragraph, and select "Paragraph" in the pop-up right-click menu; then select "Tab Stop" in the pop-up new window, and in the "Tab Stop Position Bar" Enter the specified amount; finally, check "Symbols similar to ellipsis" in "Leader", click "Settings", and then click "OK".
    word 46113 2021-05-31 13:56:34
  • How to count the number of occurrences of a person's name in excel
    How to count the number of occurrences of a person's name in excel
    Statistical method: First open the excel table that needs to be operated, select the specified cell; then enter the formula "=COUNTIFS (data area, cell where the name of the person needs to be counted)" in the cell; finally press the "Enter" key on the keyboard "That's it.
    excel 103294 2023-01-13 00:42:45
  • What is the solution to garbled characters after opening csv with excel?
    What is the solution to garbled characters after opening csv with excel?
    Solution: First open an empty excel table, click "Data" - "From Text" at the top of the page; then import the csv file, select "Delimiter" in the pop-up dialog box, and select "utf-8" as the format; finally " Check "Comma" for "Delimiter", remove the check before "Tab key", and click the "OK" button.
    excel 58991 2023-01-13 00:42:45
  • What should I do if WPS cannot make partial modifications to merged cells?
    What should I do if WPS cannot make partial modifications to merged cells?
    Solution: First open the Excel table that needs to be operated and cancel the part of the merged cells; then select the part of the cells that needs to be merged and press the "ctrl+1" key on the keyboard; then select "Align" in the new window that pops up. ” tab, select the “Center Across Columns” option; finally click the “OK” button.
    excel 53914 2023-01-13 00:42:45
  • What should I do if the formula edited in the formula editor is not fully displayed?
    What should I do if the formula edited in the formula editor is not fully displayed?
    Solution: First open the word document that needs to be operated; then select the specified text, right-click the mouse, and select the "Paragraph" option in the pop-up right-click menu; finally select "Minimum" in the "Line Spacing" option and click "OK" Just click the button.
    word 28619 2023-01-13 00:44:02
  • What should I do if I forget the password for the Pagoda Panel? (reset Password)
    What should I do if I forget the password for the Pagoda Panel? (reset Password)
    Below, the Pagoda Panel Tutorial column will introduce to you the solution to the forgotten Pagoda Panel password (reset password). I hope it will be helpful to friends in need!
    Pagoda Panel 5637 2021-05-28 15:11:47
  • How to change wps table to three-line table
    How to change wps table to three-line table
    Method: First select the entire table, right-click the cross arrow button in the upper left corner of the table, and select "Table Properties"; then select the "Borders and Shading" option, click the "None" border button in the "Settings" list; then select Specify Width , click the upper and lower borders of the table with the mouse; finally select the table title row and set the lower border with the same width.
    word 4184 2023-01-13 00:44:01
  • What should I do if the right-click menu bar in Excel does not appear?
    What should I do if the right-click menu bar in Excel does not appear?
    The solution to the problem that the right-click menu bar does not appear in excel: first open the excel document, click the file option in the top menu bar; then click Options in the pop-up option list; finally switch to the view column and check [Show floating when right-clicking] Toolbar] option.
    excel 68086 2023-01-13 00:42:45
  • How to make two lines of dropped caps in the first paragraph
    How to make two lines of dropped caps in the first paragraph
    Method: First open the word document that needs to be operated and select the text of the first paragraph; then click the "Insert" tab at the top of the page to find the "Drop Cap" option; then in the pop-up "Drop Cap" window Select "Sink", enter "2" in "Number of sinking rows"; finally click the "OK" button.
    word 80869 2023-01-13 00:44:01
  • What should I do if my wps page turns green?
    What should I do if my wps page turns green?
    The solution to the page that turns green in WPS: first open the WPS document, click the page layout column in the top menu bar; then find the background option under the page layout column, click the inverted triangle icon under the background; finally click the no fill color option. Can.
    word 38539 2021-05-28 14:17:10
  • How to merge similar items in excel
    How to merge similar items in excel
    Method: First click "Classification Summary", select "Count" for "Summary Method", and select the specified column for "Classification Field"; then enter text in the top box of the new column, press the "ctrl+g" key to bring up the positioning, and select "Null Value" "; then select "Merge and Center" and cancel "Subclassification"; finally select the blank column, click "Format Painter", and select the target column.
    excel 63821 2023-01-13 00:42:45
  • How to save file to desktop
    How to save file to desktop
    Method: First open the excel table that needs to be operated, select "File" at the top of the page; then click "Save As" in the pop-up window; then select "Desktop" in the pop-up window; finally click the "OK" button. Can.
    excel 91880 2023-01-13 00:42:44
  • How to cancel the border line in excel and turn it into blank
    How to cancel the border line in excel and turn it into blank
    Implementation method: First open the excel table that needs to be operated and select the specified cell; then click the "Start" tab at the top of the page and select the "No Frame" icon button; then click the "View" tab at the top of the page and change " Just uncheck "Show grid lines".
    excel 23260 2021-05-28 11:06:34
  • How to intercept some characters in excel
    How to intercept some characters in excel
    Method: First select the specified cell, click "Formula" - "Insert Function" at the top of the page, and look for the "mid" function; then enter the text string in the pop-up new window "text", enter the starting position in "start_num", and " num_chars" enter the interception length; finally click the "OK" button.
    excel 28448 2021-05-27 16:47:36

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