Not displaying text across other fields?

[Dan Morris]

Hi there

I'm using an Excel spreadsheet as a database (mostly text based), so that in columns 1 and 2 are names and in column 3 is notes. I'm keeping all the columns single height (ie: not wrapping text). Where there is nothing in column 4 onwards, the text from column 3 displays across the subsequent blank fields. I would rather it didn't do this. I can't find an option for this and I've tried looking for a previous answer on the same thing but couldn't find one. I'm sure there must be an option for this, if anyone could point it out...?

Thank you very much.

Dan

 

[Weazel]

you could try selecting column 4, then hit the space bar once, then hit CTRL + ENTER.
This will enter a 'space' in each of the cells in that column and keep the text from going over.
I'm trying to think of a better way to do it but this seems to work

 

[Dan Morris]

Thank you Weazel; if you think of any other ways do let me know