"Access Denied" or other errors when you access or work with files and ...
If the Encrypt contents to secure data check box is selected, you have to have the certificate that was used to encrypt the file or folder to be able to open it. In this situation, you should obtain the certificate from the person who created or encrypted the file or folder, or have that person decrypt the file or folder.
Transfer files to your personal OneDrive with the Mover Transfer Wizard
There could be various reasons why you want to move OneDrive files from one account to another. You’ve worked hard on your school projects and want to transfer the files in the cloud storage you use at school to your personal OneDrive before you graduate, to use for your resume, portfolio, or even work-related projects.
Applies To: OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Managing parental consent - Microsoft Support
Helping users safely navigate web, app, and game content is one of Microsoft’s top priorities. If you live in a region that requires permission to create an account and access Microsoft services, you may be prompted to request or give parental consent.
Applies To: Microsoft account dashboard
Create a poll in Microsoft Teams - Microsoft Support
With Poll, you can get constructive feedback on questions by creating a real-time poll right from a chat or channel in Teams. Create a poll. To create a poll, click Menu (…) below the box where you type your message. If Poll isn’t in the Suggestions section, search for it in the Find an app search bar or select More apps to find it in the Apps directory.
Applies To: Microsoft Kaizala, Microsoft Teams
Create a workbook in Excel for the web - Microsoft Support
Notes: If you're using the desktop version of Excel on a Windows PC, see this Excel Quick Start.. If you're using the desktop version of Excel on a Mac, see Office for Mac Quick Start Guides and Excel for Mac Help.
Applies To: Excel for the web
Configure your Xbox Elite Wireless Controller Series 2
Note Configuration changes made on the Xbox Accessories app and saved to a profile get saved to the controller itself. This means that those configurations can be brought to any device the Xbox Elite Wireless Controller Series 2 is compatible with, including mobile devices and newer Samsung TVs.
Guidelines and examples of array formulas - Microsoft Support
An array formula (one that spans multiple cells) can do calculations on rows and columns of cells where you might otherwise need to use several formulas. For example, you can count the number of characters that are contained in a range of cells, sum only numbers that meet certain conditions (such as the lowest values in a range or numbers that fall between an upper and lower boundary), and sum ...
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 for iPad, Excel for iPhone
Keyboard shortcuts in apps - Microsoft Support
Press this key. To do this. Arrow keys. Pan the map in any direction. Ctrl + plus or minus key (+ or -) Zoom in or out. Ctrl + Left or Right arrow keys. Rotate
SORT function - Microsoft Support
The SORT function will return an array, which will spill if it's the final result of a formula. This means that Excel will dynamically create the appropriate sized array range when you press ENTER.If your supporting data is in an Excel Table, then the array will automatically resize as you add or remove data from your array range if you're using Structured References.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Use AND and OR to test a combination of conditions
When you need to find data that meets more than one condition, such as units sold between April and January, or units sold by Nancy, you can use the AND and OR functions together. Here's an example:
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016