Create and print labels - Microsoft Support
Select Options and choose a label vendor and product to use. Select OK.. If you don’t see your product number, select New Label and configure a custom label.
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 2019 for Mac, Word 2016
Obtain a digital certificate and create a digital signature
This article explains how you can get or create a digital signature for use in Office documents. To learn more about how to use them in Office documents, see Add or remove a digital signature in Office files.. What is a digital signature?
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Word 2021, Word 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Office 2016, Excel 2013, Word 2013, Outlook 2013, PowerPoint 2013, Office 2013
Excel calendar templates - Microsoft Support
Download a calendar template: Browse through the calendar templates, choose an Excel calendar template that is best for you.Click the Download button on the template page, open the template file in Excel, and then edit and save your calendar.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Make a checklist in Word - Microsoft Support
Add an interactive checklist. Checklist is a feature that allows you to insert an interactive list in Word for Web. You can check and uncheck the checklist and keep track of the tasks that you are performing.
Applies To: Word for Microsoft 365, Word for the web, Word 2021, Word 2019, Word 2016
XLOOKUP function - Microsoft Support
Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.
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 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Create a drop-down list - Microsoft Support
After you create your drop-down list, make sure it works the way you want. For example, you might want to check to see if Change the column width and row height to show all your entries.. If the list of entries for your drop-down list is on another worksheet and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet.
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
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
Change the capitalization or case of text - Microsoft Support
PowerPoint for the web supports changing case. See the procedure below. Word for the web doesn't support changing case. Use the desktop application to open the document and change text case there, or else you can manually change the casing of text in Word for the web.
Applies To: Word for Microsoft 365, PowerPoint for Microsoft 365, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Word for the web, PowerPoint for the web, Word 2021, PowerPoint 2021, Word 2021 for Mac, PowerPoint 2021 for Mac, Word 2019, PowerPoint 2019, Word 2019 for Mac, PowerPoint 2019 for Mac, Word 2016, PowerPoint 2016
Translate text into a different language - Microsoft Support
To change your translation preferences, go to Home > Translate > Translation Preferences.. Here you can set your preferred language. Translate part of an email. To translate just a bit of text from a message, select that text and right-click.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Word for the web, Excel 2021, Word 2021, PowerPoint 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, OneNote 2021, Excel 2021 for Mac, Word 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, PowerPoint 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Excel 2019 for Mac, Word 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, PowerPoint 2016, OneNote 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016
Share OneDrive files and folders - Microsoft Support
The files on your OneDrive are private until you share them. Keep in mind that when you share folders with Edit permissions, people you share with can add the shared folders to their own OneDrive.. This lets them keep the folder alongside their own folders and items, easily move items between folders, and more easily work on it offline.
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013 Enterprise, SharePoint in Microsoft 365, Office for business, Microsoft 365 admin, OneDrive (work or school), OneDrive (home or personal), SharePoint in Microsoft 365 Small Business