G
Gil
I've got a spreadsheet which has a section (A24:J42) that has six columns.
Columns B-F have been merged in this data section, but not so in A1:J23. When
I try sorting the data section I am only presented with columns (as a whole)
to sort. Obviously, I'm getting the message "merged cells must be identical
size".
I've looked through past postings about this, and done some Internet
searching, and the best I can find is how to unmerge the merged cells and the
sort will work.
Yup! It works just fine, but the problem is my data section in columns B-F
contain data only in column B. When I go to merge those cells, the only way
to do it is by individual rows.
While I only have a few rows in this worksheet, it only takes a minute or
so, but it isn't being done in one action. What if this table grows and I
have several hundred rows in this data section. Actions of unmerging and
sorting are very possible, but to have to go back and merge cells B-F in each
row is time consuming, prone to error, and goes against the grain of what
computers are supposed to do for us.
Any idea how to resolve this problem? Is there a way to break worksheets
into sections (like Word allows for) so that individual actions in each
section can be done?
Thanks
Gil
Columns B-F have been merged in this data section, but not so in A1:J23. When
I try sorting the data section I am only presented with columns (as a whole)
to sort. Obviously, I'm getting the message "merged cells must be identical
size".
I've looked through past postings about this, and done some Internet
searching, and the best I can find is how to unmerge the merged cells and the
sort will work.
Yup! It works just fine, but the problem is my data section in columns B-F
contain data only in column B. When I go to merge those cells, the only way
to do it is by individual rows.
While I only have a few rows in this worksheet, it only takes a minute or
so, but it isn't being done in one action. What if this table grows and I
have several hundred rows in this data section. Actions of unmerging and
sorting are very possible, but to have to go back and merge cells B-F in each
row is time consuming, prone to error, and goes against the grain of what
computers are supposed to do for us.
Any idea how to resolve this problem? Is there a way to break worksheets
into sections (like Word allows for) so that individual actions in each
section can be done?
Thanks
Gil