Insert ASCII or Unicode Latin-based symbols and characters
To insert an ASCII character, press and hold down ALT while typing the character code. For example, to insert the degree (º) symbol, press and hold down ALT while typing 0176 on the numeric keypad. You must use the numeric keypad to type the numbers, and not the keyboard.
How to find and enable missing Copilot button in Microsoft 365 …
There are two settings here that can cause Copilot to not appear in your Microsoft 365 apps. First confirm that Experiences that analyze your content is turned on. Then scroll down and make sure that All connected experiences is turned on. Learn more. Copilot Lab - Start your Copilot journey!
Convert numbers stored as text to numbers - Microsoft Support
Numbers that are stored as text can cause unexpected results, like an uncalculated formula showing instead of a result. You can use the VALUE function to return just the numeric value of the text. Click and drag down to fill the formula to the other cells.
File formats that are supported in Excel - Microsoft Support
Lists the file formats that are supported in Excel. The topic also includes a list of unsupported file formats and some suggested workarounds.
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 the calculation. For our example, type =1+1.
Create a named range from selected cells in a worksheet
You can quickly create a named range by using a selection of cells in the worksheet. Note: Named ranges that are created from selecting cells have a workbook-level scope. Select the range you want to name, including the row or column …
Use Excel with earlier versions of Excel - Microsoft Support
What to do In the Compatibility Checker, click Find to locate cells that contain a conditional formatting type on a nonadjacent range, and then make the necessary changes to use conditional formatting rules that are available in earlier versions of Excel.
Format numbers as percentages - Microsoft Support
Learn how to display numbers as percentages in Excel and view examples of several basic techniques for calculating percentages in your worksheet.
Open files from the File menu - Microsoft Support
Click the Browse button at the bottom of the places list on the left. When the Open dialog box appears, type the text you want to search for in the Search box at the top right and press enter. A list of matching documents will appear for you to choose from.
Using wildcard characters in searches - Microsoft Support
Use wildcard characters as comparison criteria for text filters and when you're searching and replacing content. These can also be used in the Conditional Formatting rules that use the "Format cells that contain specific text" criteria.
Import or export text (.txt or .csv) files - Microsoft Support
There are two ways to import data from a text file with Excel: you can open it in Excel, or you can import it as an external data range. To export data from Excel to a text file, use the Save As command and change the file type from the drop-down …