After you create your drop-down list, make sure it works the way you want. For example, you might want to check to see if Change the column width and row height to show all your 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.

If Windows Update finds an updated driver, it will download and install it, and your printer will automatically use it. If a device driver couldn’t be installed automatically, there may be an optional driver available that your printer can use.

To pin apps to the taskbar. Select Start , select the arrow next to All apps, right-click the app, then select More > Pin to taskbar.

Locate custom fonts on the Web . In addition to acquiring and using fonts installed with other applications, you can download fonts from the Internet.

Under Proofing, if your language shows as Installed, you're ready to go.Otherwise press Not installed and Office will take you to a page where you can download the necessary Language Accessory Pack for that language. Follow the instructions on that page to download and install the pack, then come back to the Office Language Preferences dialog box to confirm that it's now installed.

Note: The TEXT function converts numbers to text, which may make it difficult to reference in later calculations.It’s best to keep your original value in one cell, and then use the TEXT function in another cell. Then, if you need to build other formulas, always reference the original value and not the TEXT function result.

Learn how to use Remote Desktop in Windows. On your Windows, Android, or iOS device: Open the Remote Desktop app (available for free from Microsoft Store, Google Play, and the Mac App Store), and add the name of the PC that you want to connect to (from Step 1). Select the remote PC name that you added, and then wait for the connection to complete.

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.

With PowerPoint for the web you create presentations right in your browser. Create and save your presentations in your OneDrive, and edit and share them online.

Whether it's for work or personal use, you can connect to a virtual private network (VPN) on your Windows PC. A VPN connection can help provide a more secure connection and access to your company's network and the internet, for example, when you’re working from a coffee shop or similar public place.