Solve this Problem with Excel

Asked By mona ali 0 points N/A Posted on - 11/03/2011

Hi experts ,

I am having trouble with my Excel file and here is the situation. I have placed in Column A,  list of names while I placed in Column B the details pertaining to those names.

What I need to know is if there is a way for me to enter all the details pertaining to each name without having the cells overlap with one another.

I hope you can help me with my problem?

Thank you.

• Status: Open
• Question Views: 932
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Microsoft Others

Best Answer by Sherin Viluel

Go To Solution

Answered By Mahesh Babu 20 points N/A #113661

Solve this Problem with Excel

Hallo Mona,

For sure there is a way that you can use to check and ensure that your excels files do not overlap. With the excel document open, point the cursor to the line that separates the two columns at the top where you see letters.

The cursor should change to a plus (+) sign. Using your mouse or the keyboard mouse pad, left click to hold the line and then drag it to the right so as to expand those particular cells.

Do that for all the columns that overlap to expand them.

Regards,

Mahesh Babu

About Mahesh Babu

Questions
1

Answers
473

Best Answers
87

• Vote Up 0 Vote Down

• Posted on - 11/03/2011
• Question Category: Microsoft Others

Best Answer

Best Answer

Answered By Sherin Viluel 0 points N/A #113662

Solve this Problem with Excel

 

According to your requirement you want to have all the names in Column A and the details pertaining to each name should be in column B. I think the problem that you have is, if you type more details in a cell in column B whether it will overlap the other cells.

First type all the details in a one cell in column B which is pertaining to them name in column A.

Please see the image below.

In the above image details of the Cell B3 seems to be overlap the other Cells (Cell C3, D3, E3, F3, G3, H3)

In order to avoid the above issue you can use “wrap text” option.

Click on the entire Column B and click on the wrap text option in alignment tab.

Now you can adjust the row (Step 1) and the column(step 2) as to details is properly shown.

About Sherin Viluel

Questions
0

Answers
50

Best Answers
37

• Vote Up 0 Vote Down

• Posted on - 06/19/2012
• Question Category: Microsoft Others