Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
assigning hotkeys | Excel Discussion (Misc queries) | |||
Extend Formula | Excel Discussion (Misc queries) | |||
extend on an index formula I already have | Excel Worksheet Functions | |||
insert certain terms via hotkeys | New Users to Excel | |||
Disable Hotkeys | Excel Discussion (Misc queries) |