current location:Home > Technical Articles > Topics > excel

  • How to set excel cross cursor
    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?
    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 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 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?
    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?
    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
    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?
    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 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?
    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?
    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?
    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 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 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 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

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