Create a drop-down list - Microsoft Support
网页Excel. Enter and format data. Data validation. Create a drop-down list. You can help people work more efficiently in worksheets by using drop-down lists in cells. Drop-downs allow people to pick an item from a list that you create. Windows macOS Web. In a new worksheet, type the entries you want to appear in your drop-down list.
Repair a corrupted workbook - Microsoft Support
网页Choose one of the following methods to help recover your data. If it’s not successful, try another method. You can also try third-party software solutions to try to recover workbook.
Switch between languages using the Language bar - Microsoft …
网页Click the language icon on the Language bar, which should appear on your task bar near where the clock is, and then click the language that you want to use. Keyboard shortcut: To switch between keyboard layouts, press Alt+Shift. Note: The icon is just an example; it shows that English is the language of the active keyboard layout.
Overview of formulas in Excel - Microsoft Support
网页The parts of an Excel formula. Using constants in Excel formulas. Using references in Excel formulas. Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities.
Combine first and last names - Microsoft Support
网页Let's say you want to create a single Full Name column by combining two other columns, First Name and Last Name. To combine first and last names, use the CONCATENATE function or the ampersand (&) operator.
Find or replace text and numbers on a worksheet
网页In the Find what box, type the text or numbers you want to find, or select the arrow in the Find what box, and then select a recent search item from the list. Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your search criteria.
View, manage, and install add-ins for Excel, PowerPoint, and Word ...
网页Select File > Get Add-ins. Alternatively, you can also view your add-ins directly from the Home tab by selecting Add-ins. You can directly install add-ins from this page or select More Add-ins to explore. In the Office Add-ins dialog, select My Add-ins tab.
Combine text from two or more cells into one cell
网页Select the cell you want to combine first. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text. Close the formula with a parenthesis and press Enter. An example formula might be =CONCAT (A2, " Family"). See also. TEXTJOIN function. CONCAT function. Merge and unmerge cells.
Create a relationship between tables in Excel - Microsoft Support
网页Have you ever used VLOOKUP to bring a column from one table into another table? Now that Excel has a built-in Data Model, VLOOKUP is obsolete. You can create a relationship between two tables of data, based on matching data in each table.
Add or remove series lines, drop lines, high-low lines, or up …
网页Excel for Microsoft 365 Outlook for Microsoft 365 More... You can add predefined lines or bars to charts in several apps for Office. By adding lines, including series lines, drop lines, high-low lines, and up-down bars, to specific chart can …
Find and remove duplicates - Microsoft Support
网页Select the cells you want to check for duplicates. Note: Excel can’t highlight duplicates in the Values area of a PivotTable report. Select Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values. In the box next to values with, pick the formatting you want to apply to the duplicate values, and then select OK.