If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Auto Fill-Down?
I have a sheet with about 20 records. One column is for Company. However the
way the data was compiled only the first record has a value for company and then there is no value again until the new company e.g Name | Company Jones | Acme Smith | Nadel | Catn | WidgetInc Mazuk | Barny | Jones | GNC Walen | Smith | CenterFilms Balboa | So far I've been doing keystroke combos to select next, select all down to next, back up one, fill down. This takes a long time and is prone to error. Is there some command/macro that would do this for me automatically? |
#2
|
|||
|
|||
Auto Fill-Down?
Hi,
Select the cells in the column, starting in the row below the column heading. Choose Edit | Go To Click the Special button Select Blanks, click OK Type an equal sign Press the up arrow on the keyboard -- this will enter a reference to the cell above -- cell A2 in this example Hold the Ctrl key and press Enter -- this enters the formula in all selected cells "msnyc07" wrote: I have a sheet with about 20 records. One column is for Company. However the way the data was compiled only the first record has a value for company and then there is no value again until the new company e.g Name | Company Jones | Acme Smith | Nadel | Catn | WidgetInc Mazuk | Barny | Jones | GNC Walen | Smith | CenterFilms Balboa | So far I've been doing keystroke combos to select next, select all down to next, back up one, fill down. This takes a long time and is prone to error. Is there some command/macro that would do this for me automatically? |
#3
|
|||
|
|||
Auto Fill-Down?
Dude, you ROCK! Saved me days. Thank you!
"Eduardo" wrote: Hi, Select the cells in the column, starting in the row below the column heading. Choose Edit | Go To Click the Special button Select Blanks, click OK Type an equal sign Press the up arrow on the keyboard -- this will enter a reference to the cell above -- cell A2 in this example Hold the Ctrl key and press Enter -- this enters the formula in all selected cells "msnyc07" wrote: I have a sheet with about 20 records. One column is for Company. However the way the data was compiled only the first record has a value for company and then there is no value again until the new company e.g Name | Company Jones | Acme Smith | Nadel | Catn | WidgetInc Mazuk | Barny | Jones | GNC Walen | Smith | CenterFilms Balboa | So far I've been doing keystroke combos to select next, select all down to next, back up one, fill down. This takes a long time and is prone to error. Is there some command/macro that would do this for me automatically? |
Thread Tools | |
Display Modes | |
|
|