Combine text and numbers - Microsoft Support
网页Combine text and numbers. Let's say you need to create a grammatically correct sentence from several columns of data to prepare a mass mailing. Or, maybe you need to format numbers with text without affecting formulas that use those numbers. In Excel, there are several ways to combine text and numbers.
Create a 3-D reference to the same cell range on multiple …
网页A 3-D reference is useful and convenient way to reference several worksheets that follow the same pattern and cells on each worksheet contain the same type of data, such as when you consolidate budget data from different departments in your organization.
Wrap text in a cell - Microsoft Support
网页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. (On Excel for desktop, you can also select the cell, and then press Alt + H + W.)
Start a new line of text inside a cell in Excel - Microsoft Support
网页To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press Alt+Enter to insert a line break. Double-click the cell in which you want to insert a line break.
Include text in formulas - Microsoft Support
网页To include text in your functions and formulas, surround the text with double quotes (""). The quotes tell Excel it's dealing with text, and by text, we mean any character, including numbers, spaces, and punctuation. Here's an example: =A2&" sold "&B2&" units."
Replace a formula with its result - Microsoft Support
网页Replace a formula with its result. You can convert the contents of a cell that contains a formula so that the calculated value replaces the formula. If you want to freeze only part of a formula, you can replace only the part you don't want to recalculate.
Curve text around a circle or other shape - Microsoft Support
网页You can use WordArt with a Transform text effect to curve or bend text around a shape. If you want the text to circle the shape, you can also do this, but it’s a little bit more work. You can also insert WordArt multiple times to wrap text around shapes with straight edges.
Create a simple formula in Excel - Microsoft Support
网页The following is an example of a simple formula. On the worksheet, select the cell in which you want to enter the formula. Type the = (equal sign) followed by the constants and operators (up to 8192 characters) that you want to use in …
How to compare data in two columns to find duplicates in Excel
网页How to compare data in two columns to find duplicates in Excel. You can use the following methods to compare data in two Microsoft Excel worksheet columns and find duplicate entries.
Create a timeline - Microsoft Support
网页Create a timeline in Project. Get Microsoft timeline templates. Learn how to create a timeline in Microsoft Office apps. Create a graphical representation of a sequence of events with the SmartArt graphic timeline.
Insert a check mark symbol - Microsoft Support
网页You can easily insert a check mark (also known as a "tick mark") in Word, Outlook, Excel, or PowerPoint. These marks are static symbols. If you're looking for an interactive check box that you can click to check or uncheck, see: Add a check box or option button (Excel) or Make a checklist in Word.