ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I alternate shading of rows, Excel 2007, no new tabs. (https://www.excelbanter.com/excel-discussion-misc-queries/233508-how-do-i-alternate-shading-rows-excel-2007-no-new-tabs.html)

jrgspyder

How do I alternate shading of rows, Excel 2007, no new tabs.
 
I am trying to alternate shading of rows in Excel 2007, without creating a
new row and changing the formatting. I am not interested in sorting the data
using this, only alternating the shading. I am able to do this with Excel
2003 on other computers but cannot figure it out in the newer version. Is
this possible?

Jacob Skaria

How do I alternate shading of rows, Excel 2007, no new tabs.
 
http://www.ozgrid.com/Excel/alternate-row-color.htm
--
If this post helps click Yes
---------------
Jacob Skaria


"jrgspyder" wrote:

I am trying to alternate shading of rows in Excel 2007, without creating a
new row and changing the formatting. I am not interested in sorting the data
using this, only alternating the shading. I am able to do this with Excel
2003 on other computers but cannot figure it out in the newer version. Is
this possible?



All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com