View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default How do you make Data move into another cell??

Why not just use Insert? It will push the cells over. Just right-click on
the cell, choose Insert... then choose Shift cells right (or down). You're
always better off using Excel the way it was designed.

Regards,
Fred

"Kyrie" wrote in message
...
I need some help as i have been looking everywhere and cannot find a
sloution.
My boss would like to have a spreadsheet full of lots of different
numbers
but when you start to write over the top, the data from the cell moves in
to
the cell next to it. So it will be almost like pushing all the numbers
into
the cell next to it without inserting an extra row or column.
I hope this makes sense and any help would be greatly appreciated