Rearrange Columns Article For Free

Quick Sort With Sort Buttons Select one cell in the column you want to sort. On the Excel Ribbon, click the Data tab. Click Sort A to Z (smallest to largest / oldest to newest) or Sort Z to A (largest to smallest / newest to oldest)

Select the column or columns that you want to change. Go to Home > Cells > Format. Under Cell Size, select AutoFit Column Width. Note: To quickly autofit all columns on the worksheet, select Select All, and then double-click any boundary between two column headings.

You can move columns when viewing or editing a report. To move a column when viewing a report, click the header of the column you want to move and drag it to the new position in the report.

Moving Rows and Columns in Microsoft Word Select the entire row or column that you want to move. Click on the highlighted row or column, and hold down the mouse button. ... Drag the row or column to the place where you want it to be. ... Release the mouse button.

How to drag columns in Excel Select the column you want to move. Hover the mouse pointer over the edge of the selection until it changes from a regular cross to a four-sided arrow. ... Press and hold the Shift key, and then drag the column to a new location. ... That's it!

Move or copy rows and columns by using the mouse Select the row or column that you want to move or copy. Note: Make sure that you hold down CTRL or SHIFT during the drag-and-drop operation. If you release CTRL or SHIFT before you release the mouse button, you will move the rows or columns instead of copying them.

Drag the rows or columns to another location. Hold down OPTION and drag the rows or columns to another location. Hold down SHIFT and drag your row or column between existing rows or columns. Excel makes space for the new row or column.