Display numbers as postal codes - Microsoft Support
WEBIn the Type list, type *0 followed by the postal code format that you want to use. For example, for a 5-digit postal code, type *0#####. Create or delete a custom number format. Learn how to create your own custom postal code format in …
Download free, pre-built templates - Microsoft Support
WEBYou can download free, pre-built document templates with useful and creative themes from Office when you click File > New in your Office app. Templates can include calendars, business cards, letters, cards, brochures, newsletters, resumes, cover letters, presentations, social media and much more.
Obtain a digital certificate and create a digital signature
WEBThis 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.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
WEBIt's actually quite easy to do with a lookup function. The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE)
Create a Map chart in Excel - Microsoft Support
WEBCreate a Map chart with Data Types. Map charts have gotten even easier with geography data types. Simply input a list of geographic values, such as country, state, county, city, postal code, and so on, then select your list and go to …
View, manage, and install add-ins for Excel, PowerPoint, and Word
WEBWhen you enable an add-in, it adds custom commands and new features to Microsoft 365 programs that help increase your productivity. Because add-ins can be used by attackers to do harm to your computer, you can use add-in security settings to help protect yourself.
Create protected PDFs from Office files - Microsoft Support
WEBCreate protected PDFs from Office files. If your organization uses Microsoft Purview Information Protection, they probably want you to apply that same protection to any PDFs you create from Microsoft 365 files. Here's how to do it using a Windows PC.
Apply sensitivity labels to your files and email - Microsoft Support
WEBThe sensitivity bar makes it easy for you to see what label is applied to your file, and to apply or change a label whenever you need to, including when saving the file. Just select the sensitivity bar in the save dialog to see the labeling options for this file.
Create, load, or edit a query in Excel (Power Query) - Microsoft …
WEBCreate, load, or edit a query in Excel (Power Query) Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016. Power Query offers several ways to create and load Power queries into your workbook. You can also set default query load settings in …
Cloud fonts in Office - Microsoft Support
WEBJun 11, 2024 — Use cloud fonts to make sure your slides and documents look the same, no matter where you open them or who else views them. Cloud fonts are fonts hosted in the cloud by Microsoft 365, and are available in the latest versions of Office applications (see the Cloud fonts availability table, below).
Manage workbook links - Microsoft Support
WEBIn the Excel web app, you can manage workbook links to ensure that your data is up to date and accurate. This article explains how to manage workbook links, including how to refresh and update them, how to fix broken links, and how to work with the new security warning feature. Security Warning about workbook links