How do you merge cells without losing data?



How do you merge cells without losing data?..

Answer / Tasleem Khan

You can merge cells in Excel while retaining the data by using the Merge Cells feature. Here's how:
1. Select the cells you want to merge.
2. Right-click and choose Format Cells > Alignment.
3. In the Alignment tab, under Horizontal, select Center Across Selection.
4. Go back to Home tab, click on Merge & Center button in the Alignment group.
5. A dialog box will appear asking if you're sure about merging the selected cells; click OK.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

What are the main parts of ms excel?

1 Answers  


What do u mean by append?

1 Answers  


How do I apply a formula in conditional formatting?

1 Answers  


What is difference between ms word and ms excel?

1 Answers  


How do you name a table in excel 2007?

1 Answers  


How do I change data validation in excel?

1 Answers  


What is trim formula in excel?

1 Answers  


What is full form of ref?

1 Answers  


What does consolidate mean in excel?

1 Answers  


How do I format tabs in excel 2013?

1 Answers  


Can you do pivot tables in excel?

1 Answers  


When I type a number, example 44, it becomes 0.44 even if I format the cell without decimals?

1 Answers  


Categories