PDA

View Full Version : Excel Question


Really Not All That Bright
02-19-2010, 11:09 AM
So I am using excel to keep track of some print jobs. The first column on my spreadsheet has a name in it, but I can't enter the jobs in alphabetical order, but rather as they come.

The spreadsheet has to be submitted in alphabetical order at the end of the day. Is there a simple way to have Excel reorder my rows according to the alphabetical order of the first column?

Dragline
02-19-2010, 11:14 AM
Sure, just to the data tab ( if you're using excel 2007) and hit the A->Z button. For more fun, use the Filter button in the same area to turn on filtering and you can sort from there, too

Really Not All That Bright
02-19-2010, 11:35 AM
Never mind. Figured it out.

ETA: Thanks - I didn't see the A>Z thing.