a. Select the stencil to see a preview. b. To put the stencil in your My Shapes folder, select Download. c. After it has downloaded, select Open to display the stencil in the Shapes pane. To reset the search in the Shapes pane, delete the search string in the search box so that it displays the prompt, Search shapes.

Turn your data into insights. List of all Excel functions available. VLOOKUP function. IF function. Create a drop-down list. Combine text from two or more cells. Freeze panes to lock rows & columns. Create a PivotTable to analyze worksheet data. Design the layout and format of a PivotTable.

Before you modify it, back up the registry for restoration in case problems occur. Navigate to the following registry key: HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Windows\OneDrive. Check the following key: DisableFileSyncNGSC = DWORD:1. In order to sync with OneDrive for work or school, the DisableFileSyncNGSC key must be removed or the ...

To pin your favorite apps to the Start menu, select and hold (or right-click) the app you want to pin. Then select Pin to Start . To group your apps into folders, simply drag an app on top of another with mouse or touch or highlight the app with your keyboard and use the Ctrl + Shift + < Left or Right arrow > keyboard shortcut.

When Smart charging is on, you’ll see a heart on the Battery icon in the following places—on the right side of the taskbar and in Power & battery settings. When your hover over the Battery icon with your mouse, it says “Fully Smart charged” and means the battery isn’t charging even though your device is still plugged in.

Open the template or a document based on the template whose default settings you want to change. On the Format menu, click Font, and then click the Font tab. Make any changes that you want, and then click Default. Note: Most of the styles in Word are based on the Normal style.

Select New to create files or folders. Select Upload to add files or folders to your OneDrive storage. Select Sort to change how you'd like to view your files. Select View to change the view. Select Information to see details like who Has Access and Activity. Or, hover the cursor over a file and information will appear.

For help with your Microsoft account and subscriptions, visit Account & Billing Help. For technical support, go to Contact Microsoft Support, enter your problem and select Get Help. If you still need help, select Contact Support to be routed to the best support option. Admins should view Help for OneDrive Admins, the OneDrive Tech Community or ...

Create contact lists. A contact list is a collection of email addresses, and is useful for sending email to a group of people. Contact lists are sometimes referred to as distribution lists.. For example, create a contact list named My book club and add all the members of your book club to it. When you want to send an email message to everyone in the club, just add My book club in the To line ...

Press the Xbox button to open the guide. Go to My games & apps > See all > Apps > Captures. Set your filters to locate the captures you want to back up. Select Manage. When you select one or more captures, you’ll see a list of backup options. To back up the captures you’ve selected, choose Upload to OneDrive.