Combine by category. For consolidation by category to work, the range of data on each source sheet must be in list format, without blank rows or blank columns in the list.

Send in your Surface. If none of the previous solutions have resolved your issue, you can send in your Surface. If you decide to send it in, go to Device service and repair and sign in with your Microsoft account. If your device is already registered, select it and follow the instructions.

Training: Watch and learn how to use PowerPoint in Windows. Explore PowerPoint training guides, articles, and how-to videos.

Security Note: Outlook Data File (.pst) passwords aren't intended to provide security against intentional malicious attempts to access your information. For a better way to restrict access to your data, create a password-protected Windows user account for any person who uses the computer.

You may see an "account frozen" message and icon if you have exceeded your storage allowance and/or haven't signed in for a long time. You just need to get back under your Microsoft storage quota to get access to your files again.

To start enjoying Microsoft Rewards, you just need a Microsoft account.It connects you to all things Microsoft with one simple logon. Sign up now by going to Microsoft Rewards.Select Sign up for free and follow the steps to create a Microsoft account.. If you already have a Microsoft account, great!

Set your default printer. For quicker printing, set a printer as the default printer. This process is different slightly among Windows 7, Windows 8, and Windows 10.

How to redeem a gift card, Xbox download code or token. Both Microsoft and Xbox gift cards and download codes and tokens work the same way: once redeemed to your Microsoft account, you can spend your balance at Microsoft Store online, on Windows or Xbox, and you can get downloads for the latest apps, games, movies, TV shows, and Surface, Xbox, and accessories.

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.

Upload files or folders to OneDrive. You can store over 300 types of files on OneDrive. With Microsoft Edge or Google Chrome: Select Add new > Files upload or Folder upload > Folder.