Filter by using advanced criteria - Microsoft Support
网页You can compare two values by using the following operators. When two values are compared by using these operators, the result is a logical value—either TRUE or FALSE. Using the equal sign to type text or a value.
Insert or delete rows and columns - Microsoft Support
网页Overview of formulas in Excel. You can add columns, rows, or cells to an Excel worksheet or delete them. Columns insert to the left, rows above, and cells above or to the left.
About Office: What version of Office am I using? - Microsoft …
网页Learn how to check what version of Office your using. Find your product name and version number of Office apps.
Sort data in a table - Microsoft Support
网页Sort data in a table. Sorting is one of the most common tools for data management. In Excel, you can sort your table by one or more columns, by ascending or descending order, or do a custom sort.
Excel file is locked for editing - Microsoft Support
网页Find out how you can unlock an Excel spreadsheet when you are locked out of an Excel file by yourself or by another user.
Wrap text in a cell - Microsoft Support
网页Microsoft Excel can wrap text so it appears on multiple lines in a cell. You can format the cell so the text wraps automatically, or enter a manual line break. Wrap text automatically. In a worksheet, select the cells that you want to format. On the Home tab, in the Alignment group, select Wrap Text.
Edit SVG images in Microsoft 365 - Microsoft Support
网页Microsoft Word, PowerPoint, Outlook, and Excel for Microsoft 365 on Windows, Mac, Android, and Windows Mobile support inserting and editing scalable vector graphics (.SVG) files in your documents, presentations, email messages, and workbooks. On iOS you can edit SVG images that you've already inserted on another platform.
Format an Excel table - Microsoft Support
网页Convert an Excel table to a range. Filter data in a range or table. Format an Excel table by applying different table styles or colors.
Define and solve a problem by using Solver - Microsoft Support
网页Solver is a Microsoft Excel add-in program you can use for what-if analysis. Use Solver to find an optimal (maximum or minimum) value for a formula in one cell — called the objective cell — subject to constraints, or limits, on the values of other formula cells on a worksheet.
Video: Add and review comments - Microsoft Support
网页Collaborate with others to give notes and feedback on a document by using comments. Note: Comments work similarly in Word, Excel, and PowerPoint. However, the following steps are specific to Word.
IRR function - Microsoft Support
网页Syntax. IRR (values, [guess]) The IRR function syntax has the following arguments: Values: Required. An array or a reference to cells that contain numbers for which you want to calculate the internal rate of return. Values must contain at least one positive value and one negative value to calculate the internal rate of return.