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.

Function. Description. ARRAYTOTEXT function. Returns an array of text values from any specified range. ASC function. Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters

When you enter some text into a cell such as "2/2", Excel assumes that this is a date and formats it according to the default date setting in Control Panel.Excel might format it as "2-Feb".If you change your date setting in Control Panel, the default date format in Excel will change accordingly.

Problem. In SharePoint or OneDrive, you experience one or more of the following problem scenarios: Scenario 1: You're missing a file, folder, or item from a list or library.

You can use the Advanced Filter dialog box to extract the unique values from a column of data and paste them to a new location. Then you can use the ROWS function to count the number of items in the new range.. Select the range of cells, or make sure the active cell is in a table. Make sure the range of cells has a column heading.

Note: This article explains how to create a shortcut on your desktop.You can also add a program to the taskbar. If you are using Windows 10, right-click the program name or tile, click More > Pin to taskbar.If you are using Windows 11, right-click the program name or tile, and then select Pin to taskbar.

Note: The TEXT function converts numbers to text, which may make it difficult to reference in later calculations.It’s best to keep your original value in one cell, and then use the TEXT function in another cell. Then, if you need to build other formulas, always reference the original value and not the TEXT function result.

In the Insert Object box, select Create from file, and then enter the PDF file location; or select Browse, find the PDF file, and then select OK.. This makes the PDF file part of the presentation file. The quality of the PDF file is reduced with this method, but you can open the full PDF file by double-clicking the image when viewing or editing in Normal view.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Managing permissions on a site. As a member of the Site owners group, you determine the level of access to your site. You can grant users access to the whole site, or to specific information on the site, such as a list or even a single file.