GETPIVOTDATA function - Microsoft Support
Argument. Description. data_field. Required. The name of the PivotTable field that contains the data that you want to retrieve. This needs to be in quotes.
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, Excel 2013
Change the scale of the horizontal (category) axis in a chart
To change the axis type to a text or date axis, expand Axis Options, and then under Axis Type, select Text axis or Date axis.Text and data points are evenly spaced on a text axis. A date axis displays dates in chronological order at set intervals or base units, such as the number of days, months or years, even if the dates on the worksheet are not in order or in the same base units.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook 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, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Excel 2021 for Mac, Word 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Excel 2019 for Mac, Word 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016
Use Microsoft Authenticator with Microsoft 365
Choose the mobile app. Open a browser on your computer and go to portal.office.com.Sign in to your Office 365 for business account.
Applies To: Office for business, Microsoft 365 admin
Troubleshoot your Surface Pen - Microsoft Support
Note: Our premium Surface Slim Pen 2 is equipped with an easily removable pen tip.Removal is intended only for pen tip replacement. Excessive (500 or more) removal+ reinsertion cycles of the pen tip can damage the internal parts of the pen and lead to inking failures.
Troubleshoot Surface Type Cover or Keyboard - Microsoft Support
You'll see the logo screen on your screen. Continue to hold the Volume Up button. Release the button when the UEFI screen appears. If you have a Windows Pro/Enterprise device (not a Windows Home device), you can then toggle off Type Cover port from the Devices menu and exit UEFI. Re-enter UEFI (press power + Volume Up) and toggle Type Cover port back on, then check if the Keyboard works in UEFI.
All about Xbox Game Pass Friends & Family | Xbox Support
Starting July 14, 2023: Existing Primary and Secondary members will be emailed details describing this change.; Starting July 17, 2023: Primary account holders will no longer be able to add new members to their shared membership.; August 15, 2023: Existing memberships will end and Xbox Game Pass Friends & Family will no longer be available.; Starting August 15, 2023: We’ll be sending Xbox ...
Organize your ideas with Collections in Microsoft Edge
Collections in Microsoft Edge helps you keep track of your ideas on the web, whether you're shopping, planning a trip, collecting notes for research or lesson plans, or just want to pick up where you left off the last time you were browsing the internet.
Track my Microsoft Rewards orders - Microsoft Support
If you want to track your Microsoft Rewards order after you redeem an award, sign in to the Rewards page with your Microsoft account, select Redeem and then select Order history.On the Order history page, find your order and then look under Status.. Open Rewards dashboard
Excel specifications and limits - Microsoft Support
Workbooks with the "Allow changes by more than one user..." setting enabled. If the Allow changes by more than one user... setting is on for a workbook, then the following information applies. This setting is accessible by clicking the Review tab > Share Workbook.Note that in newer versions of Excel, the Share Workbook button has been hidden. To unhide it, click File > Options > Quick Access ...
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Apply sensitivity labels to your files and email - Microsoft Support
You can apply sensitivity labels to your files and emails to keep them compliant with your organization's information protection policies. Sensitivity labels are configured by your administrator and because they're published to users rather than locations such as sites and mailboxes, users in the same organization might see different sensitivity labels to apply.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel for the web, Word for the web, PowerPoint for the web, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Outlook on the web, Excel for iPad, Word for iPad, PowerPoint for iPad, Excel for iPhone, Word for iPhone, PowerPoint for iPhone, Word for Android tablets, Excel for Android tablets, PowerPoint for Android tablets, Excel for Android phones, New Outlook for Windows, Outlook for Android, Outlook for iOS, PowerPoint for Android phones, Word for Android phones