Upload files or folders to OneDrive. You can store over 300 types of files on OneDrive. With Microsoft Edge or Google Chrome: Select Add new > Files upload or Folder upload > Folder.

For the website(s) you would like to allow scripting, enter the address within the Add this website to the zone text box and click Add. Note: If the address does not begin with "https:", you many need to uncheck "Require server verification (https:) for all sites in this zone".

The taskbar can display the temperature in Celsius (°C) or Fahrenheit (°F). To switch between these two units, select the weather icon on the taskbar, select the Edit location and unit icon on the weather card, select Celsius or Fahrenheit on the weather, and select Save. News and interests is supported in any taskbar orientation.

Use as wallpaper. Most of the daily images are available for download to use as wallpaper. Hover over the image headline and select Download today's image.If licensing restrictions don't allow downloads of a given image, there's a link to download the Bing Wallpaper app, which offers a library of images featured on Bing.

Tip: Creating an Outlook.com email address gives you a brand-new email address that is attached to your existing Microsoft account.This makes several benefits and features available to you within the Microsoft suite of products, particularly within Outlook. You might want to do this if your Microsoft account is not currently tied to an Outlook.com email address.

Click the triangle again to expand that part of the document. To collapse or expand all the headings in your document, right-click the heading and click Expand/Collapse > Expand All Headings or Collapse All Headings.. When you close and reopen a document, the headings will be expanded by default.

Access files in Teams for mobile iOS. Files that you upload to a channel are stored in your team's SharePoint folder. To access SharePoint files and folders for a channel, go to the channel and tap Files.. Files that you upload in a one-on-one or group chat are stored in the Microsoft Teams Chat Files in your OneDrive for Business folder and are shared only with the people in that conversation.

Problem. Resolution. You have a OneDrive file open. Close the file once you finish editing. You're syncing a lot of files. No action required. OneDrive will upload all files, but this may take some time if your internet speed is slow.

The COUNTIFS function is similar to the COUNTIF function with one important exception: COUNTIFS lets you apply criteria to cells across multiple ranges and counts the number of times all criteria are met. You can use up to 127 range/criteria pairs with COUNTIFS. The syntax for COUNTIFS is: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2],…)

Merge Formatting (M) This option discards most formatting that was applied directly to the copied text, but it retains formatting that is considered emphasis, such as bold and italic, when it is applied to only a portion of the selection.The text takes on the style characteristics of the paragraph where it is pasted. The text also takes on any direct formatting or character style properties of ...