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
|
|||
|
|||
Hi Manny
you can use conditional formatting for this, select the rows (using the row numbers) of your data area and choose format / conditional formatting choose formula is and type =MOD(ROW()-1,2)+1<=1 click the format button, go to the patterns tab, choose a colour and click OK twice this will format all ODD rows to the chosen background Cheers JulieD "Manny" wrote in 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? |
#3
|
|||
|
|||
See http://www.xldynamic.com/source/xld.CF.html#rows
-- HTH RP (remove nothere from the email address if mailing direct) "Manny" wrote in 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
In Excel, can I shade entire rows based on the value of a single . | Excel Worksheet Functions | |||
Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel | |||
How do I shade alternate rows in Excel 2002? | Excel Discussion (Misc queries) |