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.

To create a number format that includes text that is typed in a cell, insert an "at" sign (@) in the text section of the number format code section at the point where you want the typed text to be displayed in the cell.

Get answers to all of your OneNote questions with our how-to articles, training videos, and support content.

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.

The exception to this is if you turn off the setting that disables all non-essential connected experiences. The service that roams your privacy settings across devices is also turned off by that switch, so when that setting is off your settings will not roam to, or from, that particular device.

Sign in to www.office.com from a web browser and start using the apps on the web or access other web services associated with your account such as OneDrive.. How you sign in to an installed Office app depends on your device.

Clear this check box. To prevent users from. Select locked cells. Moving the pointer to cells for which the Locked check box is selected on the Protection tab of the Format Cells dialog box. By default, users are allowed to select locked cells.

Scenario. Description. Recommended solution. Advanced diagnostics (Outlook) Creates a detailed report of my Outlook, Office, Windows and mailbox configuration.

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.

Tip: If you're a Microsoft 365 Family or Personal subscriber you get Microsoft Defender, our advanced security software for Windows, Mac, iOS, and Android, as part of your subscription.Learn more at Getting started with Microsoft Defender.