Hotkey to apply formula to LAST valid cell in row or column

  • Thread starter Thread starter Gregory
  • Start date Start date
G

Gregory

After typing a formula in (let's say) Cell A3.. what are the hotkeys
to apply that formula to the LAST populated cell in the row? (or
column?) Is this a valid thing to attempt or ask? Again.. its often
difficult to drag the mouse over a LARGE range of cells.

-Gregory
 
To select from A3 to the last non-blank cell in row 3 hit CTRL + SHIFT + Right
Arrow.

The hit CTRL + d to fill across.

Same for down a column except use Down Arrow.

This will overwrite what you already have in that row or column.


Gord Dibben MS Excel MVP
 
Back
Top