current location:Home > Technical Articles > Topics > excel

  • What should I do if the excel table after the dotted line cannot be printed?
    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
    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
    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 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
    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
    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 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 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 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 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?
    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
    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
    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
    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
    ​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.

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