Ho do I make multiple line within a cell?

M

Maria13

I have a spreadsheet that I am working on where all the feilds are single
entry items except for 1 column where I will need to place in separate
fields, an amount, deduction and then sum the two. Then below I will need to
take each of those separate feilds and sum them. Is this at all possilbe in
Excel? And if so? HOW?
 
J

JLatham

Not easily within a single cell - what you'd end up with is a textual
representation of the numbers, and not numbers you could use individually for
anything else.

Try thinking laterally rather than vertically - instead of summing below
numbers, put the sum in another column further to the right. It doesn't look
as neat, but if you have to reference it later it will be easier.

The other option is to just use 3 (or 4) rows for each entry, you'll just
have a lot of empty cells in the unused columns.

One final option, which would look nice but has some other problems to deal
with later on is to MERGE the cells in each of the columns where only one
item of data is needed and not merge them in the column where you need the
math. You'd have a row that looks something like this:

A B C D
 
D

Dave Peterson

Don't do it!

Put your data in separate cells--insert an additional column if you must, but
your life will be much easier if you don't do this kind of stuff.
 
Top