Paste value between hidden cells

[GG456]

Hi There,

I have 5 empty cells between two filtered cells and i would like to copy the first cell and to paste in the couple of empty cells via i i am still in filtered condition. Appreciate if some one can guide me how to do it. I am asking this because i have lot of this type of empty cells between many filtered cells. I am wondering if there is a quick way to do it instead of copy and paste everytime. thanks

 

[DILIPandey]

Hi GG456,

Do you want to copy paste the above cell's value in each blank cell ?
Or you want to copy a cell which should be pasted in each non-visible blank cell in that column or selected range ?

Regards,
DILIPandey

 

[GG456]

Hi GG456,

Do you want to copy paste the above cell's value in each blank cell ?
Or you want to copy a cell which should be pasted in each non-visible blank cell in that column or selected range ?

Regards,
DILIPandey

HiThere,

I want to copy paste the above cell's value in each blank cel (or auto fill should there every empty cell below the filtered cell has the same value). I knew that i can manual to copy and paste, but wondering if there is any quick and fast way. thanks

 

[DILIPandey]

Okay... Lets test this out.

Select a small range having blank cells and filled cells- both,
Press F5, Alt +s, k, press enter
type =, press up arrow, Ctrl + Enter

Now all blank cells should have the value which is there in above cell.

Regards,
DILIPandey

 

[GG456]

Okay... Lets test this out.

Select a small range having blank cells and filled cells- both,
Press F5, Alt +s, k, press enter
type =, press up arrow, Ctrl + Enter

Now all blank cells should have the value which is there in above cell.

Regards,
DILIPandey

Many thanks

 

[DILIPandey]

You are welcome...!!


Regards,
DILIPandey