Search Excel's help for "Features that are unavailable in shared workbooks"

You'll see a long list.

But Wrap text is not one of those formatting options that's affected by sharing
the workbook--but it is disabled if you protect the worksheet.

Roberta wrote:

Yes, it is shared. Is that why the Word Wrap and merge checkboxes were not
available?

"Dave Peterson" wrote:

Is the worksheet protected?
Is the workbook shared?



Roberta wrote:

Merge checkbox is also gray and un-clickable.

"Dave Peterson" wrote:

Depending on your selection, the merge checkbox can be:
checked -- all the cells are merged into one area
unchecked -- none of the cells are merged
grey check (or green box) -- some are merged, some are not (not one area).

If you want the copied data to go into one cell, then paste into the formula
bar.

Roberta wrote:

When I paste a selection from RoboHelp (a help-authoring program we have),
the text goes into multiple Excel cells. When I go to format for Word Wrap,
the Merge selection has a grayed-out check mark. Any ideas how to overcome
that?

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson