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
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.
Player special effects
2024-02-29
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
