Easy way to re-arrange rows in your Excel worksheet

List Assistant in detail

The List Assistant is the easy way to re-arrange rows in your worksheet. If you have to manually swap two rows, you have to insert a row, cut or drag the row being moved to the new row, and then delete the blank row that is left. With the List Assistant, you just select a cell anywhere on the row to be moved and click on the up or down arrow buttons (the first two buttons) of the List Assistant's toolbar buttons:

And the row is moved. If you click on the right arrow button (the third button), you may move or copy the selected rows to any location via the following dialog:

And, you are not limited to moving a single row at a time! Just select cells on all the rows you want to move and they are moved as a group!

The fourth and fifth buttons delete entire rows (all you need to do is to select a cell on a row).

The middle four buttons, on the List Assistant toolbar allow you to move a cell or a group of cells up down, left, or right.

The button allows you to move a cell anywhere.

The last two buttons, allow you to delete or insert cells.

See also in "Excel - Data management - merge, convert, delete"

• Address Assistant - Split addresses from one cell into multiple cells.
• Consolidation Assistant - Consolidate data from Excel workbooks or worksheets.
• CSV File Creator - Create a CSV file from Excel workbooks / worksheets.
• Data Assistant for Excel - Make table form data applicable for Excel pivot tables.
• Data Cleaner for Excel - Remove spaces, Change text case, Replace / modify text, etc.
• Data Extraction Assistant for Excel - Extract data from one worksheet to many spreadsheets.
• Data Loader for Excel - Easy loading, processing, and transferring data .
• Filter Assistant - Filter multiple Excel spreadsheet columns at a time.
• Formula Manager - Manage all formulas in Excel worksheets easily.
• Formula Ref Changer and Sheet Index Creator - Change Excel formula reference types.
• Name Splitter - Split names into several Excel cells.
• Number Manager - Fill in the gaps in Excel workbooks.
• Report To Data Assistant - Convert text reports into Excel worksheet databases.
• Spreadsheet Assistant - Over 200 useful features for MS Excel.
• Text File Importer - Import text files with over a million lines into Excel.
• Text Manager - Change case in Excel, Join text to one cell, Remove spaces, etc..