Freeze panes to lock rows and columns - Microsoft Support
To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Change the capitalization or case of text - Microsoft Support
PowerPoint for the web supports changing case. See the procedure below. Word for the web doesn't support changing case. Use the desktop application to open the document and change text case there, or else you can manually change the casing of text in Word for the web.
Applies To: Word for Microsoft 365, PowerPoint for Microsoft 365, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Word for the web, PowerPoint for the web, Word 2021, PowerPoint 2021, Word 2021 for Mac, PowerPoint 2021 for Mac, Word 2019, PowerPoint 2019, Word 2019 for Mac, PowerPoint 2019 for Mac, Word 2016, PowerPoint 2016
Add a printer or scanner in Windows - Microsoft Support
Learn how to add a printer or scanner in Windows. If your printer connects by a wire, plug it into your device. It'll connect automatically, your PC will download the right drivers, and you can use it right away.
Change your default browser in Windows - Microsoft Support
Use the Windows Settings app to change your default browser.
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
Manage app permissions for your camera in Windows
Note: If you can't change the Camera access setting, you'll need an administrator on the device to turn it on for you. Allow access to the camera on this device. Make sure Let apps access your camera is turned on. This setting allows you to choose if any of your apps can access the camera. It doesn't set which specific apps can access the camera.
Solve PC problems remotely with Remote Assistance and Easy Connect
To invite someone who isn't on your contact list, select Invite someone to help you. Follow the instructions. To give help if someone has requested it: Go to the search box and enter remote assistance, then select Invite someone to connect to your PC and help you, or offer to help someone else.
Use add-ins in Outlook - Microsoft Support
Notes: Starting in Outlook for Windows Version 2303 (Build 16215.10000), the All Apps button replaces the Get Add-ins buttonon the ribbon to view installed add-ins and access the Office Store.If you’re using an earlier version of Outlook, you'll see the Get Add-ins button instead.. If you don't see All Apps on the ribbon, your administrator may have turned off add-ins for your organization.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, New Outlook for Windows, Outlook Web App
Introducing Microsoft Phone Link and Link to Windows
We want to hear from you! Please continue to share your feedback with us — either in the Google Play Store, directly in the Phone Link and Link to Windows apps, or at the bottom of this article.
Create a recovery drive - Microsoft Support
It doesn't contain your personal files, settings, or programs. Need more options for creating a recovery drive? For Windows 7, see Create a system repair disc. For Windows 8.1, see Create a USB recovery drive. To download Windows 10 installation media, see Recovery options in Windows.