Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Shaded Rows
I have a spreadsheet I am working on and its pretty long and pretty wide. Almost 200 lines. I was wondering if it is possible, in excel, to set it up such that every alternate row is shaded. I feel that this will help me when I am referencing the printout. thanlks -- bombayterror ------------------------------------------------------------------------ bombayterror's Profile: http://www.excelforum.com/member.php...o&userid=22855 View this thread: http://www.excelforum.com/showthread...hreadid=499071 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Shaded Rows
To highlight every other row, check out Row Striping at this website: http://www.xldynamic.com/source/xld.CF.html#rows Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=499071 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Shaded Rows
yup that does help.... thanks a lot buddy. Appreciate it :) -- bombayterror ------------------------------------------------------------------------ bombayterror's Profile: http://www.excelforum.com/member.php...o&userid=22855 View this thread: http://www.excelforum.com/showthread...hreadid=499071 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Shaded Rows
bombayterror wrote:
I have a spreadsheet I am working on and its pretty long and pretty wide. Almost 200 lines. I was wondering if it is possible, in excel, to set it up such that every alternate row is shaded. I feel that this will help me when I am referencing the printout. thanlks Looks like you already have a solution but here's a link to a freeware program I find very useful. http://www.asap-utilities.com/ It has many functions that can be done with just a couple of clicks. Shading every other line is as easy as clicking and selecting color and interval (every nth row). Standard disclaimer: not associated in any way, no renumeration yada yada gls858 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Shaded Rows
installed it. You are right there is a lot of stuff in there you can use. Seems like a pretty decent add-in thanks for the info -- bombayterror ------------------------------------------------------------------------ bombayterror's Profile: http://www.excelforum.com/member.php...o&userid=22855 View this thread: http://www.excelforum.com/showthread...hreadid=499071 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Shaded Rows
bombayterror wrote:
installed it. You are right there is a lot of stuff in there you can use. Seems like a pretty decent add-in thanks for the info No problem. Glad to help. Thanks for posting back. gls858 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
How to select only odd/even numbered rows to be shaded | Excel Discussion (Misc queries) | |||
formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel |