Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I have a very long department phone list which I print & post near my phone. I'd like an easy way to highlight every-other row to make it easier on the eyes. Currently I insert a column to the left of the table. Using the numbers 1 & 2, I alternately number every-other row all the way down the table. Then I filter the 1's and highlight them. Next, I remove the filter & every-other line is highlighted. Is there a more simple or automatic way to do this? (When data is added in the chart I have to adjust all the numbers) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Color alternate rows when after hiding selected rows | Excel Worksheet Functions | |||
sum alternate rows | Excel Worksheet Functions | |||
How to calculate the sum of the alternate rows? | Excel Worksheet Functions | |||
Add alternate rows | Excel Worksheet Functions | |||
How to sum-up alternate rows ? | Excel Worksheet Functions |