current location:Home > Technical Articles > Topics > excel

  • 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 55996 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 58205 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 44819 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 42165 2023-01-13 00:42:06
  • What does excel macro function do?
    What does excel macro function do?
    The functions of the excel macro function: 1. It can record all the user's operations and automatically convert these operations into corresponding command narratives; 2. The operator records the entire operation process and can perform the recording operation.
    excel 47471 2023-01-13 00:42:05
  • What is the usage of excel vlookup function
    What is the usage of excel vlookup function
    In Excel, the vlookup() function is used to search for elements that meet the conditions in the first column of a specified range, determine the row number of the cell to be detected in the range, and then further return the value of the selected cell; the syntax is "vlookup(find Value, search range, column where search results are located, matching type)".
    excel 127262 2022-03-29 17:10:31
  • How to add the same text to each column in excel
    How to add the same text to each column in excel
    How to add the same text to each column in excel: first add "GHI" in the column and enter the formula "="GHI"&B1" in the cell; then add the desired content in the position of GHI; finally click the Enter key.
    excel 137416 2022-01-12 15:12:44
  • How to make excel table header
    How to make excel table header
    How to make an excel table header: 1. Open the excel table and click Insert; 2. Click Shape, Line, and select slash; 3. Adjust the position of the line, click the text box option under the Insert column, and enter the header text. .
    excel 103255 2023-01-13 00:42:05
  • How to extract irregular fields in excel
    How to extract irregular fields in excel
    How to extract irregular fields in Excel: first open the software and open the [File] function; then click the [Open] function to open the file that needs to extract text; then enter the formula in the extracted text to fill the cell; finally enter and press Enter to complete Text extraction.
    excel 33281 2023-01-13 00:42:05
  • How to import external data in excel
    How to import external data in excel
    How to import external data in excel: first create a blank excel worksheet; then click on a functional data in the upper right corner; then click on a button in the upper left corner to import external data; finally select the import method and find the data that needs to be imported file, confirm the import.
    excel 26196 2023-01-13 00:42:00
  • How to change the fill color of alternate rows in a table
    How to change the fill color of alternate rows in a table
    How to set the fill color of alternate rows in the table: 1. Open the Excel table and select the cells; 2. Click Conditional Formatting in the toolbar and select New Rule; 3. Click to select and use formulas to determine the cells to be formatted; 4. Enter the formula "=mod(row(),2)"; 5. Click OK.
    excel 58362 2023-01-13 00:42:00
  • How to unmerge merged cells
    How to unmerge merged cells
    How to cancel merged cells: 1. Select the cell and right-click; 2. In the pop-up options, select the Format Cells option; 3. Switch to the Alignment tab, uncheck the Merge Cells option, and click Sure.
    excel 124257 2023-01-13 00:42:00
  • How to swap positions of two columns in excel
    How to swap positions of two columns in excel
    How to swap positions between two excel columns: First open the excel table file; then move the mouse to cell B1, hold down the left button and drag down to cell B11; then move the mouse to the right border of the selected part of column B , then hold down the Shift key; finally hold down the left mouse button, move the mouse to the right border of column C, and then release the left mouse button.
    excel 119548 2023-01-13 00:42:00
  • How to reverse rows and columns in excel
    How to reverse rows and columns in excel
    How to swap rows and columns in Excel: First open the Excel table; then select the cell range, right-click the mouse, and click to select the [Copy] option in the pop-up menu option; then click to select the blank cell, and click to select [Paste Special] Post] option; finally select the [Transpose] option in the [Paste Special] dialog box.
    excel 41171 2021-03-26 16:52:38
  • What is the meaning of absolute reference in excel
    What is the meaning of absolute reference in excel
    The meaning of absolute reference in Excel is: the content of the reference is absolute (always the content of the referenced cell at a specific position). No matter how the position of the cell where the formula is located changes, the content of the reference is always fixed. The "$" sign is used in formulas to represent absolute references.
    excel 37228 2023-01-13 00:41:59

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