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 set excel cross cursor
- How to set the excel cross cursor: 1. Select a cell and click the [View] option in the top toolbar; 2. In the pop-up secondary menu, click the [Reading Mode] option. At this point, the cursor will turn into a cross cursor, and we can also set its color.
- excel 53506 2020-06-16 15:16:08
-
- What is the shortcut key for starting a new row in excel?
- The shortcut keys for starting a new row in Excel are: 1. When starting a new row in the table, just press [enter]; 2. When starting a new row in a cell, you need to press the shortcut key [alt+ENTER].
- excel 25172 2020-06-16 14:24:15
-
- How to change the excel cell date format to 2013-01?
- How to change the date format of excel cells to 2013-01: First open the excel file and select the row to be edited; then press [Ctrl+1] or right-click to set the cell format, and select the [Date] option; finally click Auto To define the options, enter [2013-01] in the text box below the type.
- excel 6210 2020-06-16 13:52:08
-
- How to use vlookup to filter duplicate data from two excels?
- How to use vlookup to filter duplicate data in two excels: first add the [auxiliary] column after both tables and automatically fill it with 1; then click [View-Switch Window-Excel Tutorial] in Table 2; finally click sheet6 to switch Just go back to [excel tutorial] to find all duplicate records.
- excel 29144 2020-06-16 11:21:10
-
- What should I do if excel cannot find smartart?
- The solution to the problem that excel cannot find smartart: First, click [Insert Button-Shape] in the excel table; then choose to insert various SmartArt graphics; and finally select the graphics that need to be inserted.
- excel 33458 2020-06-16 10:53:24
-
- What should I do if the number after I enter a number in an Excel spreadsheet changes to 0?
- The solution to the problem that the last few digits of a number entered in an Excel table become 0: 1. Enter the English ['] quotation marks in the cell before entering the number; 2. Select the data cell and click [Format Cell]; 3. In sequence Click [Number-Text-OK].
- excel 42475 2020-06-16 09:54:47
-
- How to restore asterisks to numbers in excel
- The method to restore asterisks to numbers in Excel is: 1. Select the area to be restored and right-click; 2. Select [Format cells] in the pop-up option list; 3. Check [Number] under the column [ General] category, click [OK].
- excel 32963 2020-06-16 09:10:45
-
- How to set excel to only display ready?
- How to set excel to only display ready: first open excel and click [File]; then click [New] in the pop-up; then select the document we want to add; and finally select it and click it.
- excel 6710 2020-06-15 17:48:19
-
- How to set the alignment of two columns with the same name in an excel table?
- How to set up the alignment of two columns with the same name in an Excel table: First, sort the first column in descending or ascending order; then select the second and third columns for custom sorting; then set the custom sorting according to the first column; and finally complete the sorting with the same name. Can.
- excel 25680 2020-06-15 17:38:34
-
- How to separate irregular Chinese and English in Excel?
- How to separate irregular Chinese and English in excel: first open the table, and click [Data, Column] in the table; then click [Fixed Width, Next]; finally click on the boundary between Chinese and English, and a line will appear. Just click Finish.
- excel 19922 2020-06-15 15:15:00
-
- How to round in excel?
- The method of rounding in Excel: first enter the formula ROUNDUP in B2; then select cell A2 in the brackets and press Enter; finally, pull down and copy in the lower right corner of cell B2, and the entire series is completed.
- excel 12207 2020-06-15 14:59:03
-
- What should I do if the menu bar disappears when I right-click in Excel?
- The solution to the problem that the menu bar disappears when you right-click in Excel is: 1. Click the [File] option in the upper left corner and select [Options] in the pop-up option list; 2. Switch to the [View] column; 3. Check Just select the [Show floating toolbar when right-clicking] option.
- excel 27404 2020-06-15 14:30:09
-
- How to prohibit changes in excel after entering data
- How to prohibit changes after inputting data in Excel: 1. Open the Excel table and click the [Review] option in the top toolbar; 2. Click the [Protect Workbook] option in the pop-up secondary menu; 3. Check [Structure] 】 option, enter the password.
- excel 9252 2020-06-15 13:14:24
-
- How to set the expiration reminder in Excel to change color 30 days in advance?
- How to set the Excel expiration reminder to change color 30 days in advance: First select the table column to be reminded, and click [Start, Conditional Formatting, New Rule]; then click [Use a formula to determine the cells to be formatted] and enter [= C1-TODAY()<=30]; then set the font color; finally click OK.
- excel 49804 2020-06-15 12:10:34
-
- How to use date function in excel?
- How to use the date function in excel: first click the insert function button in the table; then enter the date function query and select to enter the settings panel; then enter the year in the year column, and enter the month and date in the lower column; finally, set the cell Just switch the format.
- excel 11955 2020-06-15 12:00:24