Shaded Rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bombayterror - 07 Jan 2006 21:57 GMT

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

Signature

bombayterror

Reply to this Message

Ron Coderre - 07 Jan 2006 22:12 GMT

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

Signature

Ron Coderre

Reply to this Message

bombayterror - 07 Jan 2006 22:27 GMT

yup that does help....

thanks a lot buddy. Appreciate it :)

Signature

bombayterror

Reply to this Message

gls858 - 09 Jan 2006 23:09 GMT

> 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
[quoted text clipped - 3 lines]
>
> 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

Reply to this Message

bombayterror - 09 Jan 2006 23:42 GMT

installed it. You are right there is a lot of stuff in there you ca
use. Seems like a pretty decent add-in

thanks for the inf

Reply to this Message

gls858 - 12 Jan 2006 15:43 GMT

> 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 to this Message