Optimizing your drives can help your PC run smoother and boot up faster. To optimize them: Select the search bar on the taskbar and enter defrag.

Use the XLOOKUP function when you need to find things in a table or a 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.

Download our Formulas tutorial workbook. We've put together a Get started with Formulas workbook that you can download. If you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour.

When prompted, enter the product key. You can find the product key on the sticker on the CD case or other packaging. If you need help, see Find your Product Key for Office 2007.

On the Security tab, select Custom level, and then under ActiveX controls and plug-ins, do one the following: Allow Automatic prompting for ActiveX controls by selecting Enable. Allow Internet Explorer to Display video and animation on a webpage that doesn't use external media player by selecting Enable. Allow Internet Explorer to Download signed ActiveX controls by selecting Enable, or Prompt ...

If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, select AutoSum on the Home tab, press Enter, and you’re done. When you select AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. Here’s an example.

如果我的设备上没有管理员权限，该怎么办？ 若要完全升级到新的 Microsoft Edge，必须使用管理员帐户登录到设备。

Use the Windows Quick Assist app to get help with a computer problem from family or friends or help them out. Quick Assist uses a remote connection, so remember to only use it with people you trust, since they can see your computer screen or control your PC (if you allow it).

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

Important: By default, Word and Outlook recolor your documents and e-mails to match the rest of the application when in Black theme. To disable this behavior in Word, navigate to File > Options > General > Personalize your copy of Microsoft Office, then check Never change the document page color.. To disable this behavior in Outlook, navigate to File > Options > General > Personalize your copy ...