Fresh Excel Tips

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.

To mark every other row:

1. Select cells A1:A10 and type the following formula:=IF(MOD(ROW(),2),”XXX”,” “).
2. Press Ctrl+Enter.

Please note that If every other column has to be marked, use the following formula: =IF(MOD(COLUMN(),2),”XXX”,” “).

This tip is compatible with Excel 97, 2000, 2003 and 2007.

1. How to Use the ISODD and ROW functions to determine odd rows
2. Incrementing Row Numbers in Excel
3. Use the ISODD and COLUMN functions to determine odd columns
4. How to Use the MOD function to extract the remainder of a division
5. Modify the MOD function for divisors larger than the number