excel training onsite - series

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training onsite - Series

excel training onsite - Series

resolvedResolved · Low Priority · Version Standard

Sonia has attended:
PowerPoint Intermediate Advanced course
Excel Advanced course

Series

I would like to create a series of letters in the alphabet order. How can I do it?

RE: series

Hi Sonia

Thanks for your question.

In Excel, you can put your spreadsheet data into alphabetical order by using the Sort feature. This usually works best if you have your spreadsheet in a list format (i.e. a heading at the top of each column with related information underneath each heading). There are two sort buttons on the standard toolbar (they have the letters A and Z on them) otherwise you can go to Data - Sort.

If this does not answer your question, reply back to me with some more detail and I'll be happy to help further.

thanks
Amanda


 

Excel tip:

Quick Absolute Cell References

When entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs).

Note that the F4 key outside of editing a formula is the Repeat key to repeat a previous action.

View all Excel hints and tips


Server loaded in 0.08 secs.