Thread: how do I shift the contents of the cells up to remove empty cells.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default how do I shift the contents of the cells up to remove empty cells.
F5SpecialBlanksOK

EditDeleteShift cell up.

May or may not be what you want.


Gord Dibben MS Excel MVP

On Tue, 10 Feb 2009 18:04:01 -0800, auctioncoach
wrote:

I have empty cells scattered throughout a row .
whenever I delete the contents of a cell it leaves it empty. I would like to
consolodate the information in the row so no empty cells are apparent

Reply With QuoteReply With Quote