Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
VLOOKUP function - Microsoft Support
Argument name. Description. lookup_value (required). The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in the table_array argument. For example, if table-array spans cells B2:D7, then your lookup_value must be in column B.. Lookup_value can be a value or a reference to a cell.. table_array (required)
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
Find out which Surface model you have - Microsoft Support
Look in the Surface app. The easiest way to find which Surface model you have is to use the Surface app. It shows the model name of your Surface device and each Surface accessory.
Free up drive space in Windows - Microsoft Support
Note: If it’s been fewer than 10 days since you upgraded to Windows 10, your previous version of Windows will be listed as a system file you can delete.If you need to free up drive space, you can delete it, but keep in mind that you'll be deleting your Windows.old folder, which contains files that give you the option to go back to your previous version of Windows.
Phone Link help & learning
Introducing Microsoft Phone Link Our evolution of the former Your Phone app brings a new name to the user experience. With the new Phone Link on your Windows PC and the new Link to Windows app on your Android device, accessing your mobile apps and content has never been easier!
Calculate the difference between two dates - Microsoft Support
As you saw above, the DATEDIF function calculates the difference between a start date and an end date. However, instead of typing specific dates, you can also use the TODAY() function inside the formula. When you use the TODAY() function, Excel uses your computer's current date for the date.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Use voting buttons in messages - Microsoft Support
Track and print results. When you create and send an email with voting buttons to others, you may want to track and print the results. You can either quickly copy the voting results into a blank Word document or a new email, or copy them into Excel so you can work with the data later.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook 2013
Connect to a Wi-Fi network in Windows - Microsoft Support
Whether you're at home, work, or out and about, chances are you'll find a Wi-Fi network that you can connect to for internet access. Select the Network, Sound, or Battery icons ( ) on the far right side of the taskbar to open quick settings. The Disconnected icon appears when you’re not connected.
Show or hide the ribbon in Office - Microsoft Support
Choose an option for the ribbon: Show Tabs and Commands keeps all the tabs and commands on the ribbon visible all the time.. Show tabs shows only the ribbon tabs, so you see more of your document, and you can still quickly switch among the tabs.. Auto-Hide ribbon hides the ribbon for the best view of your document, and only shows the ribbon when you select the ellipsis (...
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Office 2016
Firewall & network protection in Windows Security - Microsoft Support
Advanced settings - This will open the classic Windows Defender Firewall tool which lets you create inbound or outbound rules, connection security rules, and see monitoring logs for the firewall. Most people won't want to dig into it that deeply; adding, changing, or deleting rules incorrectly can cause your system to be more vulnerable or can cause some apps not to work.
Creating and using a USB recovery drive for Surface
If the USB recovery drive doesn’t work on your Surface. If you can’t boot from your USB recovery drive or don’t see the Recover from a drive option, you may need to ensure that the boot-from-USB function in the Surface BIOS is enabled or configure the boot order so the USB drive is the first option. For more info, see Boot Surface from a USB device.