Extend formula hotkeys?

J

Joe M.

I have data in column A for example going down 5000 rows. I have a formula in
B1. I would like to use a macro or some keystrokes to extend the formula down
to the last row where these is data in the adjacent column (in this case row
5000). I tried SHIFT + END + Down Arrow but that goes all the way to the lats
row of the sheet. Can anyone help?

Thanks,
Joe M.
 
N

Niek Otten

Hi Joe,

Double-click on the fill handle of B1. That is the little square in the bottom right corner.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have data in column A for example going down 5000 rows. I have a formula in
| B1. I would like to use a macro or some keystrokes to extend the formula down
| to the last row where these is data in the adjacent column (in this case row
| 5000). I tried SHIFT + END + Down Arrow but that goes all the way to the lats
| row of the sheet. Can anyone help?
|
| Thanks,
| Joe M.
 
N

Niek Otten

Hi Joe,

That should work, if all the rows contain data.
Another, slightly less convenient way:
Select A1. CTRL+downkey. Go one column to the right. SHIFT+CTRL+upkey. CTRL+D.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I did that, nothing happened. I'm using Excel 2003.
|
| "Niek Otten" wrote:
|
| > Hi Joe,
| >
| > Double-click on the fill handle of B1. That is the little square in the bottom right corner.
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > |I have data in column A for example going down 5000 rows. I have a formula in
| > | B1. I would like to use a macro or some keystrokes to extend the formula down
| > | to the last row where these is data in the adjacent column (in this case row
| > | 5000). I tried SHIFT + END + Down Arrow but that goes all the way to the lats
| > | row of the sheet. Can anyone help?
| > |
| > | Thanks,
| > | Joe M.
| >
| >
| >
 
G

Gord Dibben

Under Tools>Options>Edit do you have "Allow cell drag and drop" checked?


Gord Dibben MS Excel MVP
 

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

Macro to extend formulas 4
How can I copy a formula into a column but extend it by row 5
Need macro to move to first blank cell in column 6
Automatically Extend Formula in Count function with Additional Row 3
Extend formula row reference across columns 1
Inserting new rows, which contain the formula in the above the new 5
Extend Formula, but not Color 2
MACRO: Convert Row Formula to Value 1

Top