Recently we have upgraded to Office 2007. I have data that I import into
Excel from another program. This program imports with some blank cells in
which I would always do a ctrl+shift+8 (to select the data area) and then go
to edit - go to- special - blanks and hit ok. This would then highlight all
my blank cells. I would then hit the down arrow and enter and it would fill
all of my blank cells with the data below. The problem I am having in Office
2007 is that after I use the go to special and select blanks, it selects all
of my blank cells, but as soon as I hit the down arrow, the selection goes
away. Can anyone assist ?

Hi,
Position in the first blank cell, hit CTRL G, special, Blank cells, then
press the up arrow on the keyboard, Hold the CTRL key and press Enter

"Michele" wrote:

Recently we have upgraded to Office 2007. I have data that I import into
Excel from another program. This program imports with some blank cells in
which I would always do a ctrl+shift+8 (to select the data area) and then go
to edit - go to- special - blanks and hit ok. This would then highlight all
my blank cells. I would then hit the down arrow and enter and it would fill
all of my blank cells with the data below. The problem I am having in Office
2007 is that after I use the go to special and select blanks, it selects all
of my blank cells, but as soon as I hit the down arrow, the selection goes
away. Can anyone assist ?

That is what I have been trying, but as soon as I hit the arrow key, my cell
selections go away as if I am aborting the action. So, when I press CTRL
enter nothing happens.

"Eduardo" wrote:

Hi,
Position in the first blank cell, hit CTRL G, special, Blank cells, then
press the up arrow on the keyboard, Hold the CTRL key and press Enter

"Michele" wrote:

Recently we have upgraded to Office 2007. I have data that I import into
Excel from another program. This program imports with some blank cells in
which I would always do a ctrl+shift+8 (to select the data area) and then go
to edit - go to- special - blanks and hit ok. This would then highlight all
my blank cells. I would then hit the down arrow and enter and it would fill
all of my blank cells with the data below. The problem I am having in Office
2007 is that after I use the go to special and select blanks, it selects all
of my blank cells, but as soon as I hit the down arrow, the selection goes
away. Can anyone assist ?

Hi Michele,
sorry I forgot something,
once you selected the blank cells and click OK, tipe an = signal and then
hit the arrow

"Michele" wrote:

That is what I have been trying, but as soon as I hit the arrow key, my cell
selections go away as if I am aborting the action. So, when I press CTRL
enter nothing happens.

"Eduardo" wrote:

Hi,
Position in the first blank cell, hit CTRL G, special, Blank cells, then
press the up arrow on the keyboard, Hold the CTRL key and press Enter

"Michele" wrote:

Recently we have upgraded to Office 2007. I have data that I import into
Excel from another program. This program imports with some blank cells in
which I would always do a ctrl+shift+8 (to select the data area) and then go
to edit - go to- special - blanks and hit ok. This would then highlight all
my blank cells. I would then hit the down arrow and enter and it would fill
all of my blank cells with the data below. The problem I am having in Office
2007 is that after I use the go to special and select blanks, it selects all
of my blank cells, but as soon as I hit the down arrow, the selection goes
away. Can anyone assist ?

Perfect. That is what I was forgetting. Thank you soooo much.

"Eduardo" wrote:

Hi Michele,
sorry I forgot something,
once you selected the blank cells and click OK, tipe an = signal and then
hit the arrow

"Michele" wrote:

That is what I have been trying, but as soon as I hit the arrow key, my cell
selections go away as if I am aborting the action. So, when I press CTRL
enter nothing happens.

"Eduardo" wrote:

Hi,
Position in the first blank cell, hit CTRL G, special, Blank cells, then
press the up arrow on the keyboard, Hold the CTRL key and press Enter

"Michele" wrote:

Recently we have upgraded to Office 2007. I have data that I import into
Excel from another program. This program imports with some blank cells in
which I would always do a ctrl+shift+8 (to select the data area) and then go
to edit - go to- special - blanks and hit ok. This would then highlight all
my blank cells. I would then hit the down arrow and enter and it would fill
all of my blank cells with the data below. The problem I am having in Office
2007 is that after I use the go to special and select blanks, it selects all
of my blank cells, but as soon as I hit the down arrow, the selection goes
away. Can anyone assist ?

your welcome, thank you for the feedback

"Michele" wrote:

Perfect. That is what I was forgetting. Thank you soooo much.

"Eduardo" wrote:

Hi Michele,
sorry I forgot something,
once you selected the blank cells and click OK, tipe an = signal and then
hit the arrow

"Michele" wrote:

That is what I have been trying, but as soon as I hit the arrow key, my cell
selections go away as if I am aborting the action. So, when I press CTRL
enter nothing happens.

"Eduardo" wrote:

Hi,
Position in the first blank cell, hit CTRL G, special, Blank cells, then
press the up arrow on the keyboard, Hold the CTRL key and press Enter

"Michele" wrote:

Recently we have upgraded to Office 2007. I have data that I import into
Excel from another program. This program imports with some blank cells in
which I would always do a ctrl+shift+8 (to select the data area) and then go
to edit - go to- special - blanks and hit ok. This would then highlight all
my blank cells. I would then hit the down arrow and enter and it would fill
all of my blank cells with the data below. The problem I am having in Office
2007 is that after I use the go to special and select blanks, it selects all
of my blank cells, but as soon as I hit the down arrow, the selection goes
away. Can anyone assist ?