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
Remove or delete an email account from classic Outlook for Windows
Important: If you want to delete the last or the only email account you have in classic Outlook for Windows, you'll receive a warning that you must create a new location for your data before removing the account.For more information, see Create an Outlook Data File.
Applies To: Outlook 2019, Outlook 2016
Open a chat in a new window in Microsoft Teams
Block or unblock people outside your org; Open a chat in a new window in Microsoft Teams. It's simple and quick to open your one-on-one or group chat in a separate window. Then, resize, reposition, or close the window if you want to. It’s a good way to get more done when you’re in a meeting or in a call. (Note that you can open multiple ...
Applies To: Microsoft Teams
Create or run a macro - Microsoft Support
It depends on how you set it up. Record a macro with a button. Click View > Macros > Record Macro. Type a name for the macro. To use this macro in any new documents you make, be sure the Store macro in box says All Documents (Normal.dotm). To run your macro when you click a button, click Button.
Applies To: Word for Microsoft 365, Word for the web, Word 2021, Word 2019, Word 2016
Add graphics to messages in Outlook - Microsoft Support
Click in the message body. Then on the Insert menu, in the Illustrations group, choose one of the options.. Pictures Browse to the folder where the picture you want is saved, select the picture, and then click Insert.You can resize or rotate the picture with the handle points on the edges of the picture. To change the picture options, right-click the picture, and then click a command.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook 2013
Share your calendar in Outlook on the web - Microsoft Support
If you receive an invitation to share someone else’s calendar, select Accept in the message or the link in the invitation to add their calendar to your calendar view.. You also can go your calendar in Outlook on the web to add other people's calendars to your view.
Applies To: Outlook on the web
Fix problems signing in to the Xbox app - Microsoft Support
If none of those options work, select the Start button > Settings > Accounts , then find the Microsoft account you used to sign in to the Xbox app and select Remove.Then go back to the Xbox app and sign in with the Microsoft account you just removed. Open Settings
Reinstall Windows - Microsoft Support
In this scenario, either free up additional space or use the steps in the next section to reinstall Windows 10. Reinstall Windows 10 using installation media. This option will use a tool to create installation media which you can use to completely wipe the disk and install a fresh copy of Windows 10. This option requires you to use an external ...
Hide or show rows or columns - Microsoft Support
Insert or delete rows, and columns Article; Select cell contents in Excel Article; Freeze panes to lock rows and columns Article; Hide or show rows or columns
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
KB5003791: Update to Windows 10, version 21H2 by using an enablement ...
Summary. Windows 10, versions 2004, 20H2, 21H1, and 21H2 share a common core operating system with an identical set of system files. Therefore, the new features in Windows 10, version 21H2 are included in the latest monthly quality update for Windows 10, version 2004, 20H2, and 21H1, but are in an inactive and dormant state.