An array formula is a formula that can perform multiple calculations on one or more items in an array. You can think of an array as a row or column of values, or a combination of rows and columns of values. Array formulas can return either multiple results, or a single result. Beginning with the September 2018 update for Microsoft 365, any ...

Supports the use of VBA projects. Excel 4.0 Workbook. .xlw. An Excel 4.0 file format that saves only worksheets, chart sheets, and macro sheets. You can open a workbook in this file format in Excel 2010, but you cannot save an Excel file to this file format. Works 6.0-9.0 spreadsheet. .xlr.

If you trust a file, file type, folder, or a process that Windows Security has detected as malicious, you can stop Windows Security from alerting you or blocking the program by adding the file to the exclusions list.

Resize columns. Select a column or a range of columns. On the Home tab, select Format > Column Width (or Column Height ). Type the column width and select OK.

Create a rule from a template. Select File > Manage Rules & Alerts > New Rule. Select a template. Select Flag messages from someone for follow-up. Edit the rule description. Select an underlined value, choose the options you want, and then select OK. Select Next. Select the conditions, add the relevant information, and then select OK.

To use Image Creator, open Microsoft Paint and select the Image Creator icon on the toolbar to see the side panel. In the text box, enter a description of the image you want to create. For example, you can type "a blue cat with a red hat" or "a landscape with mountains and a lake". Be as descriptive as possible to generate results matching your ...

Go to File > Export > Export to PowerPoint presentation . In the Export to presentation window, choose a design theme for your presentation, and then select Export . Word exports and transforms the document, applying the design theme you chose. After the transformation is complete, select Open presentation to review the results in PowerPoint ...

Make sure all columns have headers, with a single row of unique, non-blank labels for each column. Avoid double rows of headers or merged cells. Format your data as an Excel table (select anywhere in your data, and then select Insert > Table from the ribbon). If you have complicated or nested data, use Power Query to transform it (for example ...

Zip and unzip files. Zipped (compressed) files take up less storage space and can be transferred to other computers more quickly than uncompressed files. In Windows, you work with zipped files and folders in the same way that you work with uncompressed files and folders. Combine several files into a single zipped folder to more easily share a ...

In Outlook on your desktop, choose File > Open & Export > Open Outlook Data File. Choose the Outlook data file you want to open. 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. To search for a specific email, use Outlook's built-in search ...