Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HOW TO SELECT EVERY OTHER LINE IN A WORKBOOK AUTOMATICALLY
I need to select every other row to highlight them. If there is a way to do it
more quickly than holding down the control key and selecting every other line that would be very helpful |
#2
|
|||
|
|||
Try conditional formatting. Select the entire range to be affected (all rows,
not just alternate rows), then Format/Conditional and select Formula Is in the first box and type =MOD(ROW(),2)=0 and set the format for the shaded rows. That will do even numbered rows. If you want odd numbered, change the final 0 to 1. On Wed, 5 Oct 2005 13:54:06 -0700, Rachel wrote: I need to select every other row to highlight them. If there is a way to do it more quickly than holding down the control key and selecting every other line that would be very helpful |
#3
|
|||
|
|||
Hi,
Use Conditional Formatting. Select the first (topmost) row you want to highlight; "Format" (in the Toolbar) -- "Conditional Formatting" -- select "Formula Is" and in the formula bar enter =MOD(ROW(),2)=0 (if that row is an even-numbered row), or =MOD(ROW(),2)=1 (if that row is an odd-numbered row) Click the "Format" button, and select "Patterns" and select the shading color, Click "OK". Now fill-in the formula in the rows below. Regards, B. R. Ramachandran "Rachel" wrote: I need to select every other row to highlight them. If there is a way to do it more quickly than holding down the control key and selecting every other line that would be very helpful |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
Use Sheet CodeNames to Select Sheet in Different Workbook | Excel Discussion (Misc queries) | |||
Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
workbook select | Excel Discussion (Misc queries) | |||
select workbook macro | Excel Discussion (Misc queries) |