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：
-
- Excel sets date value to automatically change color when it expires
- The method to set the date value to automatically change color when it expires in Excel is: 1. First, select the cells that need to be set; 2. Then, click [Conditional Formatting] and select [New Rule]; 3. Finally, enter the formula and set the color. .
- excel 35337 2020-02-29 15:06:36
-
- Create a transparent official seal in Excel
- The method to make a transparent official seal in Excel is: 1. First, insert the seal into the Excel table; 2. Then, switch to the [Format] tab; 3. Then, click the color shortcut key and select the transparent color; 4. Finally, click on the white color of the picture area is enough.
- excel 14292 2020-02-29 14:53:27
-
- excel displays gray and cannot be edited
- The solution to the problem that Excel is grayed out and cannot be edited is: 1. First, open the Excel table and switch to the [View] tab; 2. Then, click the [Unhide] option in the View tab; 3. Finally, in the pop-up dialog Just select the desired table name in the box.
- excel 24436 2020-02-29 14:34:05
-
- How to set full screen display in excel
- The method to set full-screen display in excel is: 1. First, open the excel table and switch to the [View] tab; 2. Then, find the [Full-screen display] option in the view menu bar and click it.
- excel 15074 2020-02-29 14:26:36
-
- How to set row height in excel
- The method to set the row height in Excel is: 1. First, select the table where the row height needs to be set; 2. Then, click [Start], [Cells], [Format], [Row Height]; 3. Finally, as needed Just set the row height size.
- excel 6893 2020-02-29 11:25:38
-
- How to freeze two rows in excel
- How to freeze two rows in excel: first open an excel table file; then open the View menu in excel and click Freeze Window; then select the freeze split window command in the drop-down box; finally select OK to freeze the two rows.
- excel 8329 2020-02-29 10:53:28
-
- Excel sets a header title for each page of the table
- The method for setting a header title on each page of a table in Excel is: 1. First, open [Page Layout] and [Page Setup] in order; 2. Then, switch to the [Worksheet] tab and find [Top Title Row]. Select the header part and click OK.
- excel 12321 2020-02-29 10:52:21
-
- How to format excel table
- How to format an excel table: first select the "Student ID" column; then right-click and "Format Cells"; then in the number options, select "Text" and click "OK"; finally, right-click and "Format Cells" And set the value, click "OK".
- excel 22332 2020-02-29 09:14:48
-
- How to delete commas in batches in excel
- How to delete commas in batches in Excel: Select the cell where the commas you want to delete are located, use the "CTRL+F" shortcut key to open the "Find and Replace" dialog box, enter the Replace tab, set the search content to ",", and then click Replace All Can.
- excel 12862 2020-02-28 16:41:42
-
- How to select all in excel
- How to select all down in excel: shift+ctrl+x down arrow to select all down (only ctrl+shift+down arrow can also select the current column), release ctrl, and use shift+up arrow.
- excel 59894 2020-02-28 10:19:35
-
- How to create a group in excel
- How to create a group in excel: first open the excel file; then select the row or column where the group needs to be created; then click on the data in the menu bar; finally click on "Create Group" in the toolbar.
- excel 15935 2020-02-28 10:00:18
-
- What to do if excel hyperlink cannot be opened
- The solution to the problem that the excel hyperlink cannot be opened: first open the start menu, enter "regedit" in run and press Enter; then navigate to the "HKEY_CURRENT_USER\Software\Classes\.html" item in the registry and modify it.
- excel 10017 2020-02-28 09:50:15
-
- How to calculate average score in excel
- How to calculate the total score and average score in Excel: first enter the summation SUM function "=SUM(B2:D2)" in the total score cell E2, and then press the enter key; then enter the average number AVERAGE in the average score cell F2 Just use the function "=AVERAGE(B2:D2)".
- excel 35418 2020-02-28 09:42:31
-
- How to solve illegal input values in Excel table
- The solution to the illegal input value in the excel table: first enter a data in the cell to be modified; then select the cell and select the data "validity" in the menu; then modify the maximum value in the settings; finally cancel the error warning checkbox.
- excel 24400 2020-02-28 09:25:20
-
- How to sort excel tables from large to small
- How to sort an excel table from large to small: first open the Excel table program and enter the main interface of the Excel table program; then open a table data that needs to be sorted from large to small in the Excel program and select them all; finally click on the Excel program Just click the "descending" mark on the main interface.
- excel 29001 2020-02-28 09:20:20
Recommended Articles
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
