Data Sort

  • Thread starter Thread starter Jan Voigt
  • Start date Start date
J

Jan Voigt

I am trying to sort a data base. I have made sure all of
the rows are the same size and the width of the cell is
correct. The worksheet contains columns of dates,
numbers, dollars and text; however, sometimes there is
text in a number field.

Each time I try to sort I receive an error message "This
operation requires merged cells to be identically
sized". What is wrong? Other people are entering data
into this spreadsheet throughout the month and every
month I have to sort and consolidate this data so it will
be an ongoing problem unless I can figure out how to do
this.

Thank you for any help you can give me.

Jan
 
Jan,

Somewhere somehow a cell (or many) somewhere in your database has the "Merge
Cells" option selected. As a result, you have found that the spreadsheet
has been rendered useless.

Select the entire worksheet by clicking on the upper right hand corner of
the Column/Row Headings.

Then go to Format|Cells|Alignment and make sure the merge cells option is
deselected.

PC
 
Back
Top