current location:Home > Technical Articles > Topics > excel

  • How to compress font spacing in excel
    How to compress font spacing in excel
    How to tighten font spacing in Excel: 1. First select the table, right-click, and select [Format Cells]; 2. Then switch to the [Alignment] tab, check the [Reduce Font Fill] option, and click [OK]; 3. , and finally adjust the table size.
    excel 25391 2020-05-12 17:27:10
  • How to match data in 2 excel tables
    How to match data in 2 excel tables
    Methods for matching data in two excel tables: first place the cursor in an excel cell; then enter "=vl" in the cell, and add a "," after the data; then in another table, put all the data Select all; finally fill in the data that appears in the "Sheet1" table in the overall evaluation table.
    excel 27049 2020-05-06 15:22:45
  • How to output value in excel interval range
    How to output value in excel interval range
    The method of outputting values ​​in excel interval range: first open the table excel file that needs to be filtered; then click Numeric Filter to perform specific data filtering or data filtering for a certain numerical interval for table files containing a large amount of data; then open advanced filtering and enter Cell range or use the mouse to select the required area; finally click OK.
    excel 14718 2020-05-06 15:21:20
  • What is the extension of Excel 2010 workbook?
    What is the extension of Excel 2010 workbook?
    The extension of Excel2010 workbook file is xlsx. How to modify the file extension of Excel 2010 workbook: Open the file whose extension you want to modify, click "File" at the top of the page, click "Save As" - "This Computer" - "More Options" in the pop-up interface, and then open The extension can be modified in the interface.
    excel 17759 2020-05-08 15:18:31
  • How to check duplicate data in two excel tables
    How to check duplicate data in two excel tables
    How to check data duplication in two excel sheets: Enter countif in Sheet1, select the data to be compared, enter a "," sign, then enter Sheet2, select the data to be compared, and press Enter.
    excel 12513 2020-05-09 16:24:15
  • How to format date in excel into yyyy-mm-dd format
    How to format date in excel into yyyy-mm-dd format
    The method to format dates in excel into yyyy-mm-dd format is: 1. First select the date, right-click, and select the [Format Cells] option; 2. Then switch to the [Number] tab and click [Customize] , select [General Format] and enter [YYYY-MM-DD].
    excel 51451 2020-05-13 17:38:06
  • How to generate weekday corresponding to date in excel
    How to generate weekday corresponding to date in excel
    The method for Excel to generate the week corresponding to the date is: 1. First, select the date, right-click, and select the [Set Cell Format] option; 2. Then select the format corresponding to the date, and then change the date type in the custom column to [yyyy year] mm month dd day aaaa], click [OK].
    excel 7619 2020-05-13 17:38:52
  • How to select all cells in a worksheet
    How to select all cells in a worksheet
    Method to select all cells in the worksheet: 1. Click the blank square at the intersection of the row number and column number in the upper left corner of the worksheet. 2. Select a cell in the worksheet, and then use the "Ctrl+A" shortcut key to select all cells in the worksheet.
    excel 25457 2020-05-09 16:23:05
  • What does now() mean in excel
    What does now() mean in excel
    In Excel, now() is a function used to return the serial number corresponding to the current date and time. If the cell format is "General" before entering the function, the result will be in date format.
    excel 12275 2020-05-09 16:22:53
  • Can worksheets be moved between different workbooks?
    Can worksheets be moved between different workbooks?
    Worksheets can be moved between different workbooks. Moving method: Select the worksheet you want to move, right-click, select "Move or Copy Worksheet" in the pop-up menu, set in the pop-up dialog box to move the selected worksheet to the workbook, and then click OK.
    excel 5714 2020-05-09 16:22:27
  • What should I do if the scroll bar in Excel is missing?
    What should I do if the scroll bar in Excel is missing?
    The solution to the missing scroll bar in Excel is: 1. First open Excel, click [File], select [Options], and open the [Advanced] option; 2. Then find [Display options for this workbook] and select [Display Horizontal scroll bar], click [OK].
    excel 6420 2020-05-13 17:47:21
  • How to convert pivot table into table
    How to convert pivot table into table
    How to convert a pivot table into a table: first insert a pivot table, and click the "+" sign in the cell in the first column to expand the table; then remove the subtotal rows in the table; then adjust the table to a table style; and finally, in sequence Click "PivotTable Tools-Design-Report Layout-Repeat All Item Labels".
    excel 35285 2020-04-27 16:38:06
  • How to display quantity in parentheses after filtering in excel
    How to display quantity in parentheses after filtering in excel
    How to display the quantity in brackets after Excel filtering: First open an Excel table and select the area to be filtered; then click the "Data" option in the main menu and select "Filter" in the tools; then click "Insert" in the main menu ", select the insert function; finally select the "SUBTOTAL" function and filter.
    excel 37512 2020-04-27 16:36:21
  • Why does #N/A appear when using the vlookup function?
    Why does #N/A appear when using the vlookup function?
    "#N/A" will appear when using the vlookup function because there is no matching judgment set. The solution is: first open the Excel file; then enter the "vlookup" function in the blank cell to find the employee; then check the entered formula parameters; finally Just set the matching judgment and save it.
    excel 9208 2020-04-27 16:36:06
  • How to solve the problem of lost or damaged excel dictionary file
    How to solve the problem of lost or damaged excel dictionary file
    Solution to missing or damaged excel dictionary file: right-click Excel, select Properties in the drop-down menu, enter the Compatibility tab in the properties dialog box, and check "Run in compatibility mode" and "Run as administrator".
    excel 9784 2020-05-07 11:59:56

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