How To Select Alternate Rows In Excel

Download Article

Ever wanted to select every other row i.e. alternate rows? Perhaps you desire to apply a background color to them. Maybe you desire to delete them. Attempting this manually on hundreds of rows is a waste product of endeavor because information technology tin exist washed automatically. Here is the software doubter explanation whether y'all're using Excel, Numbers, OpenOffice.org Calc, Google Docs or Gnumeric.org.

Steps Download Article

1

Choose a bare cell in the aforementioned row but adjacent to the column you lot want to sort.
2

Blazon in =MOD(ROW();2)

Advertisement
3

If yous're using Excel type =Modernistic(ROW(),ii)
four

Fill this formula to the bottom.
5
Now you lot can either;
- Sort the whole sheet by this cavalcade in ascending alphabetical order or,
- Use a filter.
6

To utilize a background colour to alternate rows, get to conditional formatting.
7

Cull Formula is then =MOD(ROW();ii) but again supercede the ; with a , if you lot're using Excel.
viii

Choose a colour.
9

Click OK.

Advertisement

Add New Question

Question

How practise I select alternating rows or columns for formula or color?

A way that doesn't require whatsoever special utilities is to simply number your rows, then copy and paste the numbering immediately beneath the numbers (so the column goes 1-north,1-north). Now merely sort the tabular array by that column and information technology will insert the blank line between each. Delete your numbered column if desired.
Question

Is there a way to automatically insert a bare row between any 2 non-empty rows?

If using Microsoft Excel, there is a free utility program called ASAP Utilities, which has this feature, besides as many other shortcuts for different Excel formulas and formatting.