General question regarding tabel list etc

[ipbr21054]

Morning,
I have a list in the form of a table.
I noticed that say the first 12 cells are blue white blue white etc etc but then after that all the other cells are white.

Can you explain why this is & what should i need to do if anything.

Thanks

 

[My Aswer Is This]

You probably skipped a row.

 

[ipbr21054]

Hi,
Checking the rows in question they all seem to be in order like1,2,3,4,5,6 etc etc as opposed to 1,2,3,5,6 if thats what you mean by skipped a row.

Having said that i selected the cells in question then selected NO FILL then i now see ALL the cells are blue white blue white.

Thanks

 

[My Aswer Is This]

The table does not continue if you skip rows.
Skipping rows like entering a value in row 2 and then row 5 is skipping a row.

 

[ipbr21054]

OK
All cells have a value in them,now they all are blue white etc all the way down

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

 

[ipbr21054]

Thanks.
You allways seem to help me out even on a saturday.

Cheers

 

[My Aswer Is This]

Want to make your Table a different color?

1.Select the entire Table
2. You now should see On the Ribbon Table Tools select Design
3. See table styles
4. Select one from the choices seen.
5. There are more then 30 choices.

 

[ipbr21054]

Thanks,i will take a look.