Select the range of cells that has duplicate values you want to remove. Tip: Remove any outlines or subtotals from your data before trying to remove duplicates. Select Data > Remove Duplicates, and then under Columns, check or uncheck the columns where you want to remove the duplicates. For example, in this worksheet, the January column has ...

On the Microsoft Solitaire Collection page in Microsoft Store, select Get. The game will download and install automatically. To launch the game, select Play. You can always launch the game from the product page, but there's an easier way--pin it. With the game open, press and hold (or right-click) the game button on your taskbar and select Pin ...

The following tips can help you pinpoint the issue affecting your device. Before you begin, make sure your device is plugged into a power source and connected to the internet. Then, try the steps listed below to get your PC to update. Some updates require administrator access. If your account doesn't have administrator access, see Create a ...

Select Start > Settings > Apps > Default apps. To change the default app, you can do either of the following: Set a default for a file type or link type. In the search bar, enter the file type or link type you want, then select it from the list of results. You can choose which app can open that file or link type. Set defaults for applications.

Set up your screen so you can clearly see what you want to capture. Press Windows logo key+Shift+S. The desktop darkens so you can select an area for your screenshot. If you select rectangular or free-form mode, you must then click and drag to highlight the area you want to capture. If you select window or full-screen mode, the capture takes ...

Select Start > Settings > System > Sound. In Input, select the microphone that you want to test. In Input settings, look at Input volume while speaking into the microphone. If the bar moves while you speak, your microphone is working properly. If don't see the bar moving, go to Test your microphone and select Start test.

Change the size of your desktop icons in Windows. Windows 10. To resize desktop icons, right-click (or press and hold) the desktop, point to View, then select Large icons, Medium icons, or Small icons. Change the size of your desktop icons.

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web More... Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the ...

Then, from the Capture widget: Select Record from now (the circle) to start a clip, then Stop recording (the square) to end it. Select Take screenshot (the camera icon) to take a picture of what’s happening in the game. For full-screen PC games, use Windows logo key + Alt + G to start and stop recording. To edit a clip, select See my captures.

To sign in to your Microsoft personal account, go to account.microsoft.com or select Sign in below. Sign in. Tip: If you don't have a Microsoft account, you can select " No account? Create one! Enter your email, phone number, or Skype sign-in that you use for other services (Outlook, Excel, etc.), then select Next.