Lock or unlock specific areas of a protected worksheet
Clear this check box. To prevent users from. Select locked cells. Moving the pointer to cells for which the Locked check box is selected on the Protection tab of the Format Cells dialog box. By default, users are allowed to select locked cells.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
IF function – nested formulas and avoiding pitfalls
So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. IF statements are incredibly robust, and form the basis of many spreadsheet models, but they are also the root cause of many spreadsheet issues.
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 Web App, Excel for Windows Phone 10
Using System File Checker in Windows - Microsoft Support
System File Checker is a utility in Windows that checks for problems with files on your computer. To run it, follow these steps: Make sure you've installed the latest updates for Windows, and then restart your machine.
Enable virtualization on Windows 11 PCs - Microsoft Support
Virtualization lets your PC emulate a different operating system, like Android™ or Linux. Enabling virtualization gives you access to a larger library of apps to use and install on your PC.
Microsoft アカウントとは - Microsoft サポート
Microsoft アカウントは何に使用されますか? Windows PC、Xbox 本体、または Office、Outlook.com、OneDrive、Xbox Live、Microsoft 365、Family Safety、Skype、Bing、Microsoft Store、MSN などの Microsoft の製品とサービスにサインインするには、Microsoft アカウントが必要です。
Applies To: Microsoft account dashboard
Setup OneDrive for Microsoft 365 for business
OneDrive is your online cloud storage within Microsoft 365. It lets you store your individual work files that you don't want your colleagues to have access to unless you choose to share the files with them.
Power efficient settings in Windows 11 - Microsoft Support
Updates to the default screen and sleep settings now help you use energy more efficiently and extend battery life. You can find efficiency settings in Windows 11 at Settings > System > Power & battery.. For a guided walkthrough of how each of the power and battery settings can improve your device's performance, click the button to open the Get Help app:
FILTER function - Microsoft Support
The FILTER function allows you to filter a range of data based on criteria you define.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
SUMIF function - Microsoft Support
sum_range Optional.The actual cells to add, if you want to add cells other than those specified in the range argument. If the sum_range argument is omitted, Excel adds the cells that are specified in the range argument (the same cells to which the criteria is applied).. Sum_range should be the same size and shape as range.If it isn't, performance may suffer, and the formula will sum a range of ...
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
Install Visio or access Visio for the web - Microsoft Support
Install Visio (Visio Plan 2 or Visio Professional) Below we describe how to install the desktop app that is included with Visio Plan 2, and non-subscription versions of Visio Professional or Visio Standard 2021, 2019, or 2016.. If you have Visio Plan 1 see the steps under the tab Visio for the web. Step 1: Associate Visio with your account
Applies To: Visio Plan 2, Visio Professional 2021, Visio Standard 2021, Visio Professional 2019, Visio Standard 2019, Visio Professional 2016, Visio Standard 2016, Office for business, Office 365 Small Business, Microsoft 365 admin