huge amount of text in merge cell - want undone!

R

rose

I am working with an excel spreadsheet. The creator has merged cells and
formatted them so that a large quantity of text appears on screen in one
worksheet.

As you might imagine, whenever I am in the worksheet, the formula bar
displays such a huge text that not only is it distracting but unless I am
lucky enough to find a cell with only a small amount of information in it, or
a blank cell to click on. Its overwhelming and I want it gone.

Can anyone tell me how to reformat it? I thought about creating a macro
that would pull up a document but... ? Would a text box work - I haven't
had time to play with it.

Appreciate your time and thoughts



Can someone suggest a way for the information to appear without this issue?
 
D

dominicb

Good evening Rose

Highlight the offending range and press ctrl + 1, Alignment. You will
probably see that the merged cell tick box has a tick in it but is
grey, to indicate that the selected range has different merge
properties. Click the box until the box is clear and select OK. This
will un-merge the whole range quickly and you will be able to see
whether this has any adverse effects on the worksheet. If the result
is too bad to contemplate, just click on undo and try something else.

HTH

DominicB
 
R

rose

Thanks, and yes it was merged and wrapped, but undoing it only makes it
unreadable (forces it in one cell). It was merged across and then the row
size was increased to fit the content. The whole spreadsheet is like this in
parts and pieces.

I think a text box would work but I am looking for a more sophistated answer
than that, if there even is one.

BTW, thanks for the shortcut, one I didn't use often enough to remember!
 
R

rose

I know I'm talking to myself, can someone tell me if this sounds more like it?
I have embedded a word file with the contents of the afformentioned merged
cell contents (a large amount of data, I might add).

Will this cause any issues if its uploaded to a network? The spreadsheet
functions and macros's otherwise are really well done, I don't want to try to
recreate it.

Thanks for your input
 
M

Myrna Larson

You could put this text into a Text Box instead of in cells. If you want it in
cells, you could put it into one or more cells, then use Edit/Fill/Justify to
spread it out over multiple cells. Check out the latter in Help.
 
Top