Users can't sort ranges that contain locked cells on a protected worksheet, regardless of this setting. Use AutoFilter. Using the drop-down arrows to change the filter on ranges when AutoFilters are applied. Users cannot apply or remove AutoFilters on a protected worksheet, regardless of this setting. Use PivotTable reports

如果在设置中打开用与首选语言不同的语言编写的页面，Microsoft Edge会自动提示你翻译它。 转到用外语编写的网页时，“翻译”图标 显示在地址栏中。 如果语言未包含在设置中的首选语言列表中，则该语言被视为外在语言。

Press the Start button , and then enter store into the search bar.; Choose Microsoft Store from the results to open the app.; Select your account in the top-right corner of the screen, and then select Redeem code or gift cards.; Enter the 25-character code, select Next, and then follow the prompts.

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

但如果需要测试多个条件，例如我们假设所有条件都需要为 True 或 False (AND)，或只有一个条件需要为 True 或 False (OR)，或者如果想要检查某个条件是否不 (NOT) 符合你的条件，这时该怎么做呢？这三个函数均可以单独使用，但它们更常见于与 IF 函数成对使用。

This isn't the date you'll set, it's just a sample of how the format will look. Note that in versions prior to Excel 2016, this format might have a different sample date like 3/14/01 1:30 PM. 3. Subtract the two. In another cell, subtract the start date/time from the end date/time. The result will probably look like a number and decimal.

If you don't receive this automatically, go to Settings > Update & Security > Windows Update. Select Check for updates. Windows Update for Business. No. See the other options. Microsoft Update Catalog. No. See the other options. Windows Server Update Services (WSUS) No. See the other options.

Why does my reading pane have a dark background? When dark mode is turned on, the reading pane has a dark background to reduce eye strain. You can make the reading pane brighter by selecting at the top of the reading pane. If you don't see the button, select .

使用 vlookup、hlookup 和其他函数（如 index 和 match）根据您输入的值搜索和查找数据。 本文将让您快速回顾 vlookup，然后链接到更多内容。

Important: Before trying any of the solutions below, make sure you back up your personal files. You can back up your Windows PC, or insert a USB drive and use File Explorer to drag and copy important files to the USB drive.If you’re signing into Windows with a Microsoft account, your system settings will be automatically restored after updating, once you’re connected to the internet.