FILTER function. Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web More... The FILTER function allows you to filter a range of data based on criteria you define. In the following example we used the formula =FILTER (A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples ...

Use the Signature Line command to insert a signature line with an X by it to show where to sign a document. Click where you want the line. Select Insert > Signature Line. Select Microsoft Office Signature Line. In the Signature Setup box, you can type a name in the Suggested signer box. You can also add a title in the Suggested signer’s title ...

For more information, see Show the Developer tab. In the Code group on the Developer tab, click Record Macro. Optionally, enter a name for the macro in the Macro name box, enter a shortcut key in the Shortcut key box, and a description in the Description box, and then click OK to start recording. Perform the actions you want to automate, such ...

On keyboards with an Fn key, hold down Fn and press the key to use the alternate commands. Tips. You can also press and hold Fn while moving your finger up and down on the navigation pad to scroll within a document. You can press and hold Fn while pressing keyboard letters M, J, K, L, U, I, O, P, /, ;, and 0 to match the physical layout of a ...

View messages grouped by conversation in new Outlook. At the top of the page, select Settings > Mail > Layout. Under Message organization, choose either of the options depending on whether you want to show email grouped by conversation or as individual message. If you select Show email grouped by conversation, under Arrange the reading pane ...

Enable virtualization on Windows 11 PCs. Virtualization lets your PC emulate a different operating system, like Android™ or Linux. Enabling virtualization gives you access to a larger library of apps to use and install on your PC. If you upgraded from Windows 10 to Windows 11 on your PC, these steps will help you enable virtualization.

When you set a default font, every new message you create uses that font setting by default. Windows macOS Web. Go to File > Options > Mail > Stationery and Fonts... Select the font you want to change. New mail messages - Sets the default font for original messages you compose. Replying or forwarding messages - You can have a different font on ...

In the browser, go to Settings and more > About Microsoft Edge (edge://settings/help). Depending on where you purchased your device, you may see one or both of following toggles: Download and install updates automatically. Download updates over metered connections. Turn on any available toggles to always allow automatic downloads of updates.

Insert rows. To insert a single row: Right-click the whole row above which you want to insert the new row, and then select Insert Rows. To insert multiple rows: Select the same number of rows above which you want to add new ones.Right-click the selection, and then select Insert Rows.. Insert columns. To insert a single column: Right-click the whole column to the right of where you want to add ...

A macro is a series of commands and instructions that you group together as a single command to accomplish a task automatically. Windows Web. To save time on tasks you do often, bundle the steps into a macro. First, you record the macro. Then you can run the macro by clicking a button on the Quick Access Toolbar or pressing a combination of keys.