excel spreadsheet

[frankief]

I have just finished a long spreadsheet and now want to reference the various sections A to Z or 1.1 to 1.34 etc. Is there an easy way to do this in Excel? to save a lot of typing, Thanks.

[SaxyJag]

Do you mean you want alphabetise smaller lists within big lists?

If so. highlight the rows you want to alphabetise, then select Sort from the Data menu on the toolbar. In the dialogue box that comes up, click for whether or not you have a header row, and then click to sort on whichever column you need the entries sorting by.

You'll need to do this for every range you want to sort.

Another way of doing it on a temporary basis, for record searching, is to open the Data menu again, click Filter, and then Autofilter. Then go to the column you want to look at, click the drop down arrow that's appeared, and select whatever criteria you want to sort on. You can switch the filter off when you don't need it.

[frankief]

No, its simply that I have a long list of items. I want to give each row an alphabetical letter reference starting with A then B,C,D etc. I just need a quick numbering system.

[pedderwo]

If you type 1,1 into A1 and 1.2 into A2 then highlight both cells and grab the little box at the bottom right of both cells and drag that down as far as you need to go the numbers should increase 1.3 - 1.4 - 1.5 etc this can also be done along the top.

[frankief]

Thanks Pedder but can this be done A to Z?