current location：Home > Technical Articles > Topics > excel
- Direction：
- All web3.0 Backend Development Web Front-end Database Operation and Maintenance Development Tools PHP Framework Common Problem Other Tech CMS Tutorial Java System Tutorial Computer Tutorials Hardware Tutorial Mobile Tutorial Software Tutorial Mobile Game Tutorial
- Classify：
-
- What is the shortcut key ctrl for deleting rows in excel?
- The shortcut key for deleting rows in Excel is ctrl plus "-(minus sign)". Specific operation: first open an excel table; then select an entire row of data in the table; finally press the "Ctrl" and "-" keys on the keyboard to delete the entire row of data.
- excel 55006 2021-03-12 16:21:15
-
- How to subtract dates in excel to get the number of days
- How to get the number of days by subtracting dates in excel: first open the Excel table file; then set the cell value format to "date type"; finally, use the formula "B1-A1" and click to set the cell to "numeric type" and click Just "OK".
- excel 61826 2023-01-13 00:41:49
-
- Why is there no 0 in the Excel table?
- There are no 0s in the Excel table because the format of the cells has not been changed. The solution: first open the EXCEL software; then right-click the table where you need to add "0"; then click Set Cell Format, and in the pop-up dialog box Select "Text"; finally re-enter 0.
- excel 28171 2023-01-13 00:41:49
-
- How to display duplicate data
- How to display duplicate data: First open the Excel table and set rules for column A; then select column A and click "Conditional Formatting"; then select "Highlight Cell Rules"; finally click "Duplicate Values" and click " OK”.
- excel 56622 2023-01-13 00:41:49
-
- How to encrypt tables
- How to encrypt the table: first click the "File" menu bar and select "Information"; then click "Protect Workbook" and select "Encrypt with Password" in the pop-up drop-down list; finally enter the created password in the text box File password, click "OK".
- excel 74081 2023-01-13 00:41:49
-
- How to create a new worksheet in excel
- How to create a new worksheet in Excel: First open the Excel software, there are three Sheets in the lower left corner of the table; then move the mouse to the area with the "little sun" or "+" sign on the right side of Sheet3, click on this area A new worksheet can be created.
- excel 30880 2021-03-05 15:21:09
-
- Where on the worksheet are the worksheet labels located?
- The worksheet label is in the lower left corner of the worksheet. Open the workbook. By default, there will be three tabs, sheet1, sheet2, and sheet3, in the lower left corner. They are the worksheet tabs. The role of the worksheet label: Each worksheet has a name, and the worksheet name is displayed on the worksheet label.
- excel 28167 2021-03-05 14:40:43
-
- How to remove table lines in excel
- How to remove excel table lines: 1. Click on the view in excel, then find the grid lines in "Show\Hide", and uncheck the previous default check; 2. Find "Fill Color" in the menu bar, and then select Just white.
- excel 112323 2021-03-05 11:43:31
-
- How to merge merge tables
- How to merge tables: first open one of the tables; then click "Data" and select "Import from XML data"; then find the second table to open, and click on the first table "Sheet1"; finally import the data worksheet location, And click "Blank Cell".
- excel 128482 2023-01-13 00:41:48
-
- What should I do if all excel sheets cannot be opened?
- The solution to the problem that all excel sheets cannot be opened: first open the control panel in the start menu; then find the program options in the control panel; then find the office software, right-click and select [Change]; finally execute the office repair program. .
- excel 70322 2023-01-13 00:41:48
-
- How to fix the first row of cells
- How to fix the first row of a cell: first open the Excel table and enter the content that needs to be fixed to the top in the first row; then select the content that needs to be fixed in the first row of the excel table; then find it on the right in the "Start" function interface "Freeze Window" button; finally click "Freeze First Column".
- excel 126362 2023-01-13 00:41:48
-
- How to type when an Excel table is divided into two slashes
- How to divide an Excel table into two slashes and type: first open the excel table; then insert a slash in cell A1; then click the "Insert" option in the toolbar, and click the "Line" style in "Shapes" ; Finally, draw a slash and enter two lines of text in the cell.
- excel 126610 2023-01-13 00:41:48
-
- How to draw a line in an EXCEL cell
- How to draw a line in an EXCEL cell: first select the cell and choose to format the cell; then click "Font" and put a check in front of the special effect strikethrough; finally click the OK button in the lower right corner.
- excel 41538 2021-03-01 10:24:56
-
- How to transpose excel function
- How to transpose the excel function: First select the required transpose function TRANSE and click OK; then select the matrix that needs to be transposed and press "Ctrl+Shift+Enter" at the same time; finally press "Ctrl" at the same time again +Shift+Enter".
- excel 18434 2023-01-13 00:41:48
-
- Which key is the excel division sign?
- How to find the division sign in Excel: first left-click to select the cell where the division sign needs to be inserted; then click Insert at the top and click on the special symbol; then left-click the mouse to select the mathematical symbol; finally find and click the mouse under the mathematical symbol Left click to select the division sign.
- excel 29041 2023-01-13 00:41:47
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
