Open and find items in an Outlook Data File (.pst)
Expand the top level of the Outlook data file in the Outlook Navigation pane to see the subfolders in the file. Click each subfolder to see the contents.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Sign in to sync Microsoft Edge across devices
When you sign in to sync to Microsoft Edge , you can easily browse the web from any of your devices, keep your favorites organized, and always pick up right where you left off.. Sign in to sync your account on your computer Setting up sync on your computer. In Microsoft Edge, select the profile image in the browser taskbar.
Create a flow chart with SmartArt - Microsoft Support
Change the colors of your flow chart. To quickly add a designer-quality look and polish to your SmartArt graphic, you can change the colors or apply a SmartArt Style to your flow chart.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Excel 2021, Word 2021, PowerPoint 2021, Excel 2019, Word 2019, PowerPoint 2019, Excel 2016, Word 2016, PowerPoint 2016
Microsoft Support
Microsoft support is here to help you with Microsoft products. Find how-to articles, videos, and training for Microsoft Copilot, Microsoft 365, Windows, Surface, and more.
Change a theme and make it the default in Outlook or Access
I want to. Change theme colors. Outlook. Access. More about themes. Change theme colors Outlook. Open a new message. On the Options tab, click Colors, and pick the color set you want.
Applies To: Outlook for Microsoft 365, Access for Microsoft 365, Outlook 2021, Access 2021, Outlook 2019, Access 2019, Outlook 2016, Access 2016
Overview of Excel tables - Microsoft Support
Total row Once you add a total row to a table, Excel gives you an AutoSum drop-down list to select from functions such as SUM, AVERAGE, and so on.When you select one of these options, the table will automatically convert them to a SUBTOTAL function, which will ignore rows that have been hidden with a filter by default.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel 2013
CONCAT function - Microsoft Support
The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide delimiter or IgnoreEmpty arguments. CONCAT replaces the CONCATENATE function.However, the CONCATENATE function will stay available for compatibility with earlier versions of Excel.
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
Share files and folders in OneDrive (personal) - Microsoft Support
It’s always good to stay on top of the content you’ve shared with friends, family, and collaborators. OneDrive makes it easy. Simply log into your account at OneDrive.com, and in the left-side navigation area, you’ll see a view called Shared.. This view lets you quickly see all of your content that’s shared, especially the content that you’ve shared with others.
Applies To: OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Import or export text (.txt or .csv) files - Microsoft Support
Import a text file by opening it in Excel. You can open a text file that you created in another program as an Excel workbook by using the Open command. Opening a text file in Excel does not change the format of the file — you can see this in the Excel title bar, where the name of the file retains the text file name extension (for example, .txt or .csv).
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Date and time functions (reference) - Microsoft Support
Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.
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