Problem Wrapping Merged Cells in Excel 2013

Hey Guys,

I'm a newbie, so firstly thanks for any comments, whether they solve the problem or not. I am deeply appreciative of forums like this that help me as a technology illiterate .

Recently moved over a very big Microsoft Word document into Excel, a table that logs thousands of comic books with their title, issue number and warehouse location. We thought the document would be easier to edit if moved into Excel. However, we are having a huge problem trying to wrap all the cells as some will wrap and some will not. I understand from trawling through threads on various sites that this is probably due to merged cells, which for some reason (maybe a bug?) are completely ignored when wrapping the document. So those cells remain as one line with some of the text hidden.

As we are constantly updating this spread sheet and re-alphabetising with each new addition, manually adjusting the row height for each merged cell is impractical and not to say time consuming, as there are over 8000 rows of data. An automated solution is what we're looking for.

Assuming that this is the problem, I have gone through the document trying to find any merged cells and unmerge them, both by unmerging the whole document with the option on the Home tab, and through searching for merged cells with the Find & Replace option, doing it that way. I am now at the point where the Excel spread sheet says there are no merged cells to be found, and am at a loss to continue. I can only think that something must have happened on the Word side of things that did not translate into Excel correctly, but not in a way we can modify through Excel. It was a table in Word that was transferred over. I don't know, I'm grasping at straws here.

Can anyone offer any insight or, Spaghetti Monster be praised, a solution?

Let me know if you need anymore information to continue. As stated before I am a newbie so please carefully explain anything technical as if to a child, to be on the safe side.

Thanks again.

Hi and welcome to the forum

It's a bit hard to shoot blind on something like this Any chance of a sample of what you are working with?

(a quick tip to set all row heights in 1 go - click the top-left (above 1, left of A), then dbl-click on any of the "row lines")