current location:Home > Technical Articles > Topics > excel

  • 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 38244 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 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 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 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
  • How to compare duplicate data between two worksheets
    How to compare duplicate data between two worksheets
    How to compare duplicate data between two worksheets: 1. Open the workbook and view the two worksheets inside; 2. Click "Data" - "Data Comparison" in sequence; 3. In the open drop-down menu, click "Mark Two Worksheets" "Region Repeat Value"; 4. In the pop-up dialog box, select the two areas to be compared; set the repeat color and click "OK".
    excel 150319 2021-04-23 17:12:58
  • How to use table sum sum
    How to use table sum sum
    How to sum the table sum: first select cell A2; then click the formula option on the page, and click Insert function; then find the SUM function in the pop-up insert function setting box; finally click on the right side of Number1 in the pop-up function parameter setting box icon to select the required sum range.
    excel 28735 2023-01-13 00:42:08
  • What are the chart types in excel?
    What are the chart types in excel?
    Chart types include: 1. Column charts that show changes in data over a period of time; 2. Line charts that show continuous changes in data over time; 3. Pie charts that show the size of each item in the data series and the proportion of the sum of each item; 4. Display each item in the data series. Bar charts comparing data between items; 5. Area charts emphasizing changes in volume over time; 6. Stock market charts showing stock fluctuation trends.
    excel 58958 2023-01-13 00:42:07
  • What should I do if the PivotTable field list is missing?
    What should I do if the PivotTable field list is missing?
    The solution to the missing PivotTable field list: First open the PivotTable; then right-click anywhere; finally, select the [Show Field List] option in the pop-up option list, so that the field list will be displayed.
    excel 7887 2023-01-13 00:42:07
  • How to start excel macro
    How to start excel macro
    How to start excel macros: First open excel, click [File], [Options]; then select [Trust Center], click [Trust Center Settings]; finally click [Macro Settings], check [Enable all macro options], and click OK.
    excel 69486 2023-01-13 00:42:07
  • Excel generates progress bar by date
    Excel generates progress bar by date
    How to generate a progress bar by date in excel: first open the excel file, select the cell range to be sorted; then click the [Data] and [A-Z] options in sequence; finally select the ascending or descending order of the date and export the progress bar.
    excel 20934 2023-01-13 00:42:07
  • How to convert xlsx and xls
    How to convert xlsx and xls
    Conversion method: 1. Open the excel file that needs to be processed and click "File" in the top navigation bar; 2. In the pop-up interface, click "Save As"; 3. In the "Save As" interface, click "Browse"; 4. In the pop-up window, select the save location and set the save type to ".xlsx" or ".xls" as needed.
    excel 56024 2021-04-20 11:14:11
  • How to use text function to convert date format in excel
    How to use text function to convert date format in excel
    Conversion method: 1. Use the "TEXT(specified cell, "yyyy-mm-dd")" statement to modify the date format to "yyyy-mm-dd"; 2. Use "TEXT((specified cell, "yyyy year mm" The "month dd day") statement modifies the date format to "yyyy year mm month dd day".
    excel 58218 2023-01-13 00:42:06
  • How to adjust row height and column width in excel
    How to adjust row height and column width in excel
    Method: 1. First select a row or column of cells; then right-click the selected row or column; then click "Row Height" or "Column Width" in the pop-up menu; finally enter a value in the dialog box and click "OK" That’s it. 2. First select a row or column of cells; then click "Row Height" or "Column Width" in "Start" - "Format" and enter the value.
    excel 44844 2023-01-13 00:42:06
  • How to sum multiple cells in excel
    How to sum multiple cells in excel
    How to sum multiple cells in Excel: 1. Enter [=C2+D2] in the blank cell and press Enter to get the summed value; 2. Select automatic sum in the blank cell - Sum, then frame-select adjacent data and press Enter to get the result.
    excel 42179 2023-01-13 00:42:06

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