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:
-
- What to do if excel prompts that data cannot be pasted
- Solution to Excel prompting that data cannot be pasted: 1. Check the current number of rows. If it exceeds the maximum number of rows in Excel, it cannot be pasted; 2. Make sure that the current worksheet is not locked and can be unlocked.
- excel 59883 2020-03-04 11:06:10
-
- How to use group sum in excel
- How to use excel group sum: 1. Open the excel table to be processed and select the data to be processed; 2. Click the pivot table in the menu insert; 3. Click the name field on the left side of the pivot table tool and drag it downwards Go to the row label and drag the commission to the value; 4. Click OK to group and sum.
- excel 11865 2020-03-04 10:51:36
-
- How to enter the next row in excel table?
- How to wrap rows in an excel table: 1. You can use the Enter key to enter the next cell. 2. Use the down arrow to go to the next cell. 3. Use the "alt+enter" shortcut key to wrap lines in the cell.
- excel 33541 2020-03-04 10:05:40
-
- How to create two rows of text in one cell in excel
- How to type two lines of text in one cell of an Excel table: Use Excel's automatic line wrap command or forced line wrap command ALT+ENTER to type two lines of text in one cell of Microsoft Excel.
- excel 19391 2020-03-04 09:57:20
-
- What is the excel automatic numbering function?
- The excel automatic numbering function is the ROW function. The ROW function is a function used to determine the current row position of the cursor. Syntax: ROW (reference), Reference is the cell or cell range whose row number needs to be obtained.
- excel 15933 2020-03-04 09:49:40
-
- What is the name of the workbook automatically created by excel?
- Every time you start Excel, the system will automatically create a new workbook with the file name Book1.xls. The so-called workbook refers to the file used to store and process work data in the Excel environment. In other words, the Excel document is a workbook.
- excel 8588 2020-03-04 09:41:47
-
- Why can't I save after editing in Excel? How to solve?
- Unable to save after editing in Excel may be because the file is protected and cannot be changed. Solution: Click "Review" - "Unprotect Sheet" in the menu bar.
- excel 22736 2020-03-04 09:30:53
-
- What is the shortcut key for excel filtering?
- The shortcut key for excel filtering is "Ctrl+Shift+L". Use this shortcut key to select a data table, enter the filtering state with one click, and press again to cancel filtering.
- excel 32464 2020-03-04 09:23:15
-
- What is the function to calculate the number of people in excel
- The function for calculating the number of people in excel is the counta function. How to use it: first open the excel table; then search to find the counta function; then select the data that needs to be counted; and finally click "OK" to get the result of counting the number of people.
- excel 38425 2020-03-04 09:21:32
-
- What should I do if the automatic line wrapping in Excel is not fully displayed?
- The solution to the incomplete display of automatic word wrapping in Excel: first open the Excel table; then select the cell and click the drop-down triangle position of the "Format" option in the tab of the table toolbar; then click "Row Height" in the open drop-down menu option Just click the "Automatically adjust row height" option below.
- excel 68252 2020-03-04 09:14:15
-
- How to batch generate QR codes in Excel
- How to generate QR codes in batches in excel: first open the excel table; then select the data cell area in column A where you want to create QR codes; then click [Picture Tools] and click [Batch Generation] in the QR code menu; finally click [Save to area] and confirm.
- excel 12359 2020-03-04 09:08:03
-
- How to create batch copies of excel
- How to create a copy in batches in Excel: First open a worksheet that has been formatted; then right-click the worksheet label and select "Move and Copy"; then check "Create Copy" in the dialog box and click OK; finally repeat the operation You can create copies in batches.
- excel 19222 2020-03-04 09:01:39
-
- What is the reason why the wps sum is 0?
- The wps summation is 0 because there is a problem with the format of the summary cell. The solution is as follows: right-click the cell, click Set Cell Format, and in the value, set the number of decimal places to 2 to see the correct display result.
- excel 45310 2020-03-03 16:43:34
-
- How to change the color of the entire row that meets the condition in Excel
- How to change the color of the entire row that meets the conditions in Excel: 1. Select a row and click Conditional Formatting - New Rule; 2. In the New Format dialog box, select "Determine the cells to be formatted based on the formula"; 3. In "For Enter the formula in "Format values that match this formula" and select a fill color.
- excel 43350 2020-03-03 10:35:10
-
- How to enter the next row in excel?
- How to enter the next line in Excel: 1. After entering a line, press the "Enter" key to jump to the next line. 2. Use the down arrow on your keyboard. 3. Use the shortcut key "alt+enter" to wrap a new line in a cell.
- excel 25511 2020-03-03 10:31:48