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? |
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? |
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 |
All times are GMT +1. The time now is 12:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com