FG
💻 Software

Click to select row to end of data in Excel?

Fresh5 days ago
Mar 15, 202686750 views
Confidence Score0%
0%

Problem

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 ad…

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Click to select row to end of data in Excel?

Low Risk

No, there is no easy way of selecting multiple non-continuous rows without selecting the entire row of each. You would need to do each row independently. Using Just the Keyboard If your rows contain consecutive cells with data, you can click the fir…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment