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

excel sorting

ResolvedVersion Standard

Jo has attended:
Excel Intermediate course
Excel Advanced course

Excel - Sorting

In excel 2003 I could have similar data in several sheets (account number, name, amount owed etc) sort it in the first sheet then go to the next sheet and do edit repeat sort. I can't find how I do this in excel 2007.

RE: Excel - Sorting

Dear Jo

Thank you attending Excel 2007 course. I hope you enjoyed the training.

The Menu bar in previous versions of Office has been replaced by the Ribbon in Office 2007.

Please remember that you have the Quick Access Toolbar (QAT) which has the Undo and Redo buttons.

To repeat the last action you can simply click the Redo button on the QAT or the shortcut key is the function key F4.

The F4 key helps you to repeat any last action that you may have performed.

If this reply has helped answering your query then I would request you to please mark this question as resolved . If not then you can either reply back to this question for further explanation or post a new question the forum.

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003

Excel tip:

Remove unused toolbar buttons

Are there buttons on your Excel toolbars that you never use? Remove them from the toolbar by doing the following:

1. Go to Tools - Customise - Commands.
2. Select the toolbar button you wish to remove, then use your mouse to drag and drop the button into the Excel window. When you release your finger from the mouse, the button will disappear.

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.09 secs.