Excel help & learning
Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.
Block or allow (junk email settings) - Microsoft Support
Use the Block or Allow settings to help control unwanted and unsolicited email messages by creating and managing lists of email addresses and domains that you trust and those that you don’t.
Applies To: Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019, Outlook Web App
Manage my mailbox size - Microsoft Support
Learn how to manage your mailbox size and keep it within a specific size limitation with Microsoft Support.
Applies To: Outlook 2021, Outlook 2019, Outlook 2016, Outlook 2013, Microsoft 365 admin
Introduction to Outlook Data Files (.pst and .ost)
Note: In earlier versions of Outlook, IMAP accounts also used an Outlook Data File (.pst).In Outlook 2016 and Outlook for Microsoft 365, IMAP accounts use Offline Outlook Data Files (.ost). You can also use an Outlook Data File (.pst) to backup or export items from any type of email account.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Fill data automatically in worksheet cells - Microsoft Support
Automatically fill a series of data in your worksheet, like dates, numbers, text, and formulas. Use the AutoComplete feature, Auto Fill Options button and more.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Convert numbers into words - Microsoft Support
Note: Microsoft provides programming examples for illustration only, without warranty either expressed or implied.This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the VBA programming language, and with the tools that are used to create and to debug procedures.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Create a SmartArt graphic from scratch - Microsoft Support
To add text, like a title, in an arbitrary position close to or on top of your SmartArt graphic, on the Insert tab, in the Text group, click Text Box to insert a text box. If you want only the text in your text box to appear, right-click your text box, click Format Shape or Format Text Box, and then set the text box to have no background color and no border.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, PowerPoint for the web, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016
Combine text from two or more cells into one cell
Select the cell you want to combine first. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text.
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, Excel Mobile
What's new in Word 2021 for Windows - Microsoft Support
Word 2021 for Windows enables you to create compelling content and includes co-authoring, new stock media from the Office Premium Creative Content collection, and new Draw tab additions such as Point Eraser, Ruler, and Lasso.
Applies To: Word 2021
How to help keep your Microsoft account safe and secure
If you receive an email notifying you of unusual activity, you can see when and where your account has been accessed—including successful sign-ins and security challenges—on the Recent activity page. Microsoft learns how you usually sign in to your account and flags events that are suspicious.
Applies To: Microsoft account dashboard