formatting

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formatting

Formatting

resolvedResolved · Medium Priority · Version 2007

Hannah has attended:
Excel Introduction course

Formatting

How do you alphabetize columns?

RE: Formatting

Hello Hannah

Thank you for your question and welcome to the forum.

Do you want to put columns into alphabetical order from left to right, or put the items under headings in each column in alphabetical order (i.e. from top to bottom)?

Amanda


 

Excel tip:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips


Server loaded in 0.08 secs.