Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ho do I make multiple line within a cell?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ho do I make multiple line within a cell?
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 --------------------------------------------------------------------------- 1| |____________| | 2| |____________| | 3| |____________| | 4| | | | ---------------------------------------------------------------------------- "Maria13" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ho do I make multiple line within a cell?
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. Maria13 wrote: 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? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell border is dotted line | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
make a cell empty based on condition | Charts and Charting in Excel |