Question: I am using Excel 2007 for my sales numbers; I sometimes enter a lot of sales numbers in an Excel cell. The problem I face is that when I enter more data into a cell the original data is hidden. Is there a way to avoid the original numbers being hidden?
Answer: Yes, using line breaks in each Excel spreadsheet cell
How:
1. Click on a cell and type the first line of data. Then, press Alt+Enter
2. Now, type the second line of data, followed by pressing Alt+Enter when you are done
3. For every subsequent line of data added, press Alt+Enter at the end
4. When you’re finished, press Enter
This handy Excel keystroke function forces line breaks in each spreadsheet cell, thereby eliminating the problem of covered-up original data
