close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()