You can use data from a Excel worksheet as the basis for a PivotTable or PivotChart. The data should be in list format, with column labels in the first row, which Excel will use for Field Names.Each cell in subsequent rows should contain data appropriate to its column heading, and you shouldn't mix data types in the same column.

Troubleshooting: I don't see Automatic Replies. If you don't see Automatic Replies after selecting File, you're probably using a Gmail, Yahoo, or other POP or IMAP account that doesn't support the Outlook Automatic Replies feature.You can set up a rule that will reply to incoming messages—if you leave Outlook running while you're away.

Download and install the My Apps Secure Sign-in Extension. Download and install the My Apps Secure Sign-in Extension, if you're prompted. This extension helps you use your desktop browser to use single sign-on with your organization's cloud apps.

After you update a drop-down list, make sure it works the way you want. For example, check to see how to Change the column width and row height to show your updated entries. If the list of entries for your drop-down list is on another worksheet and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet.

On the Choose an account screen, click the Microsoft account button.; On the Add your Microsoft account screen, enter the email address and password associated with your Microsoft account.; On the Make it yours screen, you'll have the option to make this Microsoft account your primary account. (This makes sign-in, settings, and syncing happen automatically for all other Microsoft services.)

If you think someone might have unauthorized access to your account, we can protect you by signing you out from all of your trusted devices. Within 24 hours, you will be signed out of browsers, apps and anywhere else your account is used to sign in, except an Xbox console.

Learn how to activate Office pre-installed on new Windows 10 PCs or with a new product key.

Here's how: Open the new Microsoft Edge , select Settings and more at the top of the window, and then select Settings .

The following illustration shows how these keys are arranged on a typical keyboard. Your keyboard layout might be different. Typing text. Whenever you need to type something in a program, e‑mail message, or text box, you'll see a blinking vertical line ( ) called the cursor or insertion point.It shows where the text that you type will begin.

Type about in the search box on your taskbar, and then select About your PC.. View your PC info