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：
-
- How to use the formula to calculate length of service in excel
- How to use the formula for calculating length of service in excel: first enter the formula "=YEAR()" in the cell; then enter "TODAY()" in the brackets; then continue to enter the formula "-YEAR(B2)", the complete formula is " =YEAR(TODAY())-YEAR(B2)”; finally press the Enter key.
- excel 24058 2020-03-29 09:19:01
-
- How to get the electronic version of the photo into the form
- How to get electronic photos into the table: Go to the "Insert" option in the toolbar above the table, click on the picture option, select the picture to be inserted in the pop-up dialog box, and then click "Insert".
- excel 37154 2020-03-28 15:45:17
-
- Why does the electronic form display garbled characters when entering the ID card number?
- The reason why the ID card number displayed in the spreadsheet is garbled is because the number we entered is too large, and EXCEL automatically changes the number into scientific notation. Solution: Change the column belonging to the ID number to "Text Format".
- excel 18182 2020-03-28 11:59:20
-
- Unreadable content found What should I do if I want to restore the contents of this workbook?
- Solution: First open [Control Panel]-[Uninstall a Program]; then check whether [office] exists; then if the office does not exist or there is an error in the installation address, reinstall it; finally re-open the file to return to normal.
- excel 38604 2020-03-28 11:47:28
-
- How to convert excel to pdf and keep it on one page
- How to convert excel to pdf and keep it on one page: first click to open the excel table; then click on the print area in the page layout tab; then select and adjust it in [Zoom] to [Print the entire worksheet on one page]; finally click [Confirm] That’s it.
- excel 80249 2020-03-28 09:25:39
-
- How to set excel table options
- How to set excel table options: first open the excel document, select the cells where you want to add drop-down options; then click "Data" -> "Data Validity" -> "Data Validity" in the menu; then click "Allow" Select the "Sequence" button below; finally click the OK button.
- excel 108526 2020-03-28 09:19:15
-
- How to set multiple contents in excel data validity
- How to set multiple contents in excel data validity: first open an EXCEL file on your computer; then select the target cell and click the "Data" option in the toolbar; then click the drop-down arrow next to "Data Validity"; and finally click "Data Validity" option, and enter the option content in the edit bar of the "Source" area.
- excel 35313 2020-03-28 09:12:28
-
- How to filter data with excel formula
- How to filter data with excel formula: first open the table that requires data; then enter the formula "=sum" to select the function "SUMPRODUCT"; then enter "()*()" in English after "SUMPRODUCT"; finally move the cursor Just click on "Score" in the first bracket.
- excel 12597 2020-03-28 09:07:52
-
- How to insert slash into table
- How to insert a slash: first enter the content to be edited in the editing area; then click the "Login" option and click the "Border" option; then select and confirm the displayed color; finally click "Insert" and select straight line insertion That’s it.
- excel 9319 2020-03-27 11:14:37
-
- How to lock a table from being modified
- How to lock the table from being modified: First open the Word document to be locked; then click "Review - Restrict Editing"; then in the "Restrict Formatting and Editing" dialog box that pops up, check "Allow only this type of editing in the document" "Edit"; finally set the password.
- excel 57929 2020-09-14 09:41:45
-
- How to use excel to determine whether it is a leap year
- How to use excel to determine whether it is a leap year: You can use the formula "=IF((MOD(A1,400)=0)+(MOD(A1,4)=0)" to determine whether it is a leap year, where A1 is the cell address.
- excel 22427 2020-03-26 11:25:07
-
- How to branch within a grid?
- How to branch rows in a cell: first click to select the word wrap text table; then right-click the cell; then select the "Alignment" option in the pop-up "Cell Format Settings" window; finally check "Automatic Wrap Words" and Just click "Confirm".
- excel 17261 2020-03-25 10:23:45
-
- What is the shortcut key for excel positioning conditions?
- The shortcut key for positioning criteria in Excel is "Ctrl+G". CTRL+G can open the "Location" window. There is a "Location Conditions" button on the positioning window. Click the "Targeting Criteria" button to open the "Targeting Criteria" window.
- excel 14625 2020-03-24 11:44:40
-
- How to lock part of the content in a cell from being modified
- Lock some cells in excel: Select the cells that need to be locked and right-click, click "Format Cells" in the pop-up menu, click the "Protect" tab in the pop-up "Custom Sequence" window, and then click "Lock" ” checkbox and click “OK”.
- excel 15520 2020-03-24 11:24:00
-
- How to export tables in pdf
- How to export tables in pdf: first open the PDF file that needs to be copied; then select all the data that needs to be copied; then open Excel, right-click on the blank cell and click "Paste"; finally set in the "Text Import Wizard" Just import the format.
- excel 32257 2020-03-24 09:50:14
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
