Microsoft .NET Framework 4.7.2 offline installer for Windows
Issues that are fixed in this update. The following issues are fixed for .NET Framework 4.7.2. SQL Server (SQL) Fixes an issue in which the .NET Framework API SqlConnection.ConnectionString property is used to set a null or empty connection string. In this situation, a Null Reference Exception (NRE) occurs when you use the API together with .NET Framework 4.7.2.
Use AutoSum to sum numbers - Microsoft Support
If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, select AutoSum on the Home tab, press Enter, and you’re done. When you select AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. Here’s an example.
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 for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Fix OneDrive sync problems - Microsoft Support
Contact Support 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
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013 Enterprise, SharePoint in Microsoft 365, Office for business, Office 365 Small Business, Microsoft 365 admin, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows, SharePoint admin center, SharePoint in Microsoft 365 Small Business
Change your background in Microsoft Teams meetings
If you want to change what appears behind you in your video meeting or call, you can either blur your background, replace it entirely with any image you want, or use Teams virtual background template.And with a Teams Premium license, you can change your Teams meeting background to a branded logo or image specific to your company.
Applies To: Microsoft Teams
Change the column width and row height - Microsoft Support
If you find yourself needing to expand or reduce Excel row widths and column heights, there are several ways to adjust them. If you're working in Page Layout view (View > Workbook Views > Page Layout), you can specify a column width or row height in inches, centimeters and millimeters.The measurement unit is in inches by default.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Encrypt messages by using S/MIME in Outlook on the web
A key icon in the message list or reading pane indicates an encrypted message.. If you normally use Conversation view, you'll have to open the message in a new window to read it. There will be a link on the message to make this easier.
Applies To: Outlook.com, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019
Upgrade to Windows 11: FAQ - Microsoft Support
An upgrade differs from an update in that it moves your PC from a previous version of Windows—such as Windows 10—to Windows 11. This FAQ is intended to answer questions about upgrading to Windows 11.
Overview of PivotTables and PivotCharts - Microsoft Support
You can use data from a Excel worksheet as the basis for a PivotTable or PivotChart. The data should be in list format, with column labels in the first row, which Excel will use for Field Names.Each cell in subsequent rows should contain data appropriate to its column heading, and you shouldn't mix data types in the same column.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Configure headers and footers for different sections of a document
Click Link to Previous to turn it off and unlink the header or footer from the previous section.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016
Change the language Office uses in its menus and proofing tools
Under Proofing, if your language shows as Installed, you're ready to go.Otherwise press Not installed and Office will take you to a page where you can download the necessary Language Accessory Pack for that language. Follow the instructions on that page to download and install the pack, then come back to the Office Language Preferences dialog box to confirm that it's now installed.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Publisher for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel for the web, Word for the web, PowerPoint for the web, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Publisher 2021, Office 2021, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Publisher 2019, Office 2019, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Publisher 2016, Office 2016, Excel for iPad, Word for iPad, PowerPoint for iPad, Excel for iPhone, Word for iPhone, PowerPoint for iPhone, Word for Android tablets, Excel for Android tablets, PowerPoint for Android tablets, Excel for Android phones, Excel for Windows Phone 10, Excel Mobile, PowerPoint for Android phones, PowerPoint for Windows Phone 10, PowerPoint Mobile, Word for Android phones, Word for Windows Phone 10, Word Mobile