Paste Issues- HELP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Have you tried to click the check box? Try it regardless how it looks, you
might have to click twice


--


Regards,


Peo Sjoblom
 
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.
 
Merge checkbox is also gray and un-clickable.

Dave Peterson said:
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.
Click to expand...
 
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.
Yes, it is shared. Is that why the Word Wrap and merge checkboxes were not
available?
Click to expand...
 
Back
Top