Category: Microsoft Office

Select cells A1:A8. On Excel’s Home tab choose Conditional Formatting, Highlight Cells Rules, and then Duplicate Values. In this case, Excel displays the Duplicate Values dialog box and also provides a preview of the formatting to be applied to your...

On the worksheet, do one of the following: To lock rows, select the row below the row or rows that you want to keep visible when you scroll. To lock columns, select the column to the right of the column...