View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default is it only appropriate to insert *different* data into *individual*cells...

You can do whatever is appropriate.

But if you separate fields into different columns, your life will be much, much
simpler if you ever want to do anything with that data (besides printing).

For instance, if you wanted to add the values in column B, you could use:
=sum(b2:B99)

It would become a very ugly formula if you kept everything in column A.

showsomeidnow wrote:

... like this i mean

column A column B
apple £1.20
banana £1.30
pear £2.25

or is this 'acceptable' also?

column A
apple £1.20
banana £1.30
etc


--

Dave Peterson