Summary. This step-by-step article describes how to find data in a table (or range of cells) by using various built-in functions in Microsoft Excel.

If you have trouble getting things working when you try to connect Surface to an external display, try these solutions to help fix the problem.

Learn how to get Microsoft Store updates for your apps and games. Download the latest versions of Microsoft Store apps and games.

Hide or display zero values in Excel worksheets by using an option in the Advanced tab, or by using a number format, using a conditional format, a function, and by hiding zeros in PivotTable reports.

Learn how to use the taskbar features in Windows. Hide the taskbar, pin an app, change the location, and more with taskbar settings.

Restart your device in normal mode and sign in again with your original profile. Check to see if your settings and files are restored. (You might need to restart your device more than once.)

Structured references make it easier to use formulas with Excel tables by replacing cell references, such as C2:C7, with predefined names for the items in a table.

Use Sway to create and share interactive reports, presentations, personal stories, and more.

In Outlook, you have the option to: Snooze or dismiss events or tasks | Turn the notifications on or off | Add reminders to events | Add reminders to tasks | Troubleshoot notifications. Snooze or dismiss an event or task. With the reminders window, you can select to snooze calendar events and tasks, join a Teams meeting, or dismiss events and tasks.

To see where your browser is saving downloads, look in your browser's settings. For example, in the new Microsoft Edge , select Settings and more > Settings > Downloads .The file path for your downloaded files (for example, C:\Users\[your name]\Downloads) is listed under Location.. In Microsoft Edge Legacy , select Settings and more > Settings .