Thread: How to fill cell with data from a previous cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How to fill cell with data from a previous cell
Select the column then F5SpecialBlanksOK

Type an = sign in active blank cell.

Point or arrow to cell above.

Hit CTRL + ENTER.

Copy the column then Paste SpecialValuesOKEsc.


Gord Dibben MS Excel MVP

On Mon, 19 Oct 2009 02:12:07 -0700, Ishi Elpitiya wrote:

How to fill cell with data from a previous cell till meet next cell with data in a same column in Excel

EggHeadCafe - Software Developer Portal of Choice
Scriptless ASP Progress Indicator
http://www.eggheadcafe.com/tutorials...rogress-i.aspx

Reply With QuoteReply With Quote