current location:Home > Technical Articles > Topics > excel
- 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 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
- 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
- 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: 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?
- 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
- 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: 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 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: 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: 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 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 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 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 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
- 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