Text editing shortcuts. Dialog box shortcuts. Virtual Desktop shortcuts. File Explorer shortcuts. Command prompt shortcuts. Taskbar shortcuts. Copy, paste and other basic shortcuts. Select the option (s) below to see the list of associated shortcuts.

Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.

To open the On-Screen Keyboard. Go to Start , then select Settings > Accessibility > Keyboard, and turn on the On-Screen Keyboard toggle. A keyboard that can be used to move around the screen and enter text will appear on the screen. The keyboard will remain on the screen until you close it. Note: To open the OSK from the sign-in screen, select ...

Open Control Panel in Windows. Windows 10. In the search box next to Start on the taskbar, type control panel. Select Control Panel from the list of results. Note: Many Control Panel features are simpler and faster in Settings . Open Settings. Open Control Panel in Windows.

In Windows 11, you decide when and how to get the latest updates to keep your device running smoothly and securely. To manage your options and see available updates, select Check for Windows updates. Or select Start > Settings > Windows Update . Here's some other info you might be looking for:

Cols Required.The number of columns, to the left or right, that you want the upper-left cell of the result to refer to. Using 5 as the cols argument specifies that the upper-left cell in the reference is five columns to the right of reference.

If you want, you can apply the criteria to one range and sum the corresponding values in a different range. For example, the formula =SUMIF(B2:B5, "John", C2:C5) sums only the values in the range C2:C5, where the corresponding cells in the range B2:B5 equal "John." To sum cells based on multiple criteria, see SUMIFS function.

If your accounts are supported in the new Outlook for Windows, you'll see a toggle in the upper right of classic Outlook to Try the new Outlook . Selecting this toggle will download the new app and let you switch to the preview. The new Outlook for Windows will launch into the account you have set as your default send account in Outlook.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

In this topic. Best practices for making Excel spreadsheets accessible. Check accessibility while you work in Excel. Create accessible tables. Use an accessible template. Add text to cell A1. Add alt text to visuals. Add accessible hyperlink text and ScreenTips. Use accessible font format and color.