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:
-
- What should I do if the excel table after the dotted line cannot be printed?
- The solution to the problem that the excel table cannot be printed after the dotted line: First use Excel to open the table that needs to adjust the dotted line; then click the "View" menu and select "Distribution Preview" in the drop-down list; then adjust the position of the page break; finally select the dotted line and drag it to the edge of the required printing area.
- excel 45331 2020-03-24 09:25:21
-
- How to automatically erase zeros in excel
- How to automatically erase zeros in Excel: First start Excel on the desktop; then enter the formula "=INT(D2)" in the cell and press Enter; then pull down the cell fill box to complete the entire table.
- excel 13566 2020-03-24 09:19:41
-
- How to sort birthdays in excel by month and day
- How to sort birthdays in Excel by month and day: First select any cell in the [A1:B18] area; then click the menu "Data → PivotTable and PivotChart"; then change the "Date of Birth" field and "Name" ” field to the row area; finally select “Field Settings” and choose to group and sort by month and day.
- excel 19050 2020-03-24 09:14:35
-
- How to make the table display on one page
- How to display the table on one page: first open the excel table, select the cells that need to be operated and click the "Print Preview" button directly; then enter "Print Preview" and directly click the "Close" button; finally adjust the width of the table. Can.
- excel 70762 2020-09-14 10:50:43
-
- What is macro function
- The macro function is a batch processing program command. Using "macro" can improve work efficiency; Microsoft's office software allows users to write their own scripts called VBA to increase the flexibility of "macro" and further expand the capabilities of "macro"; and In fighting games, using the simulator to record "macro" allows you to unleash unique moves with one click.
- excel 30079 2020-11-04 15:34:22
-
- How to calculate the length of a string in Excel
- The Len function in Excel calculates the length of a string. The usage format of the Len function is "=LEN(text)", where the parameter "text" represents the text string to be counted; when the Len function wants to count, whether it is a full-width character or a Half-width characters, each character counts as "1".
- excel 77121 2022-01-12 15:35:09
-
- How to set the borders and shading of a worksheet
- How to set the worksheet borders and shading: first open the Microsoft Excel software; then click [Blank Workbook] and create a new excel table; then right-click and select the [Format Cells] option; finally select from the [Border] option Just add solid border lines and shading.
- excel 6544 2020-03-20 11:59:06
-
- How to display the ID number correctly in the form
- How to correctly display the ID card number in the table: first select the cell with the ID card information and right-click; then select "Format Cells"; finally select "Text" in the category and click OK.
- excel 18323 2020-03-18 16:23:42
-
- How to compare information in excel table
- How to compare information in an excel table: first open an excel table that needs to compare whether two columns of data are the same; then select a cell where you want to put the judgment result, and enter the "=" sign in the cell; finally select Data in the corresponding cells in the first and second columns and press Enter.
- excel 20846 2020-03-18 11:10:48
-
- How to sum in xls
- How to sum xls: first open the excel table; then click on the cell with the mouse; then click on the menu bar "Formulas-AutoSum-Sum"; finally use the mouse to drag to select the data you want to sum, and press Enter Click the key to automatically sum the selected data.
- excel 17387 2020-03-18 10:59:40
-
- Why does 3.50127E+17 appear when copying numbers in excel?
- "3.50127E+17" will appear when copying numbers in excel because the entered number is too large and the system automatically changes it to scientific notation. The solution: first open the Excel document; then select the ID card cell; then right-click the mouse. Choose to format the cells; finally change [Format] to [Text].
- excel 11726 2020-03-17 13:57:02
-
- The difference between xlsx and excel
- The difference between xlsx and excel: 1. xlsx is the extension of the [Microsoft Office EXCEL 2007/2010/2013/2016/2019] document; 2. excel is a spreadsheet software with an intuitive interface, excellent calculation functions and charts tool.
- excel 33153 2020-03-17 13:22:00
-
- What is the default alignment of numbers in excel
- The default alignment of numbers (numeric data) in Excel is to the right in the horizontal direction and in the center in the vertical direction. Such as date, time, etc. are all numerical data.
- excel 41931 2020-03-17 13:19:11
-
- What is the function to get the minimum value in excel
- The function that takes the minimum value in Excel is the min function. The function syntax is [MIN(number1,number2,...)]. The parameters number1, number2, etc. can be numbers, cell names, continuous cell ranges, and logical values.
- excel 56260 2020-09-12 12:00:19
-
- How to set horizontal and vertical centering in cells
- How to set horizontal and vertical centering in cells: Right-click the cell you want to set, open the "Format Table" item, and then set both "Horizontal Alignment" and "Vertical Alignment" to "Centered" in the pop-up window That’s it.
- excel 27944 2020-03-17 11:07:33