If you want to appear multiple lines or lines break in one Excel Cell, You can use excel Wrap Text or Lines Break option.

For Lines Break:-
First type some words in one cell then press Alt+Enter to start a new line in same cell.

For Wrap Text :-
1) In under mentioned picture, Basic Salary can't view properly. Now you can use Wrap Text freature to rearrenge this text.

2) Right Click on Basic Salary cell & click on Format Cell tab

3) Click on "ALIGNMENT" and then click on "WARP TEXT" menu.

4) You can view the differnce. Now you should try for Yearly Salary text.

Stay Connected With Free Updates

Subscribe via Email
You can leave a response, or trackback from your own site.

Pijush Roy, Founder & Author of "Share Your Knowledge", is a young freelance blogger, a reader, a painter, .....read more