How To Insert A Line Break 

In most of the programs you have to click Enter Key to move the cursor to the next line .But in Excel  if you press enter then the cursor will jump to the next cell .But if we want not to go to the next cell ,but in the same cell & want to type something in the next line 

Then Press ALT+ENTER 

Note :While using formulas pls use char(10) instead of ALT+ENTER

No comments:

Post a Comment