RAND function - Microsoft Support
=RAND()*(b-a)+a. If you want to use RAND to generate a random number but don't want the numbers to change every time the cell is calculated, you can enter =RAND() in the formula bar, and then press F9 to change the formula to a random number. The formula will calculate and leave you with just a value.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Camera doesn't work in Windows - Microsoft Support
Test your camera with the Camera app. Select Start , then choose Camera from your apps. If you're asked to allow access to the Camera, select Yes.If the camera works in the Camera app, the problem might be with the app you're trying to use.
Sync SharePoint and Teams files with your computer
You have two options when syncing files in SharePoint libraries and Teams. You can either add shortcuts to libraries and folders to their OneDrive or use the Sync button in the document library.. Both options allow essentially the same thing—users can access files on their local computer in Explorer or Finder.
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Admin, OneDrive (work or school), OneDrive (work or school) operated by 21Vianet, OneDrive for Windows, SharePoint admin center, SharePoint operated by 21Vianet
Download files and folders from OneDrive or SharePoint
If you select multiple files or folders and then select Download from Microsoft OneDrive, SharePoint in Microsoft 365, or from SharePoint Server Subscription Edition, your browser will start downloading a .zip file containing all the files and folders you selected. If you're in a folder and you select Download without selecting any files or folders, your browser will begin downloading all ...
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, Office for business, OneDrive (work or school), OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows, SharePoint in Microsoft 365 Small Business
Set up Outlook with Gmail - Microsoft Support
After installing Office apps, you can set up your G Suite Gmail in Outlook. First, sign in to the Google Admin console and confirm your settings.. Note: Links to Google content are provided as a convenience and can change location without notice. Confirm settings in the Google Admin console
Microsoft 365 Training
Get productive quickly with Microsoft 365 videos and tutorials. Explore Microsoft 365 training guides and tips to collaborate with anyone, anywhere.
How to delete the contents of the Temporary Internet Files folder
An administrator might have customized the settings for your Temporary Internet Files folder to prevent you from changing the settings. For example, the administrator can remove the General tab from the interface in the Internet Options dialog box. If you cannot access the Internet Options dialog box or the General tab, contact your administrator for more information.
How to access Microsoft Office on a Chromebook
Note: You can view files and do basic editing in Office.com if you're signed in with your Microsoft Account (it's free and you can use an existing email).If you have an Microsoft 365 subscription, you can sign-in with the account associated with your subscription to use more advanced editing features with Microsoft 365.
Import or copy the AutoComplete list to another computer
Step 2: Copy the Auto-Complete file to the new computer. On the new computer, in Control Panel, select or double-click Mail.. Mail appears in different Control Panel locations depending on the version of the Microsoft Windows operating system, the Control Panel view selected, and whether a 32- or 64-bit operating system or version of Outlook 2010 is installed.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Excel help & learning
Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.