In the Create New Folder dialog box, name the folder, select where to place it, and then click OK. It’s probably best to place the new folder in the Contacts folder. To make sure your folder is available as an address book, right-click the new folder, and then click Properties. Click the Outlook Address Book tab, and make sure that the check ...

Change the default font, color, style, and size for messages. On the File tab, choose Options > Mail. Under Compose messages, choose Stationery and Fonts. On the Personal Stationery tab, under New mail messages or Replying or forwarding messages, choose Font. In the Font box, choose the font, style, size, and color that you want to use.

Create a 3-D reference. Click the cell where you want to enter the function. Type = (equal sign), enter the name of the function, and then type an opening parenthesis. Adds numbers. Calculates average (arithmetic mean) of numbers. Calculates average (arithmetic mean) of numbers; includes text and logicals.

If you're using a Microsoft 365 Family subscription that someone else shared with you, or if you have another type of Microsoft 365 subscription, you can't share your subscription with other people. Choose how you'd like to share. Select Email invite then enter their email and select Invite. Select Create link then select Copy link.

Press Ctrl+A, and press Delete again. If you're using a device that doesn't have a keyboard, try removing the PivotTable like this: Pick a cell anywhere in the PivotTable to show the PivotTable Tools on the ribbon. Click PivotTable Analyze > Select, and then pick Entire PivotTable. Pick a cell anywhere on the PivotTable for the " Delete ...

To do this. Press. Start a presentation from the beginning. F5. Start a presentation from the current slide. Shift+F5. Start the presentation in Presenter View. Alt+F5. Perform the next animation or advance to the next slide.

Next steps. After you select the Print check box, you might want to take the following steps:. Preview the gridlines – To see how the gridlines will print, press Ctrl+F2 to open the File tab, which displays a preview of printed worksheet. Gridlines print only around actual data in a worksheet. If you want to print gridlines around empty cells also, you must set the print area to include ...

When you need to know how many words, pages, characters, paragraphs, or lines are in a document, check the status bar. For a partial word count, select the words you want to count. The status bar shows the word count for that selection and for the entire document. Tip: Find the number of characters, paragraphs, and lines by clicking on the word ...

Change part of a document to landscape. Select the content that you want on a landscape page. Go to Layout, and open the Page Setup dialog box. Select Landscape, and in the Apply to box, choose Selected text. Choose either portrait (vertical) or landscape (horizontal) orientation for all or part of your document.

Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.