Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Using Flash Fill in Excel - Microsoft Support
Have Excel automatically fill your data when it detects a pattern. For example, the months of the year, the days in a month, or a sequence of numbers. You can also parse data, like splitting first and last names out of a column, or concatenate data, like joining first and last names from two columns.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Use the SUM function to sum numbers in a range
You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM(A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6. Here’s a formula that uses two cell ranges: =SUM(A2:A4,C2:C3) sums the numbers in ranges A2:A4 and C2:C3.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Enable TPM 2.0 on your PC - Microsoft Support
How to enable TPM. If you need to enable TPM, these settings are managed via the UEFI BIOS (PC firmware) and vary based on your device. You can access these settings by choosing: Settings > Update & Security > Recovery > Restart now. From the next screen, choose Troubleshoot > Advanced options > UEFI Firmware Settings > Restart to make the changes.
Change notification and quick settings in Windows
In Windows 10, action center is where you'll find your app notifications and quick actions—which give you quick access to commonly used settings and apps.
Create or edit a hyperlink - Microsoft Support
To create a new, blank file and link to it, click Create New Document under Link to, type a name for the new file, and either use the location shown under Full path or browse to a different save location by clicking Change.You can also choose whether to Edit the new document later or open and Edit the new document now.
Applies To: Word for Microsoft 365, Outlook for Microsoft 365, Project Online Desktop Client, Word 2021, Outlook 2021, Project Professional 2021, Project Standard 2021, Word 2019, Outlook 2019, Project Professional 2019, Project Standard 2019, Word 2016, Outlook 2016, Project Professional 2016, Project Standard 2016, Office 2016, InfoPath 2013, InfoPath Filler 2013
Adjust your form or quiz settings in Microsoft Forms
Start date and End date - You can specify an exact date and time when you want to start and stop collecting form responses. Click Start date, then click the date text box and select a date from the calendar control.Select a specific hour from the drop-down list of hour increments. Do the same for End date
Applies To: Microsoft Forms
Delay or schedule sending email messages in Outlook
In the Step 1: Select condition(s) list, select the check boxes for any options that you want, and then click Next.. If you do not select any check boxes, a confirmation dialog box appears. If you click Yes, the rule that you are creating is applied to all messages that you send.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, Outlook.com, New Outlook for Windows, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019
Manage photos and videos with Microsoft Photos app
Select Settings, and under the About section, select About Photos. Photos: Says Updated in the About section of Settings—you are running the new version of the Photos app.This version includes features like iCloud integration in left navigation bar. This version of Microsoft Photos app offers a convenient and user-friendly way to view, import, organize, edit, and share photos and videos on ...
Stay up to date with widgets - Microsoft Support
Each widget is powered by a different app or service. To see what is powering a widget, select More Options (…) in the upper-right corner of the widget, and look for the “Powered by” message at the bottom of the menu. Each individual widget is an extension of its corresponding app or service and is controlled by the settings for that app or service.
Manage cameras with Camera settings in Windows 11
Note: Some cameras won't appear in the Camera settings page.These include infrared (IR) cameras used for Windows Hello Face authentication, cameras using DirectShow technology (like many apps provided by DSLR or action camera manufacturers so their devices can be used as webcams), and proprietary cameras that aren't managed by Windows—such as industrial cameras and many networked cameras.