UNABLE TO DATA SORT DUE TO CELL SIZE VARYING

B

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
 
C

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
Click to expand...

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.
 
B

buckley.d

> [email protected] 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
Click to expand...
[/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
>
Click to expand...
 
B

Bob Greenblatt

No such options in format/ cell on my apple
Click to expand...
There most certainly is that option. Use Format-Cells and look in the
alignment tab. Make sure merge cells is not marked.
 
Top