Create, edit, and manage connections to external data
Note The Queries & Connections pane is available in Microsoft Office 365 for Excel and Excel stand-alone version 2019 or later. It replaced the Workbook Connections dialog box which is available in desktop versions of Excel.. The Queries & Connections pane (Select Data > Queries & Connections) In one location, you can get to all the information and commands you need to work with your external ...
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
SUBTOTAL function - Microsoft Support
This article describes the formula syntax and usage of the SUBTOTAL function in Microsoft Excel.. Description. Returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it by editing the SUBTOTAL function.
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
Windows Server 2022 update history - Microsoft Support
Updates for Windows Server 2022. Windows Server 2022 is the latest release in our Long-Term Servicing Channel (LTSC). It builds on Windows Server 2019, our fastest adopted Windows Server ever.
Outline (group) data in a worksheet - Microsoft Support
If you want, your grouped detail rows can have a corresponding summary row—a subtotal. To create these, do one of the following: Insert summary rows by using the Subtotal command . Use the Subtotal command, which inserts the SUBTOTAL function immediately below or above each group of detail rows and automatically creates the outline for you. For more information about using the Subtotal ...
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Set up the Xbox Wireless Adapter for Windows | Xbox Support
If you're using the adapter on a desktop or other device in which the USB port doesn't face the controller or is blocked by metallic objects, use the included USB extender to avoid wireless interference and maintain a good line of sight to your controller.
View printer queue in Windows - Microsoft Support
Select your printer from the list and then select Open queue to see a list of what's printing and the upcoming print order.
Windows location service and privacy - Microsoft Support
To control location for just your user account, switch the Let apps access your location setting On or Off.If "Location services is off" appears on the settings page, you won't be able to turn on the Let apps access your location setting for an individual user account.
I can't sign in to my Microsoft account - Microsoft Support
If you can't sign into your Microsoft account, most issues can be identified by our sign-in helper tool. The tool will ask you to enter the email address or mobile phone number you're trying to sign in with and check the details you provide.
Applies To: Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, Microsoft 365 for home, Outlook.com, GroupMe, Microsoft account dashboard, Microsoft Teams, Microsoft Teams personal, Microsoft To Do, OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows, Outlook for Android, Outlook for iOS
Utiliser des clés de produit avec Office - Support Microsoft
Si un écran Prise en main propose des options permettant d’essayer, d’acheter ou d’activer Office, cela signifie qu’Office est installé sur votre nouvel ordinateur en tant que version d’évaluation d’1 mois d’Microsoft 365 Famille. Vous ne recevrez pas de clé de produit de la part du fabricant de votre ordinateur, sauf si vous avez acheté une carte de clé de produit Office.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Microsoft 365 for home, InfoPath 2013
Stop Microsoft Edge from starting automatically
If you don't want Microsoft Edge to start when you sign in to Windows, you can change this in Windows Settings. 1. Go to Start > Settings .. 2. Select Accounts > Sign-in options.. 3. Turn off Automatically save my restartable apps and restart them when I sign in.