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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Looking for the value that indicates last row number that has filled cells 3
select to last row in formula 2
Re : Excel Data>Sort... Tracking of Cell Addresses Used in Formulae 1
Last entry in a column 6
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Figuring out a lengthy formula. Probably quite simple... 3

Back
Top