Is there a way to color every other line?

[Pitch]

I'm wondering if there's a way to color every other line with a slight
grey color, using Normal view, in such a way that even if you Sort the
data on those lines, the grey banding still remains where they are. I
want to do this to produce an more readable document.

I've manually done this this alternative color banding, but whenever I
re-sort the data, the colors get all messed up.

 

[JE McGimpsey]

I'm wondering if there's a way to color every other line with a slight
grey color, using Normal view, in such a way that even if you Sort the
data on those lines, the grey banding still remains where they are. I
want to do this to produce an more readable document.

I've manually done this this alternative color banding, but whenever I
re-sort the data, the colors get all messed up.

Take a look here:

http://cpearson.com/excel/banding.htm

 

[Guy Kudlemyer]

Easier still is to go to the Mac OS Downloads page on the Apple website and
download Excel Expander. I've used that feature extensively with great
success.

--Guy
Thurston, OR

 

[Norman R. Nager, Ph.D.]

Please include a url for the page. I just did an advanced search of
downloads from Apple.com/support/downloads for Excel Expander but it could
find nothing.

Respectfully, Norm

 

[Tom Stiller]

Please include a url for the page. I just did an advanced search of
downloads from Apple.com/support/downloads for Excel Expander but it could
find nothing.

Google is your friend.

 

[Guy Kudlemyer]

Please include a url for the page. I just did an advanced search of

downloads from Apple.com/support/downloads for Excel Expander but it could
find nothing.

Respectfully, Norm

Norm:

http://www.apple.com/downloads/macosx/business_finance/macexcelexpander.html

I'll admit that I haven't had much success getting the menu to load
automatically. And emails to the author were less than helpful, as there
seems to be a language barrier (I speak English.) However, I realized that I
didn't necessarily NEED Excel Expander to load each time I started Excel. So
I simply load it when I need it (I keep the icon in the dock).

I do a lot of color banding of rows, and have found this to be extremely
helpful--just make a selection of rows, invoke the command from the menu
(it's the third command from the top), choose a color, and VOILA!

If you want to remove all the banding, simply make a selection and choose
"No Fill" from Excel's Formatting Toolbar.

Hope this helps!

--Guy
Thurston, OR

 

[jpdphd]

The disadvantage of using Excel Expander is that when you sort, the
bands stay attached to the original rows. In the Pearson method,
banding is independent of sorting.

jpdphd

 

[Jim Gordon MVP]

Hi Pitch,

I've noticed several people ask this question lately so I took MVP Chip
Pearson's formula and made what I hope is a useful step-by-step guide
specifically for Mac Excel 2004.

Here's the link to the file download (it's a PowerPoint presentation):
http://www.agentjim.com/MVP/Excel/Excel shade every other row.ppt

-Jim Gordon
Mac MVP

I'm wondering if there's a way to color every other line with a slight
grey color, using Normal view, in such a way that even if you Sort the
data on those lines, the grey banding still remains where they are. I
want to do this to produce an more readable document.

I've manually done this this alternative color banding, but whenever I
re-sort the data, the colors get all messed up.

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info