Any Excel Experts on NT??

[tecca nena]

So I have a list of about 100 random check #s  in a column that are out of order.

Does anyone know of a short cut to put these numbers in order, or will I have to go through one by one on some ridiculous cut and paste action.


Thanks

 

[tecca nena]

So I have a list of about 100 random check #s  in a column that are out of order.

Does anyone know of a short cut to put these numbers in order, or will I have to go through one by one on some ridiculous cut and paste action.


Thanks

 

[dr fonclbrics]

I think if you right-click one of the cells in the column you want to sort an option to sort in ascending or descending order should appear.

 

[dr fonclbrics]

I think if you right-click one of the cells in the column you want to sort an option to sort in ascending or descending order should appear.

 

[loendradio]

My excel has a sort button at the top, just highlight and click.

 

[loendradio]

My excel has a sort button at the top, just highlight and click.

 

[tmay407]

Select the column, then go to "Data," then "Sort..."

 

[tmay407]

Select the column, then go to "Data," then "Sort..."

 

[tecca nena]

Oh sahhweeet!!! thanks guys.. My boss asked me to do this and he said it would probably take a few hours... Im headed to the bar while Im on the clock...

 

[tecca nena]

Oh sahhweeet!!! thanks guys.. My boss asked me to do this and he said it would probably take a few hours... Im headed to the bar while Im on the clock...

 

[0cks]

You and your boss are part of the reason our economy is in the dumps

 

[0cks]

You and your boss are part of the reason our economy is in the dumps

 

[jking0821]

Haha the sort function now requires an excel expert.. maybe you should really impress him by making the word "Check No.'s" at the top of the column in Bold or maybe Underline it.

 

[jking0821]

Haha the sort function now requires an excel expert.. maybe you should really impress him by making the word "Check No.'s" at the top of the column in Bold or maybe Underline it.

 

[jking0821]

Haha the sort function now requires an excel expert.. maybe you should really impress him by making the word "Check No.'s" at the top of the column in Bold or maybe Underline it.

 

[jking0821]

Haha the sort function now requires an excel expert.. maybe you should really impress him by making the word "Check No.'s" at the top of the column in Bold or maybe Underline it.

 

[jking0821]

Haha the sort function now requires an excel expert.. maybe you should really impress him by making the word "Check No.'s" at the top of the column in Bold or maybe Underline it.

 

[jking0821]

Haha the sort function now requires an excel expert.. maybe you should really impress him by making the word "Check No.'s" at the top of the column in Bold or maybe Underline it.

 

[pianoman52]

LOL @ Jking. i clicked on this thread thinking he was going to ask about Macros. what was i thinking???

 

[pianoman52]

LOL @ Jking. i clicked on this thread thinking he was going to ask about Macros. what was i thinking???

 

[throwedindagame]

1.Hold control and shift together
2.Press the down arrow on your keyboard
3. Press Alt D S (in the order shown)

The sort menu should pop up
4. Press Enter

BEASTED!!!!!!!!!!

Training the Street FTW.
I seriously thought this guy was going to ask about vlookups or implementing macros.

Sorting data?

 

[throwedindagame]

1.Hold control and shift together
2.Press the down arrow on your keyboard
3. Press Alt D S (in the order shown)

The sort menu should pop up
4. Press Enter

BEASTED!!!!!!!!!!

Training the Street FTW.
I seriously thought this guy was going to ask about vlookups or implementing macros.

Sorting data?

 

[loendradio]

Originally Posted by tecca nena

Oh sahhweeet!!! thanks guys.. My boss asked me to do this and he said it would probably take a few hours... Im headed to the bar while Im on the clock...

lol..

 

[loendradio]

Originally Posted by tecca nena

Oh sahhweeet!!! thanks guys.. My boss asked me to do this and he said it would probably take a few hours... Im headed to the bar while Im on the clock...

lol..

 

[thunderchunk69]

him and his boss probably needed a college degree for their jobs

lmfao