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.

Tip: If you're already in Word for the web, get to the letter templates by going to File > New, and then below the template images click More on Office.com. You'll be on the Templates for Word page. In the list of categories, click Letters.

Open Rewards dashboard. To earn points by searching with Bing on your mobile device, set Bing as your default search engine, use the Bing app, or use the Microsoft Launcher for Android app.

Looks up "B" in row 1, and returns the value from row 3 that's in the same column. Because an exact match for "B" is not found, the largest value in row 1 that is less than "B" is used: "Axles," in column A. 5 =HLOOKUP("Bolts", A1:C4, 4) Looks up "Bolts" in row 1, and returns the value from row 4 that's in the same column (column C). 11

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.

Show the Developer tab. If the developer tab isn't displayed in the ribbon, see Show the Developer tab.. Open a template or use a blank document. To create a form in Word that others can fill out, start with a template or document and add content controls.

Using any of the row formatting commands, including changing row height or hiding rows (Home > Format). Insert columns. Inserting columns. Insert rows. Inserting rows. Insert hyperlinks. Inserting new hyperlinks, even in unlocked cells. Delete columns. Deleting columns.

These are the buttons and bars that sit right next to your Start button and cannot be moved.. Search on the taskbar can be set in four ways: either to Search box, which includes a full text box to enter your search (or your Bing Chat prompt; see Using the new Bing on the Windows taskbar for more) into plus additional search highlights, Search icon and label (displaying as a search icon and ...

Select Start > Settings > Personalization.The preview window gives you a sneak peek of your changes as you make them. In Personalize your background, you can select a picture, a solid color, or a slideshow of pictures you create.Or you can choose Windows spotlight to see a new image from around the world every day.

You can use the Cut command or Copy command to move or copy selected cells, rows, and columns, but you can also move or copy them by using the mouse.. By default, Excel displays the Paste Options button. If you need to redisplay it, go to Advanced in Excel Options.For more information, see Advanced options.