In Excel, you can select an entire row by clicking its number at the left edge of the window. But doing so selects the entire row all the way to infinity. If you apply a fill color to a row selected in this way, the fill color also extends infinitely.
I need to select multiple rows which are not adjacent -- for example, rows 4, 6, 14, and 27 -- and so clicking and dragging a box won't help.
So, is there some easy way to select JUST to the end of columns containing data?