my worksheet has 3 columns in which i need to have the option of sorting at
any time, i would like to take a random empty cell and use it as a switch
button so to say, to sort A,B,C . Taking in mind that there are 100 Rows

A1=Company Name
B1=Part Number
C1=Part Number

D1=Start Date
E1-O1=Dates of job steps
P1=Completion Date

I need to sort and not loose any cell structure at the same time

i think the best and easy way to do it is pur all your data in a table format
(excel 2007), that way you get an arrow on the header of every column, and
you can sort anytime clicking that arrow.


"ohnesorge" wrote:

my worksheet has 3 columns in which i need to have the option of sorting at
any time, i would like to take a random empty cell and use it as a switch
button so to say, to sort A,B,C . Taking in mind that there are 100 Rows

A1=Company Name
B1=Part Number
C1=Part Number

D1=Start Date
E1-O1=Dates of job steps
P1=Completion Date

I need to sort and not loose any cell structure at the same time

Hi,

Are you saying that you only want to sort the first three columns or do you
mean you want to sort all the data based on the first three columns?

If you want to sort all the data based any one of the first three columns:
if your data is set up correctly you can use 1. Data, Sort 2. the Sort
Ascending or Sort Desending toolbar buttons, 3. You can apply an Auto Filter
and use the sort command on the drop down. 4. You can define the data as a
List (2003) or Table (2007) and use the autofilters that are added.

The quickest way is #2 - you click any single cell in the column you want to
sort on and click the appropriate button.

All of these methods do not require selecting your data if the data is set
up correctly - this means 1. One row of titles, 2. No completely blank rows
or columns within the data, 3. No data directly adjacent (touching) to your
data that you do not want to sort. 4. (optional) the format of the first row,
titles, is different from the data underneath - use bold or center, or ....

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"ohnesorge" wrote:

my worksheet has 3 columns in which i need to have the option of sorting at
any time, i would like to take a random empty cell and use it as a switch
button so to say, to sort A,B,C . Taking in mind that there are 100 Rows

A1=Company Name
B1=Part Number
C1=Part Number

D1=Start Date
E1-O1=Dates of job steps
P1=Completion Date

I need to sort and not loose any cell structure at the same time