Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This article gives you a quick VLOOKUP refresher, then links to more.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Fix Ethernet connection problems in Windows - Microsoft Support
A wired Ethernet connection lets you get a fast internet connection—plug one end of the Ethernet cable into your router at home, then plug the other end into the Ethernet port on your Windows PC.
Activate Office - Microsoft Support
Learn how to activate Office pre-installed on new Windows 10 PCs or with a new product key.
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 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 Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Publisher 2016, Office 2016, Microsoft 365 for home, Office for business, Microsoft 365 admin, Project for Office 365
Freeze panes to lock rows and columns - Microsoft Support
How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Sync SharePoint files and folders - Microsoft Support
Sync the files in your Microsoft 365 or Microsoft SharePoint site libraries so they’re always available on your computer, even when you’re offline.
Applies To: SharePoint in Microsoft 365
Download and Install or Reinstall Office 365 or Office 2019 on a PC or Mac
We would like to show you a description here but the site won’t allow us.
Using email in Outlook on the web - Microsoft Support
Get help with signing in, changing passwords, creating and sending mail, deleting mail, creating folders, and more in Outlook on the web.
Applies To: Outlook.com, Outlook on the web for Exchange Server 2016
Get new themes and desktop backgrounds - Microsoft Support
Select Start , then select Settings > Personalization > Themes.Choose from a default theme or select Get more themes in Microsoft Store if you want to download new themes with desktop backgrounds that feature cute critters, breathtaking landscapes, and other smile-inducing options.
Download and install Microsoft 365 Access Runtime
Download the Microsoft 365 Access Runtime which allows you to run Microsoft 365 Access applications if you don't have the desktop version of Microsoft 365 Access and need to use an application built to run with Access 2010 or later.
Applies To: Access for Microsoft 365, Access 2021, Office 2021, Access 2019, Office 2019
Find your IP address in Windows - Microsoft Support
Get info on how to find your IP address in Windows. Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.