Ask Question
26 July, 11:56

How to highlight every other row in excel?

+4
Answers (1)
  1. 26 July, 12:11
    0
    Method 1: Use the "Format as Table" option To use the Format as Table option to shade rows in a worksheet, follow these steps: Open the worksheet. Select the cell range that you want to shade, or press Ctrl+A to select the whole worksheet. Click the Home tab. In the Styles group, click Format as Table, and then click the style of formatting that you want. In the Format as Table dialog box, click OK.

    Method 2: Use the "Conditional Formatting" option To use the Conditional Formatting option to shade rows in a worksheet, follow these steps: Open the worksheet. Select the cell range that you want to shade, or press Ctrl+A to select the whole worksheet. Click the Home tab. In the Styles group, click Conditional Formatting, and then click Manage Rules. Click New rule. Click Use a formula to determine which cells to format. In the Format values where this formula is true box, type = MOD (ROW (),2) = 1, and then click Format.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “How to highlight every other row in excel? ...” in 📘 Computers and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers