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 clear your TPM, follow these steps: Go to Start > Settings > Update & Security > Windows Security > Device security . Under Security processor, select Security processor details. Select Security processor troubleshooting, and then under Clear TPM, select Clear TPM. You'll need to restart your device to complete the process.

Sign out of your account and then sign in to your new account. If everything is fixed, move your personal data and files to the new account. To move your personal files from your old account to your new account, try opening File Explorer, expanding This PC > OSDisk (C:), and looking in the Users folder, where you should see folders for both accounts.

Simply select a cell in a data range > select the Analyze Data button on the Home tab. Analyze Data in Excel will analyze your data, and return interesting visuals about it in a task pane. If you're interested in more specific information, you can enter a question in the query box at the top of the pane, and press Enter.

Contact your farm or server administrator. If you're an administrator, see Configure SharePoint Recycle Bin Settings. Click Settings , and then click Site contents. The recycle bin is in the top right portion of the Site Contents page. On the Recycle bin page, click the box to the left of the items or files you want to restore.

Select your account and then select Sign in to sync. To enter a new account, select Add Account and follow the prompts. When you’re signed in, Microsoft Edge syncs your favorites, passwords, history, open tabs, autofill form entries (such as your name, address, and phone number), and other data types across the devices you use with this account.

Under PC settings, tap or click Update and recovery, and then tap or click Recovery. Under Advanced startup, tap or click Restart now. Once your PC restarts, on the Choose an option screen, tap or click Troubleshoot. If you don't see the Startup Settings option, tap or click Advanced options. Tap or click Startup Settings and then Restart.

These suggestions are listed in order, so start with the first one, see if that helps, and then continue to the next one if it doesn't. To check the total disk space left on your Windows 11 device, select File Explorer from the taskbar, and then select This PC on the left. The available space on your drive will appear under Devices and drives.

For technical support, go to Contact Microsoft Support, enter your problem and select Get Help. If you still need help, select Contact Support to be routed to the best support option. Admins. Admins should view Help for OneDrive Admins, the OneDrive Tech Community or contact Microsoft 365 for business support. Important:

By default, File Explorer opens to Quick Access. You can set a folder to show up in Quick access so it'll be easy to find. Just right-click (or long-press) it and select Pin to Quick access. Unpin it when you don’t need it there anymore by right-clicking (or long-pressing) it and selecting Unpin from Quick access.. If you want to see only your pinned folders, you can turn off recent files or ...