Create a named range from selected cells in a worksheet
Select the range you want to name, including the row or column labels. Click Formulas > Create from Selection. In the Create Names from Selection dialog box, select the checkbox (es) depending on the location of your row/column header. If you have only a header row at the top of the table, then just select Top row.
Applies To:
Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013
Lock or unlock specific areas of a protected worksheet
If prompted, enter the password to unprotect the worksheet. Select the whole worksheet by selecting Select All. On the Home tab, select the Font Settings popup launcher. You can also press Ctrl+Shift+F or Ctrl+1. In the Format Cells dialog box, select the Protection tab and uncheck the Locked box and then select OK.
Applies To:
Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
使用 Excel 公式计算还款和存款 - Microsoft 支持
使用函数 PMT (rate、NPER、PV) =PMT (5%/12,30*12,180000) 结果是每月支付 (不包括保险和税款) 966.28 美元。. 利率参数是 5% 除以一年中的 12 个月。. NPER 参数是 30*12，即 30 年按揭付款，每年付款 12 期（按月付款）。. PV 参数是 180000（贷款的现值）。. 了解如何每月为梦想 ...
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel 2013, Excel Mobile
Use Conditional formatting rules to change incoming messages in Outlook ...
Navigate to Settings > Mail > Conditional Formatting. Select + Create new conditional formatting rule. Name your new rule. Choose your condition (s). Select the font color for the message list to display. Under Preview, you can an example of how the text will appear. When you're satisfied with your selection, click OK.
Applies To:
Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Office for business, Office 365 Small Business, Microsoft 365 admin, Outlook on the web, New Outlook for Windows
Word で行間を変更する - Microsoft サポート
Word で行間を変更する. [ デザイン ]、 [ 段落の間隔] の順に選択します。. 各オプションをマウスでポイントしてプレビューを表示し、目的のオプションを選択します。. 1 行改行の場合は、 [ 段落間隔なし] を選択します。.
Applies To:
Word 2013, Word 2010, Word 2007, Word Starter 2010
Uninstall or remove apps and programs in Windows
Select Start > All apps and search for the app in the list shown. Press and hold (or right-click) on the app, then select Uninstall. Uninstall in Settings. Select Start > Settings > Apps > Apps & features . Find the app you want to remove, select More > Uninstall. Note: Some apps can't be uninstalled from the Settings app right now.
Defragment your Windows 10 PC - Microsoft Support
Windows 10. 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. Select Defragment and Optimize Drives. Select the disk drive you want to optimize. Select the Optimize button.
VLOOKUP function - Microsoft Support
Argument name. Description. lookup_value (required). The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in the table_array argument. For example, if table-array spans cells B2:D7, then your lookup_value must be in column B.. Lookup_value can be a value or a reference to a cell.. table_array (required)
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Word のオプション ([詳細設定]) - Microsoft サポート
Word の詳細設定オプションを表示するには、 [ ファイル ]、 [ オプション] の順に選び、左側のウィンドウで [ 詳細設定] を選びます。. 単語と段落を選択、置換、書式設定する方法を設定します。. 同じ文書内または別の文書やアプリ間でコンテンツを ...
Applies To:
Word for Microsoft 365, Word 2021, Word 2019, Word 2016, Word 2013
Keyboard shortcut for print screen - Microsoft Support
Windows 10. Depending on your hardware, you may use the Windows Logo Key + PrtScn button as a shortcut for print screen. If your device does not have the PrtScn button, you may use Fn + Windows logo key + Space Bar to take a screenshot, which can then be printed. To locate your screenshots, open File Explorer from the taskbar. On the side ...