View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Fill colum to the next non blank row

You missed out step of typing the = sign in active blank cell before hitting
the up arrow.


Gord

On Thu, 15 Nov 2007 10:52:58 -0800, "Peo Sjoblom" wrote:

after select the blanks using F5 hit the up arrow key on your keyboard and
press ctrl + enter

will fill the blanks with whatever is in the cells above them