To add another account to OneDrive on your computer. If you already have a personal OneDrive account set up, you can only add work or school accounts.

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.

若要在硬盘上创建分区或卷（两个术语通常可以互换使用），必须以管理员身份登录，并且硬盘上必须有未分配的磁盘空间或者在硬盘上的扩展分区内必须有可用空间。

Attendee experience. Town halls are a one-to-many experience. Focus stays primarily on presenters and shared content while attendees watch. By default, attendee cameras and mics will be turned off when they join a town hall.

To get someone's attention in a channel conversation or a chat, @mention them. Just type @ before their name and then select them from the menu that appears.. When an @mention recipient receives a notification, selecting it takes them directly to the point in the conversation where they were mentioned.

Use AutoSum. Use AutoSum by selecting a range of cells that contains at least one numeric value. Then on the Formulas tab, click AutoSum > Count Numbers.. Excel returns the count of the numeric values in the range in a cell adjacent to the range you selected. Generally, this result is displayed in a cell to the right for a horizontal range or in a cell below for a vertical range.

Select the Start button, then go to Settings > Personalization > Lock screen, and select Screen saver settings.In the Screen Saver Settings window, choose a screen saver from the drop-down list. Change your screen saver settings

Solution 4: Reset Surface. If you’re still having a problem with your touchscreen, try resetting your Surface. To learn how, see Restore or reset Surface for Windows and follow the recommended steps for "Reset this PC.". After the reset and device setup, use touch to open an application like Microsoft Edge or another web browser, and try to scroll pinch to zoom, swipe in from the right, and ...

Note: If you are in tablet mode, you may not be able to see your desktop icons properly.You can find the program by searching for the program name in File Explorer. To turn off tablet mode, select action center on the taskbar (next to date and time), and then select Tablet mode to turn it on or off.

Optimizations for windowed games improves gaming on your PC by using a new presentation model for DirectX 10 and DirectX 11 games that appear in a window or in a borderless window.