Any excel gurus in here?

[FlirtatiousBrat]

is there a way to shade every other row w/out me having to click each one and fix it?

[ColleenSwerb]

In short, no.

But you can make is slightly easier. If you hover your mouse on the left by the row numbers, it'll turn into an arrow. Click on it, and it'll highlight the whole row, on to infinity. If you hold control you shoul dbe able to select multiple rows, then use the fill feature and fill them all with the same color. Make sense?

[FlirtatiousBrat]

yeah that's how i was doing it....it's ok for now but i'm lazy :P once there's 150+ names it gets old

[cheltzey]

What she said...:)

[ColleenSwerb]

Suck it up hooker (happy Sara??). It's better than that damn word document now isn't it?

[meems]

isn't there some sort of format option that you can use?

i don't have Excel on my laptop . . . will check desktop later

[Leila]

Actually, there is. It's under Format--->Tables. I no longer have Excel (switched to Open Office), but I'm pretty sure that if you select the area, you can then go into Format--->Tables and choose one of the options there,

[FlirtatiousBrat]

ok thanks I'll try it

[Leila]

Ok, but if it doesn't work...it's my husband's fault. He told me that's how to do it and then decided, after my post went through, that he should double check the information. Dweeb.

[KristinCB]

I'll be whatever kind of guru you want me to be miss meg ;)

[Stacey42]

Excel doesn't have tables, Word does, but your DH is right about how to do it. :)

Unfortunately the only way to shade rows in Excel is what you are already doing.

[FlirtatiousBrat]

ty came back to say there's no table under my thing..lol

[Leila]

Last time I used Excel, it had tables. DH just checked his copy of Excel (2007), it offers tables.

http://office.microsoft.com/en-us/excel/HA100485461033.aspx

[FlirtatiousBrat]

ok it's called "list" in my version (I still have 2003)

oh well I'll have to play again later. I just selected each one for now

[scrapmonkey]

There is a way to do it. Go to your spreadsheet and highlight the whole thing. Then got to Format, select Auto Format, and then List 1 - it will highlight your Header Line and then every other line.

No, I'm not a finance geek (she says sarcastically)

[AmyM]

I've been to at least 3 excel workshops and I hated every one of them and still can't figure everything out. I think I'd rather do calculus than deal with excel- I hate that program. Don't know why, we just don't get along. LOL Good luck Meg!

[meems]

There is a way to do it. Go to your spreadsheet and highlight the whole thing. Then got to Format, select Auto Format, and then List 1 - it will highlight your Header Line and then every other line.

No, I'm not a finance geek
yep, this is what I was thinking

[FlirtatiousBrat]

There is a way to do it. Go to your spreadsheet and highlight the whole thing. Then got to Format, select Auto Format, and then List 1 - it will highlight your Header Line and then every other line.

No, I'm not a finance geek

ty that worked...anyway to make them specific colors? haha..i think i'll play around w/it tomorrow

[BeccaBoo]

You can change the colors of the table with the Table Styles under the Design tab. If you select the table it will pull up a Table Tools section with Design under it. Click that and you will see Table Styles which has various colors etc.

This is in Excel 2007.

[supertwinkle]

Wow, I'm really impressed with the depth of Excel knowledge here... I AM a finance geek and I didn't know about this!

[Leila]

I was lucky enough to get to take a six month course in Excel when I went to school to become an administrative assistant. Six months of Excel, Word, and Access. Another three months of Word Perfect...fun times. Fun times.

[BeccaBoo]

I am in school know. Took an excel class last semester and in one now. Unfortunately, I know more than I would like about excel.

[ColleenSwerb]

It's funny, because I created a spreadsheet that designs a retaining wall. Literally.

But I didn't know how to make it easier to highlight rows. *forehead slap*

[meems]

It's funny, because I created a spreadsheet that designs a retaining wall. Literally.

But I didn't know how to make it easier to highlight rows. *forehead slap*
that's okay. we don't know how to design a retaining wall

[SamaraGugler]

I need to complete some professional development and yesterday I was looking at classes that were offered. I ALMOST signed up for the Excel class but decided on "The Geology of Southern California".

fun times...fun times!!!!

[supertwinkle]

I know how to put together a multi-million dollar budget in Excel for work, but I don't know how to highlight multiple rows at once, and I don't know how to design a retaining wall. :D

[Stacey42]

I can create a Pivot Table.....

I'm running Excel 2000, though I could have sworn I upgraded to 2003.

[scrapmonkey]

Pivot tables are my friends. I use them ALL the time. Let's just say, I love to do macros and use functions. I even asked my boss if I could take Visual Basic so I could program Excel and do more complex macros. He said no... :(
I am such a geek.