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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gregory - 23 Feb 2007 18:22 GMT

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

Reply to this Message

Gord Dibben - 23 Feb 2007 19:31 GMT

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

>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

Reply to this Message