EXCEL SORT

G

George Lawshe

If I leave the cursor in a single cell in a spreadsheet and sort the
spreadshet, sometimes it will sort all the rows and all the colimns,
unfortantly, sometimes it will sort all of the rows in some the columns. You
can imagine the problem this creates. The only way I feel safe ist to
highlight the entire working area, then sort the spreadsheet.
 
A

Arvi Laanemets

Hi

When you select a single cell before sorting, Excel sorts a range to first
empty column/row. So you have to be sure you don't have any gaps in your
table.
 
G

Gord Dibben

George

Left to its own discretion Excel will select a range to the next blank row or
column.

Best to select manually your entire range as you have found is the safest
method.

Gord Dibben Excel MVP
 
J

jimbo693

i used a macro to sortall the rows down to 1000 excel will put all empty
rows at the bottom of the sort, i also added a button at top of sheet
so all i have to do is click the button and the jobs done
 
Top