As @mathetes says you should try to be a lot clearer with an example in an actual sheet. But my guess is that you have a cell with multiple lines in it (i.e. using ALT-ENTER) and when you copy that cell to another location it will paste into multiple cells instead of a single cell with multiple lines like the original. 2 things to try would be: a) select the cell and copy the contents of the cell (e.g. hit F2 then ctrl-a then ctrl-c) then click on the destination and click IN the FORMULA BAR and press paste there b) select a range (e.g. include a blank cell next to it) and then paste it into the new location. If the original cell next to it wasn't empty then delete the added cell but if you have not space left,right,up,down at the destination then try a) above.