Hi, everybody ,
Please tell me how to add multiple lines data in a single cell in MS Excel.
Thanks in advance,
Satya.d
P.S: Results must comes like drop down box
Harpreet
(* * * * * *)
(1670 Points)
Replied 19 July 2010
just select that single row (by pressing shift + space) in which u need multiple rows then press (ctrl & +) or simply insert rows as u required.
CA Prateek Garg
(CA in Practice)
(1447 Points)
Replied 24 July 2010
I think you want to insert a text string in a single cell in multiple lines .
1.for this select the cell.
2.open the cell format box (ctrl+1 or right click & select Format cell)
3.select alignment Tab
4.select wrap text
5.click OK
Ganesh
(Student)
(28 Points)
Replied 29 July 2010
Dear Satya,
R u asking how to enter data in paragraphs..?
If so its known as wrap texting. Right click the cell u want to apply the format, go to Format cells --> Alignment --> Check wrap text (Alt + w).
Alternatively while typing press alt + enter to come to the next line in the same sentence.
To bring down the box use alt + down arrow. In excel there is an option known as data validation in which entered data can be brought down like a boz. But in data validation excel won't allow any other data other than specfied data to be entered. If u want kow about that let me know.
I really admire this, I mean it really looks interesting! I'm actually glad to see all this stuff...
Satish Panchal
(CA)
(21 Points)
Replied 01 August 2010
You can enter Alt+enter at the end of first line to add a new line in the same cell
Rajesh
(Service )
(7576 Points)
Replied 02 August 2010
Dear Satya
I think you have some data in multiple cell and now you want to put all data in one cell, for this you can use the function 'CONCATENATE'
The CONCATENATE function joins up to 255 text strings into one text string. The joined items can be text, numbers, cell references, or a combination of those items. For example, if your worksheet contains a person's first name in cell A1 and the person's last name in cell B1, you can combine the two values in another cell by using the following formula:
=CONCATENATE(A1," ",B1)
Hope this will help you
Live Course on Invoice Management System (IMS) - 2nd Batch(With Recording)
CAclubindia
