shade rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have lots of data in continuous rows, it is difficult to follow accross
when reading each row on a print out. How do I shade alternate rows in excell
so every line looks separated without manually shading each row?
 
use conditional formatting

highlight the entire data set, choose Conditonal formatting from the format
menu, choose Formula and set it equal to

=mod(row(),2)=1

then click the format button and choose a Pattern that shades every other
row the way you want

Duke
 
-----Original Message-----
I have lots of data in continuous rows, it is difficult to follow accross
when reading each row on a print out. How do I shade alternate rows in excell
so every line looks separated without manually shading each row?
.
Try shading a couple, highlight them, copy, highlight the
Click to expand...
rest of the rows to shade, then right click, paste
special, format only.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

alternate row shading on filtered data 2
Cond. Formatting, Mod(Row) and cell conditions 2
How do I maintain alternate row shading after inserting a new row 4
shading rows in excel 10
How do I alternate shading of rows, Excel 2007, no new tabs. 1
alternate row shading kept with autofilter 3
Shaded for every other row 2
Conditional Formatting Shading For Visible Rows Only 3

Back
Top