External or guest sharing in OneDrive, SharePoint, and Lists
If you want to secure your content and get a link that only works for the people you invite, select Specific people in Link settings when creating the sharing link.. The recipients' experience depends on the settings you select when creating the sharing link, and the account they use to view the file.
Applies To: Microsoft Lists, OneDrive (work or school), OneDrive for Mac, OneDrive for Windows
INDIRECT function - Microsoft Support
Example. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.
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
Create list relationships by using lookup columns
Select Save and fill out the target list.When you add a book to the target list (Reading list), there is now an option to add information from the source list. For the example, for The Future of Computing by Lovelace, select the Course Name "Machine Learning" and the Course ID will be automatically filled in (in this case, it's CS405).Since the columns are lookup columns, you only need to fill ...
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013 Enterprise, SharePoint in Microsoft 365, SharePoint Foundation 2013, Microsoft Lists
Use la herramienta Comprobador de archivos de sistema para reparar los ...
Deslice el dedo rápidamente desde el borde derecho de la pantalla y pulse Buscar.O bien, si usa un mouse, señale el extremo inferior derecho de la pantalla y haga clic en Búsqueda.Escriba Símbolo del sistema en el cuadro de Búsqueda, haga clic con el botón derecho en Símbolo del sistema y luego haga clic en Ejecutar como administrador.Si se le pide una contraseña de administrador o que ...
Change macro security settings in Excel - Microsoft Support
Disable all macros except digitally signed macros This setting is the same as the Disable all macros with notification option, except that if the macro is digitally signed by a trusted publisher, the macro can run if you have already trusted the publisher. If you have not trusted the publisher, you are notified. That way, you can choose to enable those signed macros or trust the publisher.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013
Use Microsoft Authenticator with Microsoft 365
Choose the mobile app. Open a browser on your computer and go to portal.office.com.Sign in to your Office 365 for business account.
Applies To: Office for business, Microsoft 365 admin
Check spelling and grammar in a different language
Tip: To prevent having to manually configure the proofing language with each new document in Word, switch on the option to detect the language you're writing.On the Review tab, go to Language.Choose Language > Set Proofing Language, and then select Detect language automatically.
Applies To: Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Word for the web, Word 2021, Outlook 2021, PowerPoint 2021, Publisher 2021, OneNote 2021, Word 2021 for Mac, PowerPoint 2021 for Mac, Word 2019, Outlook 2019, PowerPoint 2019, Publisher 2019, Word 2019 for Mac, PowerPoint 2019 for Mac, Word 2016, Outlook 2016, PowerPoint 2016, OneNote 2016, Publisher 2016
Get started with Python in Excel - Microsoft Support
Python in Excel uses the custom Python function xl() to interface between Excel and Python. The xl() function accepts Excel objects like ranges, tables, queries, and names.. You can also directly type references into a Python cell with the xl() function. For example, to reference cell A1 use xl("A1") and for the range B1:C4 use xl("B1:C4").For a table with headers named MyTable, use xl ...
Applies To: Excel for Microsoft 365
Manage meeting attendance reports in Microsoft Teams
Scheduled channel meetings The Attendance tile isn't supported for channel meeting.To view the attendance reports for meetings created in channels, select More actions > View meeting details. Then, select the Attendance tab. . Engagement information
Applies To: Microsoft Teams, Microsoft Teams for Education, Microsoft Teams small business
Use Immersive Reader in Word - Microsoft Support
Support reading and writing by using Immersive Reader to customize how word documents appear while you read and edit. Immersive Reader provides options for a comfortable and easy to process experience by allowing you to listen to the text read aloud or adjust how text appears by modifying spacing, color and more.
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for the web, Word 2021, Word 2021 for Mac, Word 2019, Word for iPad