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:
-
- 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 242953 2023-01-13 00:41:50
-
- 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 61563 2023-01-13 00:41:50
-
- 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 91804 2022-01-12 15:14:34
-
- 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 62484 2022-01-12 15:39:09
-
- 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 244238 2023-01-13 00:41:50
-
- 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 54905 2021-03-12 16:21:15
-
- 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 61731 2023-01-13 00:41:49
-
- 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 28066 2023-01-13 00:41:49
-
- 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 56528 2023-01-13 00:41:49
-
- 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 73957 2023-01-13 00:41:49
-
- 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 30610 2021-03-05 15:21:09
-
- 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 27967 2021-03-05 14:40:43
-
- 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 112211 2021-03-05 11:43:31
-
- 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 128371 2023-01-13 00:41:48
-
- 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 70171 2023-01-13 00:41:48