Extend Highlight Log For Free

Double-click the cell, and then drag across the contents of the cell that you want to select. Click the cell, and then drag across the contents of the cell that you want to select in the formula bar.

In the formula field, enter the following formula: =$C2=?Bob? Click the 'Format' button. In the dialog box that opens, set the color in which you want the row to get highlighted. Click OK.

Mobile Devices (iOS or Android) Tap anywhere on the text that you need to highlight. Use the markers that pop up to select the entire text, and then release your finger. Tap on the ?A? next to the plus sign. Choose ?Text? from the menu that pops up and select ?Highlight Color?.

If you want to highlight a whole line of text, move your cursor to the start of the line, hold Shift , and then press Down arrow . You may also use the shortcut key combination Shift + End . If you want to highlight all text (the entire page), press the shortcut key Ctrl + A .

In the New Formatting Rule dialog box, select ?Use a formula to determine which cells to format?. In the Rule Description field, enter the formula: =OR(CELL(?col?)=COLUMN(),CELL(?row?)=ROW()) Click on the Format button and specify the formatting (the color in which you want the row/column highlighted). Click OK.

The Shift key offers a simpler way to select big chunks of text. Position your cursor at one end of the intended selection, press Shift on your keyboard, and then, while holding down the Shift key, click or tap at the other end of the area you want to highlight.

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.