How to find and enable missing Copilot button in Microsoft 365 …
网页Select File > Account. Under Account Privacy select Manage Settings. 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.
Change the colors in a text box or shape - Microsoft Support
网页On the Drawing Tools Format tab, click Text Fill > More Fill Colors. In the Colors box, either click the color you want on the Standard tab, or mix your own color on the Custom tab. Custom colors and colors on the Standard tab aren't updated if you later change the document theme.
Text Import Wizard - Microsoft Support
网页As an alternative, you can import a text file by connecting to it with Power Query. Go to the Data tab > Get External Data > From Text. Then, in the Import Text File dialog box, double-click the text file that you want to import, and the Text Import Wizard dialog will open.
Where are my worksheet tabs? - Microsoft Support
网页Learn how to show the worksheet tabs at the bottom of your Excel workbook.
Date and time functions (reference) - Microsoft Support
网页Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.
Search in a PivotTable field list in Excel for Windows
网页Use the new built-in search functionlity in Excel 2016 for Windows to quickly search for a field in the PivotTable Fields pane. This is very handy if you have a long list of fields that you have to scroll to see.
Refresh an external data connection in Excel - Microsoft Support
网页You can refresh the data for PivotTables connected to external data, such as a database (SQL Server, Oracle, Access, or other), Analysis Services cube, data feed, as well as data from a source table in the same or a different workbook. PivotTables can be refreshed manually or automatically when you open the workbook.
Accessibility best practices with Excel spreadsheets
网页This topic gives you step-by-step instructions and best practices for making your Excel spreadsheets accessible and unlock your content to everyone, including people with disabilities. You learn, for example, how to work with the Accessibility Checker to tackle accessibility issues while you're creating your spreadsheet.
Save a workbook to text format (.txt or .csv) - Microsoft Support
网页Open the workbook you want to save. Click File > Save As. Pick the place where you want to save the workbook. In the Save As dialog box, navigate to the location you want. Click the arrow in the Save as type box and pick the type of text or CSV file format you want.