current location:Home > Technical Articles > Topics > excel

  • What to do if excel prompts that data cannot be pasted
    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 59895 2020-03-04 11:06:10
  • How to use group sum in excel
    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 11881 2020-03-04 10:51:36
  • How to enter the next row in excel table?
    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 33552 2020-03-04 10:05:40
  • How to create two rows of text in one cell in excel
    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 19404 2020-03-04 09:57:20
  • What is the excel automatic numbering function?
    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 15940 2020-03-04 09:49:40
  • What is the name of the workbook automatically created by excel?
    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 8602 2020-03-04 09:41:47
  • Why can't I save after editing in Excel? How to solve?
    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 22749 2020-03-04 09:30:53
  • What is the shortcut key for excel filtering?
    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 32476 2020-03-04 09:23:15
  • What is the function to calculate the number of people in excel
    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 38434 2020-03-04 09:21:32
  • What should I do if the automatic line wrapping in Excel is not fully displayed?
    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 68269 2020-03-04 09:14:15
  • How to batch generate QR codes in Excel
    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 12370 2020-03-04 09:08:03
  • How to create batch copies of excel
    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 19240 2020-03-04 09:01:39
  • What is the reason why the wps sum is 0?
    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 45330 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 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 43361 2020-03-03 10:35:10
  • How to enter the next row in excel?
    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 25522 2020-03-03 10:31:48

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