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

formatting

ResolvedVersion 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:

Moving between split pane sections in a spreadsheet

If you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections:

F6 - Move to the next pane
Shift + F6 - Move to the previous pane

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.