HELP!!!Sort Not Wolking

I have created a column to sort a spreadsheet. However, after I add a column on both sides of the sorting column. The column doesn't sort the entire spreadsheet and just sort itself
Is there a way to solve this problem?
Thanks in advance

[Galto]

Hi,

Are you using the sort button on the toolbar, or going to Data > Sort and choosing one of the options there?

Have you highlighted all three columns that you want sorted?

- Galto

I am using sort button. What I am doing is that I select the column that I want to sort by and click the sort button

The columns on the right of sorting column can't sort if I add one empty column to the right of the sorting column and the columns on the left of sorting column can't sort if I add one empty column to the left of the sorting column.
Is there a way to solve this problem
Thanks in advance

[scwyj]

I may be mistaken, but choosing a column to "sort by" and clicking the sort button will only sort that column, not the entire spreadsheet. If you want to sort the sheet, select the entire sheet by clicking to the left of A and above 1, then choose Tools > Sort, idenfity your header row, and choose the column(s) you wish to sort by.

sc