Microsoft Excel Functions & Formulas

Use the ROW function to mark every other row

Sometimes it is necessary to mark every other row in a worksheet.

Several functions can be used in combination to do this. Use the

MOD, ROW, and IF functions together as described below.

4

To mark every other row:

1. Select cells A1:A10 and type the following formula:

=IF(MOD(ROW(),2),"XXX"," ").

2. Press <Ctrl+Enter>.

Note: If every other column has to be marked, use the

following formula: =IF(MOD(COLUMN(),2),"XXX"," ").

Note: See Chapter 10, “Conditional Formatting,” for

additional tips on using the MOD function.

172 Chapter 6

Figure 6-27