Learn how to redeem a gift card, code, or Office product key and spend your balance at Microsoft Store online, on Windows, or Xbox.

There are four ways to open Snipping Tool: Select the Start button, enter snipping tool, then select Snipping Tool from the results. Press Windows logo key + Shift + S for a static image snip. Press Print Screen ( PrtSc ) for a static image snip.

Fix your audio drivers. Hardware problems can be caused by outdated or malfunctioning drivers. Make sure your audio driver is up to date and update it if needed. If that doesn't work, try uninstalling the audio driver (it will reinstall automatically).

Sign in to SharePoint. SharePoint is a browser-based app that you connect to through your web browser, like so: Go to office.com, and sign in to your work or school account. In the upper left corner of the window, select the app launcher > All apps > SharePoint.

Freeze panes to lock rows and columns. To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.

Help with giving digital games as gifts. Note that if you purchased content that isn’t working, check the Xbox status page for any issues that may prevent you from playing, and try troubleshooting the problem before making a request for a refund: Xbox status. Troubleshoot game issues on Xbox.

Fix Bluetooth problems in Windows. If you run into problems trying to connect to a Bluetooth device, here are some troubleshooting steps to try. Note: For general info about how to connect a Bluetooth device to your PC, see Pair a Bluetooth device in Windows.

If your system is asking you for your BitLocker recovery key, the following information may help you locate your recovery key and understand why you're being asked to provide it. Important: Microsoft support is unable to provide, or recreate, a lost BitLocker recovery key.

The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH,  are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work.

The Microsoft Authenticator app helps you sign into your accounts when you're using two-step verification.