Load the Analysis ToolPak in Excel - Microsoft Support
If you need to develop complex statistical or engineering analyses, you can save steps and time by using the Analysis ToolPak. You provide the data and parameters for each analysis, and the tool uses the appropriate statistical or engineering macro functions to calculate and display the results in an output table.
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
Transpose (rotate) data from rows to columns or vice versa
Verify these formulas use absolute references—if they don’t, you can switch between relative, absolute, and mixed references before you rotate the data. If you want to rotate your data frequently to view it from different angles, consider creating a PivotTable so that you can quickly pivot your data by dragging fields from the Rows area to ...
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Edit your existing headers and footers - Microsoft Support
Change your document's header or footer text, remove the first page header or footer, add page numbers, images, or change colors and fonts on headers and footers.
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
Keyboard shortcuts for Outlook - Microsoft Support
Top of Page. Contacts (People) keyboard shortcuts. The People view is your address book in Outlook where your personal contacts are stored and where you can open any address book that has been set up for your organization. The People, Mail, and Calendar views work together so you can easily send mail to and schedule appointments with your most important people.
Applies To: Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, Outlook on the web, Outlook.com, New Outlook for Windows, Outlook for iOS, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019, Outlook Web App
Insert a document in Word - Microsoft Support
Insert the content of a previously-created document. ... Important: If you want to insert the header and footer also, be sure to insert the text from the file in a new section so that the header and footer are applied to only those pages.For more info on sections, see Insert a section break.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016, Word 2013
Restrictions and limitations in OneDrive and SharePoint
What's new. 1 May 2023: Updated invalid characters and invalid file and folder names. 12 April 2021: Added 50,000 item sharing limits note.. 3 March 2021: Maximum file upload size updated to 250 GB.. 16 September 2020: Updated info about OneNote notebooks to clarify that the 2GB file size limit applies to SharePoint as well as OneDrive. 31 August 2020: Updated the invalid or blocked file types ...
Applies To: SharePoint Server 2019, SharePoint in Microsoft 365, Microsoft 365 admin, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows, SharePoint in Microsoft 365 Small Business, SharePoint operated by 21Vianet
Camera doesn't work in Windows - Microsoft Support
If you don’t find a solution, go ahead and share details about your experience there, then check back later for responses. Submit feedback. If you've tried the steps in this article and don't find a solution that works, use Windows Feedback Hub to report an issue. This will help Microsoft find the cause of this problem and improve your ...
Manage notifications in Microsoft Teams - Microsoft Support
Missed activity emails. In the Missed activity emails section, you’re able to set the frequency of summary emails detailing your missed activity, or turn this feature off.. Chats and channels notifications. Notifications for chats and channels can be managed at a granular level, allowing you to customize your notifications to your personal work style.
Applies To: Microsoft Teams
Set up rules in Outlook - Microsoft Support
Select a condition, and what to do with the message based on the condition. For example, to move messages with a certain title to a specific folder, select the Subject contains condition, select Move the item to folder, select or create a New folder, and then select OK.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Curve text around a circle or other shape - Microsoft Support
Advanced techniques. Wrap around a circle To create text that completely circles your shape, choose Circle under Follow Path, and then drag any of the sizing handles until your WordArt is the size and shape you want.. Wrap around straight edges To wrap text around a shape that has straight edges, such as a rectangle, insert WordArt objects for each edge.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Project Online Desktop Client, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Word for the web, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Project Professional 2021, Project Standard 2021, Word 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Project Professional 2019, Project Standard 2019, Word 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Project Professional 2016, Project Standard 2016