Using structured references with Excel tables - Microsoft Support
In our example data, we used the name DeptSales.. Use the following rules for table names: Use valid characters Always start a name with a letter, an underscore character (_), or a backslash (\).Use letters, numbers, periods, and underscore characters for the rest of the name.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel 2013, Excel Mobile
Uninstall Office for Mac - Microsoft Support
Ctrl+click the application you selected and click Move to Trash.
Applies To: Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, OneNote for Microsoft 365 for Mac, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, PowerPoint 2021 for Mac, OneNote 2021 for Mac, Office 2021 for Mac, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, OneNote 2019 for Mac, Office 2019 for Mac, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Microsoft 365 for Mac
How to go passwordless with your Microsoft account
Going passwordless refers to removing your password and using a passwordless method to sign in instead. Passwordless solutions such as Windows Hello, the Microsoft Authenticator app, SMS or Email codes, and physical security keys provide a more secure and convenient sign-in method. While passwords can be guessed, stolen, or phished, only you can provide fingerprint authentication, or provide ...
Applies To: Microsoft account dashboard
DATEDIF function - Microsoft Support
Argument. Description. start_date . Required. A date that represents the first, or starting date of a given period. Dates may be entered as text strings within quotation marks (for example, "2001/1/30"), as serial numbers (for example, 36921, which represents January 30, 2001, if you're using the 1900 date system), or as the results of other formulas or functions (for example, DATEVALUE("2001 ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, SharePoint Foundation 2010, SharePoint Server 2010, Windows SharePoint Services 3.0
Choose between the 64-bit, 32-bit, and ARM version of OneDrive
If you're not sure which OneDrive version is better for you, you can review the reasons to choose the 64-bit version, the 32-bit version, ARM64 version for Windows, or the Apple silicon version for Mac. If you know what version you want, you can learn how to install it.. If you already have OneDrive, but you're not sure which version you have, check out Which version of OneDrive am I using?
Applies To: OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Get started with Copilot in Microsoft Teams meetings
From the meeting chat, select Open Copilot in the upper-right corner of the chat—you'll see the Copilot icon.From here, Copilot bases responses on the meeting transcript, not the meeting chat. You'll see the same conversation history with Copilot as the one accessed from Recap.Select View prompts to choose from the suggestions, or try the following prompts:
Applies To: Microsoft Teams
Sync your account in Outlook to the Microsoft Cloud
To enhance your Microsoft 365 experience in new Outlook for Windows, Outlook.com, Outlook for iOS, Outlook for Android, and new Outlook for Mac, you can now sync your non-Microsoft accounts (including their emails, contacts, and events) to the Microsoft Cloud.
Applies To: Outlook 2021 for Mac, Outlook 2019 for Mac, Outlook.com, New Outlook for Windows, Outlook for Android, Outlook for iOS
How do I turn on AutoSave? - Microsoft Support
If you open an Office file from your recent files list via the Taskbar or the Office app, you will need to open the file as described above to enable AutoSave.. To check, hover your mouse over the recent list: Files that begin C:\Users\ in their path will not open with AutoSave, but files with https:// will.. Close and re-open the file from within the Microsoft 365 app, not the recent file list.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Import data from data sources (Power Query) - Microsoft Support
By default, the Encrypt connection check box is selected to signify that Power Query connects to your database using an encrypted connection. If you do not want to connect using an encrypted connection, clear this check box, and then click Connect.. If a connection to your SQL Server is not established using an encrypted connection, Power Query prompts you to connect using an unencrypted ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2019, Excel 2016, Excel 2013
Cancel your Microsoft subscription - Microsoft Support
Note: In the following countries, you can cancel your subscription, and depending on the subscription length you may be entitled to a prorated refund.See Countries with prorated refunds for Microsoft subscriptions for more information. Any subscription length - Canada, Israel, Korea, and Turkey Subscriptions longer than 1 month and renewed - Denmark, Finland, Germany (purchases on or after ...
Applies To: Microsoft account dashboard