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.

Argument name. Description. lookup_value (required). The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in the table_array argument. For example, if table-array spans cells B2:D7, then your lookup_value must be in column B.. Lookup_value can be a value or a reference to a cell.. table_array (required)

To adjust power and sleep settings in Windows 10, go to Start , and select Settings > System > Power & sleep.. Under Screen, select how long you want your device to wait before turning the screen off when you're not using your device.

Swipe in from the right edge of the screen, and then tap Search.Or, if you are using a mouse, point to the lower-right corner of the screen, and then click Search.Type Command Prompt in the Search box, right-click Command Prompt, and then click Run as administrator.If you are prompted for an administrator password or for a confirmation, type the password, or click Allow.

Turn your PC off completely. To shut down, select Start and then select Power > Shut down.. Sleep. Sleep uses very little power, your PC starts up faster, and you’re instantly back to where you left off.

Select Add a printer or scanner.. Wait for it to find nearby scanners, then choose the one you want to use and select Add device.

Keystroke. What it does. Windows logo key + R Opens the Run command. Windows logo key + S Opens Search. Windows logo key + E Opens File Explorer. Alt + Tab. Opens Task Switcher, moving forward with each press of Tab, switching to that window on release

Important: Before trying any of the solutions below, make sure you back up your personal files. You can back up your Windows PC, or insert a USB drive and use File Explorer to drag and copy important files to the USB drive.If you’re signing into Windows with a Microsoft account, your system settings will be automatically restored after updating, once you’re connected to the internet.

Safe mode starts Windows in a basic state, using a limited set of files and drivers. If a problem doesn't happen in safe mode, this means that default settings and basic device drivers aren't causing the issue.

To get support in Outlook.com, click here or select Help on the menu bar and enter your query. If the self-help doesn't solve your problem, scroll down to Still need help? and select Yes.. To contact us in Outlook.com, you'll need to sign in.