Excel Line Breaks

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


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