| The List Assistant is the easy way to re-arrange rows or cells 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 on the row to be moved and click on the up or down buttons of the List Assistant's toolbar buttons and the row is moved. And, you are not limited to moving a single row at a time! Just select cells you want to move and they are moved with entries in the destination cells being shift down, left or right as needed! |