Add or subtract dates - Microsoft Support
Add or subtract months from a date with the EDATE function. You can use the EDATE function to quickly add or subtract months from a date.. The EDATE function requires two arguments: the start date and the number of months that you want to add or subtract. To subtract months, enter a negative number as the second argument.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Repair an Office application - Microsoft Support
Depends on your Office installation type (Click-to-run or MSI-based), you'll see the following options to proceed with the repair. Follow the steps for your installation type.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin, InfoPath 2013, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
Combine text from two or more cells into one cell
Select the cell you want to combine first. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text.
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, Excel Mobile
View and delete your browsing history in Internet Explorer
Select the History tab, and choose how you want to view your history by selecting a filter from the menu.To delete specific sites, right-click a site from any of these lists and then select Delete.Or, return to a page by selecting any site in the list.
Change or set the default font in Outlook - Microsoft Support
Replying or forwarding messages - You can have a different font on messages you're forwarding or replying to. This setting is mostly for the two check boxes that let you mark your comments with your name (or other text) or with a different color of text.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Play, share, and download a meeting recording in Microsoft Teams
Depending on the length of the video, generating closed captions can take several minutes. Once generated, you can watch the video in Stream and have captions displayed at the bottom of the screen.. When the captions have been created, the Generate button turns to Translate.Select Translate to change the spoken or screen language to automatically translate the captions.
Applies To: Microsoft Teams
Free Excel for the web templates - Microsoft Support
Tip: If you don’t like the name of the template (usually Book 1), click the name in the Excel for the web title bar at the top of the page and type a different name.
Applies To: Excel for the web
Protect a worksheet - Microsoft Support
Option. Allows users to. Select locked cells. Move the pointer to cells for which the Locked box is checked on the Protection tab of the Format Cells dialog box. By default, users are allowed to select locked cells. Select unlocked cells
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
About Microsoft Authenticator - Microsoft Support
Microsoft Authenticator is a free app that helps you sign in to all your accounts without using a password - just use a fingerprint, face recognition, or a PIN.
Applies To: Microsoft account dashboard
Get started with Python in Excel - Microsoft Support
Python in Excel uses the custom Python function xl() to interface between Excel and Python. The xl() function accepts Excel objects like ranges, tables, queries, and names.. You can also directly type references into a Python cell with the xl() function. For example, to reference cell A1 use xl("A1") and for the range B1:C4 use xl("B1:C4").For a table with headers named MyTable, use xl ...
Applies To: Excel for Microsoft 365