How to correct a #SPILL! error - Microsoft Support
Approach. Formula. 1. Reference just the lookup values you are interested in. This style of formula will return a dynamic array, but does not work with Excel tables. =VLOOKUP(A2:A7,A:C,2,FALSE)2. Reference just the value on the same row, and then copy the formula down.
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 Web App, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Create or edit a hyperlink - Microsoft Support
Optional: To customize the ScreenTip that appears when you rest the pointer over the hyperlink, click ScreenTip in the top-right corner of the Insert Hyperlink dialog box and enter the text you want. You can also create a hyperlink to a blank email message by simply typing the address in the document. For example, type someone@example.com, and Microsoft 365 creates the hyperlink for you ...
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
Contact - Microsoft Support
Contact Microsoft Support. What's new. Surface Pro; Surface Laptop; Surface Laptop Studio 2
Featured Visio templates and diagrams - Microsoft Support
Visio is a diagraming tool that makes it easy and intuitive to create flowcharts, diagrams, org charts, floor plans, engineering designs, and more by using modern templates with the familiar Office experience. On this page, you can access some of the top templates and sample diagrams available in Visio, or request ones that you want. To see the hundreds of templates and sample diagrams ...
Applies To:
Visio Plan 2, Visio in Microsoft 365, Visio Plan 1, Visio Professional 2021, Visio Professional 2019, Visio Professional 2016
Get connected when setting up your Windows 11 PC
Connecting to the internet when you’re setting up your Windows 10 or 11 PC ensures you get the latest features and security updates. You’ll need an internet connection to finish setting up a device running Windows 10 Home or Windows 11 Home / Pro.
Add a Gmail account to Outlook for Windows - Microsoft Support
If you need instructions for adding an email account using advanced settings, go to Use advanced setup to add a POP or IMAP email account in Outlook for PC. Outlook won't accept my password. If Outlook won’t accept your password and you know you’re using the right password for your Gmail account, you might have an older version of Outlook that doesn't currently support this faster Gmail ...
Applies To:
Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows
Excel video training - Microsoft Support
Learn Excel skills from beginner to advanced with video tutorials, templates, and tips from Microsoft Support.
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 2016
Receive files over Bluetooth - Microsoft Support
Receive photos, videos, or other kinds of files that you or a friend shares from another device, such as a phone, laptop, or tablet. On your PC, select Start > Settings > Devices > Bluetooth & other devices. Learn how to pair.
Learn about Microsoft Rewards - Microsoft Support
To start enjoying Microsoft Rewards, you just need a Microsoft account.It connects you to all things Microsoft with one simple logon. Sign up now by going to Microsoft Rewards.Select Sign up for free and follow the steps to create a Microsoft account.. If you already have a Microsoft account, great!
Applies To:
Microsoft account dashboard
How to share files in File Explorer on Windows
Email a link to just a few people. Right-click (or press and hold) the file, select More OneDrive sharing options > Invite people, then enter their email addresses.(If you're using OneDrive for Business, select Share, select an option from the drop-down list box, and select Apply.Then enter email addresses above the blue line and select Send.)