Rearrange columns in Datasheet view

Datasheet view offers a quick and easy way to change the order of columns.

1. To move a column, place the mouse pointer on the header of the column that you want to move until you see the move ( ) pointer.

   To move a range of columns, click the header of the first column, then keeping the SHIFT key pressed, click the last column in the range. Place the pointer on one of the sides of the rectangle that covers the selected columns to display the move pointer.

2. Click and drag selection to the new location.

When you move a column, the view definition gets automatically updated.

Note  You cannot move rows. You can rearrange rows by sorting them.