I know I can always count on my LR brethren to assist w/ the computer questions.
If I have a sheet and I want to highlight every other row, I know I can hold down CONTROL and click every other row. The problem is I have about 600 rows that I need to do this to. If there a command to highlight every other row on the sheet?
Thanks!
The VBA code posted by royUK in the link worked for me. If you don't know how to use this, just hit Alt+F11 to bring up the editor, then paste the code into the editor, and finally hit F5 to run the script. This should leave your alternating rows selected.
Kinda kludgy, but will work.
In the first column (A) number the first 600 rows 1-1199 using only odd numbers. You only have to type 1 - 3 - 5 in the first three rows and then use the drag feature to complete the set.
Highlight the first 600 rows in whatever color you want.
Number the next 600 rows 2 - 2000. Don't highlight.
Sort all rows by column A.
The result should be 600 highlighted rows between 1 - 1200.
Highlight either row 1 or 2. Then, while the entire row is selected (click on the row number), select Edit/Copy or type Ctrl-C. Select the cell A3, then press and hold Shift-End and type the down-arrow. This should select every cell from A3 down to the maximum number or rows available. Select Edit/Past or type Ctrl-V.