Thread: how do I shift the contents of the cells up to remove empty cells.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
auctioncoach auctioncoach is offline
external usenet poster
  
Posts: 1
Default how do I shift the contents of the cells up to remove empty cells.
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