Friday, August 15, 2008

New Line and Multiple Paragraph in One Cell on Excel

In Excel, when you pasting text from other application like word, notepad, web browser or any application, the spreadsheet breaks multiple paragraphs into multiple cells. It means also you overwrite existing data under your target cell. To prevent this, simply press F2 or double click the cell the paste. All the text will remain in one cell.

Or, when you type in a cell, you want make new line/multiple paragraph in a cell? First, type the text for the first line/paragraph. To make the new line/paragraph press Alt + Enter. Continue type your next line/paragraph. You can use this trick instead of wrap text for manual breaking of a sentence.

New Line and Multiple Paragraph in One Cell on Excel

Comments :

4 comments to “New Line and Multiple Paragraph in One Cell on Excel”

Anonymous said...
on 

wah hebat euy..

Anonymous said...
on 

Di tunggu kreasi berikutnya.

Kamil Okrasa said...
on 

exactly...

Abdullah bin Abdullah ibn Abdullah said...
on 

thanks... all these days i tried on shfit+ enter... hehe... it never worked on excel...

 

Published by COMPUTER STUFF supported by DVD Writer USB