UNABLE TO DATA SORT DUE TO CELL SIZE VARYING

[buckley.d]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) HOW DO I GET ALL THE CELLS IN A SPREADSHEET TO THE THE SAME SIZE FOR DATA SORT TO WORK

 

[Carl Witthoft]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

HOW DO I GET ALL THE CELLS IN A SPREADSHEET TO THE THE SAME SIZE FOR DATA
SORT TO WORK

FIrst, stop shouting. What is this, 1981?

Next, it isn't cell size, it's that (most likely) you have merged cells.
Select the region, pull down Format/Cells and make sure the "merge
cells" box is cleared.

 

[buckley.d]

> (e-mail address removed) wrote:
>

> > Version: 2008
> > Operating System: Mac OS X 10.5 (Leopard)
> >
> > HOW DO I GET ALL THE CELLS IN A SPREADSHEET TO THE THE SAME SIZE FOR DATA
> > SORT TO WORK

[/QUOTE]

No such options in format/ cell on my apple

>
> FIrst, stop shouting. What is this, 1981?
>
> Next, it isn't cell size, it's that (most likely) you have merged cells.
> Select the region, pull down Format/Cells and make sure the "merge
> cells" box is cleared.
>
> --
> Team EM to the rescue! http://www.team-em.com
>

 

[Bob Greenblatt]

No such options in format/ cell on my apple

There most certainly is that option. Use Format-Cells and look in the
alignment tab. Make sure merge cells is not marked.