Notes: The formatting options that appear in the Formatting tab depend on the data you have selected. If your selection contains only text, then the available options are Text, Duplicate, Unique, Equal To, and Clear.When the selection contains only numbers, or both text and numbers, then the options are Data Bars, Colors, Icon Sets, Greater, Top 10%, and Clear.

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.

To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.

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.

To access your sign-in options, go to Start > Settings > Accounts > Sign-in options.. Or just select this button: Go to Sign-in options. Change or manage your password or PIN. To change your password or PIN, go to Start > Settings > Accounts > Sign-in options. Select PIN (Windows Hello), and then select Change PIN.

提示: 登入時，如果您下次想要直接移至信箱，請在 [保持登入?] 提示中選取 [是] (不建議用於共用電腦)。 或者，選取 [不要再顯示這個] 方塊，然後選取 [否]，這樣每次都會提示您輸入密碼。. 如果您無法登入或忘記您的使用者名稱或密碼，請使用我們的 [登入疑難排解員]。

Important: You won't lose files or data by resetting OneDrive on your computer.Resetting OneDrive only disconnects all your sync connections (including personal and work or school).

Immersive Reader advanced color support. In Immersive Reader, we've added many additional ways you can choose a page color.Selecting a page color can make text easy to scan with less eye strain. On the Immersive Reader tab click Page Color to see a 4x5 color picker.. Click More Colors to see additional color selection options such as Wheel, Sliders, Color Palettes, Image Palettes, and Pencils.

In the search box on the taskbar, type Manage BitLocker and then select it from the list of results. Or, select the Start button, and then under Windows System, select Control Panel.In Control Panel, select System and Security, and then under BitLocker Drive Encryption, select Manage BitLocker. Note: You'll only see this option if BitLocker is available for your device.

Get from External Data Source. Get from Data Model. Use this option if your workbook contains a Data Model, and you want to create a PivotTable from multiple tables, enhance the PivotTable with custom measures, or are working with very large datasets.. Get from Power BI. Use this option if your organization uses Power BI and you want to discover and connect to endorsed cloud datasets you have ...