current location:Home > Technical Articles > Topics > excel

  • What should I do if Excel prompts that there is insufficient memory and cannot be opened?
    What should I do if Excel prompts that there is insufficient memory and cannot be opened?
    The solution to the problem that Excel prompts that there is insufficient memory and cannot be opened: first open the Excel file, click File, Options; then enter the Trust Center option, click Add New Location; finally select a drive letter and check [Also trust subfolders of this location]. Just click OK.
    excel 56286 2022-01-12 15:46:42
  • How to add content to excel drop-down box
    How to add content to excel drop-down box
    Adding method: First open the excel table that needs to be operated, click "Data" - "Data Verification" at the top of the page; then in the pop-up "Data Verification" window, select "Sequence" from the "Allow" drop-down list, and enter "Source" Enter the specified value in the box; finally click the "OK" button.
    excel 48031 2023-01-13 00:42:37
  • What are the commonly used functions in excel tables?
    What are the commonly used functions in excel tables?
    Commonly used functions include: 1. COUNT represents the number of calculated values; 2. ROUND represents rounding; 3. RAND represents random numbers; 4. MIN represents the minimum value; 5. MAX represents the maximum value; 6. SUM represents the sum; 7. AVERAGE represents the average; 8. IF represents the condition.
    excel 97880 2023-01-13 00:42:36
  • How to realize the interchange of horizontal and vertical coordinates in excel line chart
    How to realize the interchange of horizontal and vertical coordinates in excel line chart
    Implementation method: First open the excel table that needs to be operated and select the abscissa; then right-click the mouse and click "Select Data" in the pop-up right-click menu; then select "Switch Rows/Columns" in the pop-up new window and click " OK" to switch the horizontal and vertical coordinates.
    excel 69977 2023-01-13 00:42:36
  • What to do if macros are enabled but still disabled
    What to do if macros are enabled but still disabled
    Solution: 1. Click the "Options" button and check "Enable this content". 2. Click the "Office" - "Excel Options" button, check "Show the 'Developer' tab in the ribbon" in the new window, open "Developer Tools" - "Macro Security" at the top of the page, and check "Enable All Macros" and click "OK".
    excel 58936 2023-01-13 00:42:36
  • How to insert serial numbers into the table
    How to insert serial numbers into the table
    How to insert serial numbers into a table: 1. Enter the first two digits of the serial number and drag the fill handle to automatically add the serial number; 2. After entering the first digit of the serial number, use the Ctrl key with the fill handle to add the serial number; 3. Enter the first digit of the serial number After adding a number, right-click the mouse and select "Fill Sequence" to add a serial number.
    excel 136250 2023-01-13 00:42:36
  • How to use round function in excel
    How to use round function in excel
    The method of using the round function in excel is: first open the excel table, select the cells that need to be operated; then enter the formula "=ROUND (data to be calculated, number of digits to retain)" in the cell; finally press the key on the keyboard Press the "Enter key" to get the result.
    excel 51002 2023-01-13 00:42:32
  • How to generate QR code in excel
    How to generate QR code in excel
    Method: First click "Development Tools" - "Insert" - "Other Controls"; then select "Microsoft Barcode", hold down the left mouse button and drag in the cell; then right-click the barcode, select "Properties", and click Custom Change the three-dot icon to "11-QR"; enter "A1" in the last "linked".
    excel 66931 2023-01-13 00:42:32
  • How to set vertical alignment of text in excel
    How to set vertical alignment of text in excel
    Setting method: First open the excel table, select the cells that need to be operated; then right-click the mouse and select "Format Cells" in the pop-up right-click menu; then select the "Alignment" tab, and in the "Vertical Alignment" option , select "Center"; finally click "OK".
    excel 11762 2023-01-13 00:42:31
  • How to automatically correct ID card errors in Excel
    How to automatically correct ID card errors in Excel
    Method: First enter "=IF(LEN(data)=18,MID('10X98765432',MOD(SUMPRODUCT(VALUE(MID(data,ROW(data area),1)),data area),11) into the cell +1,1),'Wrong length')"; and then just compare.
    excel 25387 2023-01-13 00:42:31
  • How to sort wps according to score
    How to sort wps according to score
    Sorting method: First open the excel table, select the cells that need to be sorted; then click the "Start" - "Sort" option at the top of the page, and select "Descending Order" in the drop-down menu; then in the new pop-up window "Give sorting" Select "Expand selected area" in "By"; finally click the "Sort" button.
    excel 26027 2023-01-13 00:42:31
  • What are the uses of ctrl+enter in excel?
    What are the uses of ctrl+enter in excel?
    Purpose: 1. Fill the same content in batches; select a cell range, enter a formula or value in the address bar, and press "Ctrl+Enter" to batch fill the cells in the selected range. 2. Batch merge cells to fill in formulas; select the merged cell range, enter the formula or value in the address bar, and press "Ctrl+Enter" to fill.
    excel 24429 2023-01-13 00:42:31
  • How to customize complex formula calculations in Excel
    How to customize complex formula calculations in Excel
    Definition method: First open an excel table, select the specified cell, and enter "=" in the cell; then click on the cell to be calculated, and then enter the multiplication and division of the formula; then press the Enter key and move the mouse to the edge of the cell , turns into a "+" sign; finally double-click or pull down the mouse.
    excel 43011 2023-01-13 00:42:31
  • How to select multiple spaced cells
    How to select multiple spaced cells
    How to select multiple spaced cells: 1. Press the "ctrl" key on the keyboard and click on the cells to be selected with the mouse to select multiple desired discontinuous cells; 2. Press the Press the "shift+F8" keys, "Add to Selection" will be displayed at the bottom of the table, and you can quickly select the cells you want to select with the left mouse button.
    excel 20237 2023-01-13 00:42:31
  • What should I do if it prompts for repair every time I open excel?
    What should I do if it prompts for repair every time I open excel?
    The solution to the problem that Excel prompts to repair every time it is opened: First open the Excel table, click the "File" tab at the top of the page; then click "Options" on the left toolbar, and click Uncheck on the right in the new window that pops up. Just disable automatic recovery for this work blog.
    excel 55196 2023-01-13 00:42:31

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