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: www.excelforum.com/member.php...oamp;userid=22855
View this thread: www.excelforum.com/showthread...hreadid=499071
To highlight every other row, check out Row Striping at this website:
www.xldynamic.com/source/xld.CF.html#rows
Does that help?Regards,
Ron--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=499071
yup that does help....
thanks a lot buddy. Appreciate it --
bombayterror
------------------------------------------------------------------------
bombayterror's Profile: www.excelforum.com/member.php...oamp;userid=22855
View this thread: www.excelforum.com/showthread...hreadid=499071bombayterror wrote:
gt; I have a spreadsheet I am working on and its pretty long and pretty
gt; wide. Almost 200 lines. I was wondering if it is possible, in excel, to
gt; set it up such that every alternate row is shaded.
gt;
gt; I feel that this will help me when I am referencing the printout.
gt;
gt; thanlks
gt;
gt;
Looks like you already have a solution but here's a link to a
freeware program I find very useful.
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
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: www.excelforum.com/member.php...oamp;userid=22855
View this thread: www.excelforum.com/showthread...hreadid=499071bombayterror wrote:
gt; installed it. You are right there is a lot of stuff in there you can
gt; use. Seems like a pretty decent add-in
gt;
gt; thanks for the info
gt;
gt;
No problem. Glad to help. Thanks for posting back.
gls858
- Jun 04 Wed 2008 20:44
Shaded Rows
close
全站熱搜
留言列表
發表留言