To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.

Invisible digital signatures in Word, Excel, or PowerPoint. An invisible digital signature, like a visible digital signature line, assures the authenticity, integrity, and origin of a document.

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

Note: The TEXT function converts numbers to text, which may make it difficult to reference in later calculations.It’s best to keep your original value in one cell, and then use the TEXT function in another cell. Then, if you need to build other formulas, always reference the original value and not the TEXT function result.

In this example, the formula in cell D2 says: IF(C2 = 1, then return Yes, otherwise return No)As you see, the IF function can be used to evaluate both text and values.It can also be used to evaluate errors.You are not limited to only checking if one thing is equal to another and returning a single result, you can also use mathematical operators and perform additional calculations depending on ...

Function. Description. CUBEKPIMEMBER function. Returns a key performance indicator (KPI) property and displays the KPI name in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, that is used to monitor an organization's performance.

If prompted, enter your password. However, if you have two-factor authentication set up, you might see a window asking you to Create an app-specific password.To obtain an app-password, do the following:

Scenario. Description. Recommended Solution. Add Teams meeting add-in for Outlook. Helps fix the issue where teams meeting add-in is missing or is not loaded, preventing you from creating teams meeting from Outlook.

If you want to give access to desktop apps, make sure that Let desktop apps access your microphone is turned on.You can't turn off microphone access for individual apps. Others can't hear me. Try the following solutions:

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.