Tip: If you want to bypass File > Open and always use the Open dialog box, do this: Select File > Options > Save, and then select the Don’t show the Backstage when opening or saving files check box. Then, close and reopen any open Office applications. Note that this change only affects what you see when you press CTRL+O to access the Open Files dialog box.

Add guests to a group. When you add guests, also known as external users, to a group, you're granting them access to all information within the group.

The COUNTIFS function is similar to the COUNTIF function with one important exception: COUNTIFS lets you apply criteria to cells across multiple ranges and counts the number of times all criteria are met. You can use up to 127 range/criteria pairs with COUNTIFS. The syntax for COUNTIFS is: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2],…)

Send in your Surface. If none of the previous solutions have resolved your issue, you can send in your Surface. If you decide to send it in, go to Device service and repair and sign in with your Microsoft account. If your device is already registered, select it and follow the instructions.

Inserting ASCII characters. To insert an ASCII character, press and hold down ALT while typing the character code. For example, to insert the degree (º) symbol, press and hold down ALT while typing 0176 on the numeric keypad.

Contact Microsoft Support. What's new. Surface Pro; Surface Laptop; Surface Laptop Studio 2

To create a post: Select the Find players tab, choose a game, and then select Create a post.; Add tags and a description (this makes it easier to connect with gamers that play like you), then adjust the details, such as the number of players needed.

There are several ways to reduce your mailbox size. You can use the Mailbox Cleanup tool to view the size of your mailbox and individual folders. This tool can also help you search for older or very large messages that you might want to delete or move to an Outlook Data File (.pst).

You might have tried using shape styles to change the shape of WordArt and then were puzzled that the text didn’t change. Use the text options in the WordArt Styles group instead. Shape styles and effects apply to the box and background surrounding your WordArt, not to the WordArt text.

Select Start , then select Settings > Personalization > Themes.Choose from a default theme or select Get more themes in Microsoft Store if you want to download new themes with desktop backgrounds that feature cute critters, breathtaking landscapes, and other smile-inducing options.