current location:Home > Technical Articles > Topics > excel

  • How to compare the similarities and differences between two columns of data in excel
    How to compare the similarities and differences between two columns of data in excel
    How to compare the similarities and differences between two columns of data in Excel: 1. Select two columns of data and press the "Ctrl" key and the "/" key at the same time; 2. Enter the formula "=B2=C2" and fill the formula downwards into other cells; 3. Enter the formula "=IF(B2=C2,"","not the same")".
    excel 242957 2023-01-13 00:41:50
  • What should I do if the numerical value displayed in Excel is inconsistent with the actual result?
    What should I do if the numerical value displayed in Excel is inconsistent with the actual result?
    Solution: 1. Open the excel document, click "File" - "Options" in the top navigation bar; 2. Select the "Advanced" tab in the Excel options; 3. Find the "When calculating this workbook" option; 4. Check "Set precision to displayed precision", click "OK" in the pop-up dialog box, and close the tab.
    excel 61571 2023-01-13 00:41:50
  • How to check whether the names in two columns are consistent?
    How to check whether the names in two columns are consistent?
    How to check whether the names of the two columns are consistent: first select cell F3 and enter "=" in the cell; then click the [Insert Function] button and select the "IF" function in "Select Function"; then add In the dialog box behind the parameters, enter "COUNTIF(B3:B12,E3)>0"; finally set the parameters.
    excel 91811 2022-01-12 15:14:34
  • What should I do if the form is too large to be printed on one piece of paper?
    What should I do if the form is too large to be printed on one piece of paper?
    Solution to a table that is too large to be printed on one piece of paper: 1. Open "File->Page Setup->Scale" and set the ratio; 2. Set the print area in "File->Print Area"; 3. Adjust the page settings' margins.
    excel 62486 2022-01-12 15:39:09
  • How to print a title on every page
    How to print a title on every page
    How to set up a title for each page when printing: first open the excel table file to be printed; then in the menu above the excel table, open "Page Layout" and find "Print Title"; finally select the title row that needs to be printed and click OK. .
    excel 244243 2023-01-13 00:41:50
  • What is the shortcut key ctrl for deleting rows in excel?
    What is the shortcut key ctrl for deleting rows in excel?
    The shortcut key for deleting rows in Excel is ctrl plus "-(minus sign)". Specific operation: first open an excel table; then select an entire row of data in the table; finally press the "Ctrl" and "-" keys on the keyboard to delete the entire row of data.
    excel 54911 2021-03-12 16:21:15
  • How to subtract dates in excel to get the number of days
    How to subtract dates in excel to get the number of days
    How to get the number of days by subtracting dates in excel: first open the Excel table file; then set the cell value format to "date type"; finally, use the formula "B1-A1" and click to set the cell to "numeric type" and click Just "OK".
    excel 61737 2023-01-13 00:41:49
  • Why is there no 0 in the Excel table?
    Why is there no 0 in the Excel table?
    There are no 0s in the Excel table because the format of the cells has not been changed. The solution: first open the EXCEL software; then right-click the table where you need to add "0"; then click Set Cell Format, and in the pop-up dialog box Select "Text"; finally re-enter 0.
    excel 28074 2023-01-13 00:41:49
  • How to display duplicate data
    How to display duplicate data
    How to display duplicate data: First open the Excel table and set rules for column A; then select column A and click "Conditional Formatting"; then select "Highlight Cell Rules"; finally click "Duplicate Values" and click " OK”.
    excel 56534 2023-01-13 00:41:49
  • How to encrypt tables
    How to encrypt tables
    How to encrypt the table: first click the "File" menu bar and select "Information"; then click "Protect Workbook" and select "Encrypt with Password" in the pop-up drop-down list; finally enter the created password in the text box File password, click "OK".
    excel 73961 2023-01-13 00:41:49
  • How to create a new worksheet in excel
    How to create a new worksheet in excel
    How to create a new worksheet in Excel: First open the Excel software, there are three Sheets in the lower left corner of the table; then move the mouse to the area with the "little sun" or "+" sign on the right side of Sheet3, click on this area A new worksheet can be created.
    excel 30617 2021-03-05 15:21:09
  • Where on the worksheet are the worksheet labels located?
    Where on the worksheet are the worksheet labels located?
    The worksheet label is in the lower left corner of the worksheet. Open the workbook. By default, there will be three tabs, sheet1, sheet2, and sheet3, in the lower left corner. They are the worksheet tabs. The role of the worksheet label: Each worksheet has a name, and the worksheet name is displayed on the worksheet label.
    excel 27970 2021-03-05 14:40:43
  • How to remove table lines in excel
    How to remove table lines in excel
    How to remove excel table lines: 1. Click on the view in excel, then find the grid lines in "Show\Hide", and uncheck the previous default check; 2. Find "Fill Color" in the menu bar, and then select Just white.
    excel 112216 2021-03-05 11:43:31
  • How to merge merge tables
    How to merge merge tables
    How to merge tables: first open one of the tables; then click "Data" and select "Import from XML data"; then find the second table to open, and click on the first table "Sheet1"; finally import the data worksheet location, And click "Blank Cell".
    excel 128378 2023-01-13 00:41:48
  • What should I do if all excel sheets cannot be opened?
    What should I do if all excel sheets cannot be opened?
    The solution to the problem that all excel sheets cannot be opened: first open the control panel in the start menu; then find the program options in the control panel; then find the office software, right-click and select [Change]; finally execute the office repair program. .
    excel 70177 2023-01-13 00:41: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