Re: columns locked together

[Jody Goldberg <jody gnome org>]

On Fri, Feb 08, 2002 at 11:51:56AM -0800, Gregory Margo wrote:
> I've gotten my tax spreadsheet into a funny state - some of the
> columns cannot be individually selected, and several columns select as one.
> For instance, column A is single, but selecting any of columns B-E
> cause all four columns to be selected.
> The actual groupings I see are: A-(B-C-D-E)-F-(G-H-I-J)-K
>
> How can I get the columns split back up again?
> (And how did I manage to get them locked together in the first place?)

You probably merged some cells.  Gnumeric does not permit you to
select part of a cell.  Hence once a cell is merged to include more
than 1 column you can no longer select those columns individually.
This is different from XL, but seemed more consistent.  The easy
answer is to select one of the 'locked' regions and hit 'unmerge' on
the toolbar.  That will unmerge anything in that region and you'll
be free to select single columns again.

Hope that helps,
    Jody