Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Open the Shared view, and select the files or folders you want to remove by pointing to each item and clicking the circle check box that appears.. To remove an item shared by other users, select the item, then select Remove from shared list on the bar at the top of the page.. To remove an item from Shared by me, select the item, select Information in the upper-right corner to open the Details ...

Both options allow essentially the same thing—you can access files on your local computer in File Explorer or Finder. However, adding OneDrive shortcuts allows content to be accessed on all devices, whereas sync is related to a specific device.

Approach. Formula. 1. Reference just the lookup values you are interested in. This style of formula will return a dynamic array, but does not work with Excel tables. =VLOOKUP(A2:A7,A:C,2,FALSE)2. Reference just the value on the same row, and then copy the formula down.

Example. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.

When someone shares a folder with you, it appears in the Shared section of your OneDrive.com.If you have Edit permissions to those shared folders, you can add them to the My files section of your OneDrive to make them easier to access and work with. If you want to view and access shared folders on your PC or Mac, install the OneDrive app and sync your folders to your device.

If pressing the Connect button in action center doesn't find your device in Windows 10, here are some things to try:. Check action center to see if your Windows device supports Bluetooth. If it does, there'll be a Bluetooth button in action center. Make sure it's turned on.

Use your phone's audio. If your mic doesn’t work after trying the solutions above and you see one of the messages below, select Call me back to use your phone’s mic.. Enter your phone number and select Call me to receive a call from Teams that will connect you to your meeting. Your audio will come from your phone, but other content sharing will still take place on your desktop.

Select your printer from the list and select Open print queue to see a list of what's printing and the upcoming print order.

Controller serial numbers are 14 characters long and don’t include dashes. Your controller serial number may not be recognized if you’ve never connected your controller, or if you connected for the first time within the last 48 hours.; If you have the Xbox Elite Wireless Controller Series 2, the 14-character serial number is in the lower center on the back of the controller.