excel sorting

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 - Sorting

Excel - Sorting

resolvedResolved · Low Priority · Version 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:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips


Server loaded in 0.08 secs.