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 resize desktop icons, right-click (or press and hold) the desktop, point to View, then select Large icons, Medium icons, or Small icons.

To resize the image, select the image to see drag handles appear around the image. Move the drag handles to resize the image as necessary. Select the Picture Format tab on the ribbon, then use the options on it to format your image. For example, you can apply a style or a border to the image.

Cloud files can exist locally on the disk or be available online only. To choose the conditions for when inactive files are made online only, under Content will become online-only if not opened for more than: choose your preferred amount of time. Note that starting in Windows 11, version 22H2, the default for OneDrive cloud files is to make files online-only if not opened for more than 30 days.

If you can't find a file on your computer or you accidently modified or deleted a file, you can restore it from a backup (if you're using Windows backup) or you can try to restore it from a previous version.Previous versions are copies of files and folders that Windows automatically saves as part of a restore point.

Syntax. MATCH(lookup_value, lookup_array, [match_type]) The MATCH function syntax has the following arguments: lookup_value Required.The value that you want to match in lookup_array.For example, when you look up someone's number in a telephone book, you are using the person's name as the lookup value, but the telephone number is the value you want.

Here's how to show icons, hide them, or change their size in Windows. To show or hide desktop icons. Right-click (or press and hold) the desktop, point to View, and then select Show desktop icons to add or clear the check mark.

Click a template to see a preview. Click the arrows on the side of the preview to see more templates.

Microsoft Edge is the recommended browser by Microsoft. Support for Internet Explorer ended on June 15, 2022. Internet Explorer 11 has been permanently disabled through a Microsoft Edge update on certain versions of Windows 10.

Repair programs in Control Panel. Select the Advanced options link under the name of the app (some apps don't have this option). On the page that opens, select Repair if it's available.If it isn't available or doesn't fix the problem, select Reset.