Excel question

[Backroads]

So, being that our entire work-needed computer system is down for the day, I'm attempting to do actual work at the office today by putting together a new application log on Excel... and at yesterday's meeting everyone decided they want the log to be alphabetical. Now, I don't trust half the people using this log to be able to perform an alphabetical sort.

I'm considering either:

• Making a huge page of columns (one for each letter of the alphabet)
• Just creating multiple sheets.

I'm a total Excel one-step-above novice and am yet the "Excel guru" of the department (yes, it's very sad.) Which do you think would be the most user-friendly? Also accepting completely different ideas.

[Guest]

So, being that our entire work-needed computer system is down for the day, I'm attempting to do actual work at the office today by putting together a new application log on Excel... and at yesterday's meeting everyone decided they want the log to be alphabetical. Now, I don't trust half the people using this log to be able to perform an alphabetical sort.

I'm considering either:

• Making a huge page of columns (one for each letter of the alphabet)
• Just creating multiple sheets.

I'm a total Excel one-step-above novice and am yet the "Excel guru" of the department (yes, it's very sad.) Which do you think would be the most user-friendly? Also accepting completely different ideas.

I say add a button that they can push which will run a macro that will alphabetize the stuff for them. They're probably not gonna mess up clicking on one stinking button... probably.

:)

[pam]

Excel is supposed to make things easier. Doesn't sound easier having to do huge page of columns or creating multiple sheets.

I'm with Anatess about a macro..or perhaps attaching a step by step instruction on how to alphabetize. Much less work.

[Backroads]

I say add a button that they can push which will run a macro that will alphabetize the stuff for them. They're probably not gonna mess up clicking on one stinking button... probably.

:)

*thinks about two people in particular*

This is a good idea, though.

[Backroads]

People expressed they wanted to log in named alphabetically. I can't think of a simple way to set that up. Hopefully they will be okay with a simple way to sort alphabetically.

[ditd]

Hi Back roads, hopefully I can help, this should work if you are using Excel 2007 or 2010

Once you have a big list of colums in one sheet press "Ctrl+a"

this should select everything

Next click the filter button in your home ribbon, should look like this:

Then the colum headers at the top of your columns will have a little arrow that opens a filtering menu allow you to sort alphabetically, filter or search (should be obvious) as below:

Hopfully this should work, let me know if it doesn't/you need further assistance...