Home |
Search |
Today's Posts |
#1
|
|||
|
|||
shade rows
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? |
#2
|
|||
|
|||
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 "Manohar" wrote: 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? |
#3
|
|||
|
|||
-----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 rest of the rows to shade, then right click, paste special, format only. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
shade rows | Excel Discussion (Misc queries) | |||
In Excel, can I shade entire rows based on the value of a single . | Excel Worksheet Functions | |||
Adding Rows to Master Sheet | New Users to Excel | |||
How do I shade alternate rows in Excel 2002? | Excel Discussion (Misc queries) |