Freeze panes to lock rows and columns - Microsoft Support
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.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
View your data on the privacy dashboard - Microsoft Support
Note: Microsoft is updating the way we ask for permission to use your voice data to improve Microsoft products that use our speech recognition technology.This may impact the data you see on your privacy dashboard. To learn more about these changes, see How does Microsoft protect my privacy while improving its speech recognition technology?
Applies To: Microsoft account dashboard
Activer Windows - Support Microsoft
Si vous installez Windows sur un nouvel appareil ou une carte mère pour la première fois et que vous n’avez pas de clé de produit, sélectionnez Je n’ai pas de clé de produit pendant les écrans d’installation. À l’invite, entrez le compte Microsoft à utiliser pour acheter une licence numérique pour cet appareil.
RAND function - Microsoft Support
=RAND()*(b-a)+a. If you want to use RAND to generate a random number but don't want the numbers to change every time the cell is calculated, you can enter =RAND() in the formula bar, and then press F9 to change the formula to a random number. The formula will calculate and leave you with just a value.
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
What is: Multifactor Authentication - Microsoft Support
How does multifactor authentication work? Let's say you're going to sign into your Microsoft account or work or school account, and you enter your username and password.If that's all you need then anybody who knows your username and password can sign in as you from anywhere in the world!
Configure headers and footers for different sections of a document
Click Link to Previous to turn it off and unlink the header or footer from the previous section.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016
Common problems with two-step verification for a work or school account ...
There are some common two-step verification problems that seem to happen more frequently than any of us would like. We've put together this article to describe fixes for the most common problems.
DATEDIF function - Microsoft Support
Argument. Description. start_date . Required. A date that represents the first, or starting date of a given period. Dates may be entered as text strings within quotation marks (for example, "2001/1/30"), as serial numbers (for example, 36921, which represents January 30, 2001, if you're using the 1900 date system), or as the results of other formulas or functions (for example, DATEVALUE("2001 ...
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, SharePoint Foundation 2010, SharePoint Server 2010, Windows SharePoint Services 3.0
Share things with nearby devices in Windows - Microsoft Support
On the PC you’re sharing from, select Start , and then select Settings > System > Nearby sharing .Choose whether you’d like to be able to share and receive files with everyone, or only your own devices (where you are logged in with your Microsoft account).
Fixes or workarounds for recent issues in Outlook for PC
Then, create REG_SZ values in this key for each form you wish to allow scripts to run. In the above example, you would create a REG_SZ value named “IPM.Note.Custom” with empty data. When designing a form, Run This Form will run a form using the message class of the base form. So if you started designing an IPM.Note form and want to Run This Form, you will need to have IPM.Note registered.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016