To Change the Width of One Column, Drag the Boundary on the Right Side of the Column Heading

Column Width

To change the width of one column, drag the boundary on the right side of the column heading until the column is the width that you want.

To change the width of multiple columns, select the columns that you want to change, and then drag a boundary to the right of a selected column heading.

To change the width of columns to fit the contents, select the column or columns that you want to change, and then double-click the boundary to the right of a selected column heading.

To change the width of all columns on the worksheet, click the Select All button, and then drag the boundary of any column heading.

Sort

Sort text

Select a column of alphanumeric data in a range of cells, or make sure that the active cell is in a table column containing alphanumeric data.

On the Data tab, in the Sort & Filter group, do one of the following:

To sort in ascending alphanumeric order, click Sort A to Z.

To sort in descending alphanumeric order, click Sort Z to A.

Optionally, you can do a case-sensitive sort.

On the Data tab, in the Sort & Filter group, click Sort.

In the Sort dialog box, click Options.

In the Sort Options dialog box, select Case sensitive.

Click OK twice.

To reapply a sort after you change the data, click a cell in the range or table, and then on the Data tab, in the Sort & Filter group, click Reapply.

Issue: Check that all data is stored as textIf the column that you want to sort contains numbers stored as numbers and numbers stored as text, then you need to format them all as text. If you do not, the numbers stored as numbers are sorted before the numbers stored as text. (See TEXT Function)

Issue: Remove any leading spaces In some cases, data imported from another application might have leading spaces inserted before data. Remove the leading spaces before sorting the data. (See TRIM Function)

Sort numbers

Select a column of numeric data in a range of cells, or make sure that the active cell is in a table column containing numeric data.

On the Data tab, in the Sort & Filter group, do one of the following:

To sort from low numbers to high numbers, click Sort Smallest to Largest.

To sort from high numbers to low numbers, click Sort Largest to Smallest.

Issue: Check that all numbers are stored as numbersIf the results are not what you expected, the column might contain numbers stored as text and not as numbers. For example, negative numbers imported from some accounting systems or a number entered with a leading ' (apostrophe) are stored as text. (See VALUE Function)

Sort dates or times

Select a column of dates or times in a range of cells, or make sure that the active cell is in a table column containing dates or times.

Select a column of dates or times in a range of cells or table.

On the Data tab, in the Sort & Filter group, do one of the following:

To sort from an earlier to a later date or time, click Sort Oldest to Newest.

To sort from a later to an earlier date or time, click Sort Newest to Oldest.

To reapply a sort after you change the data, click a cell in the range or table, and then on the Data tab, in the Sort & Filter group, click Reapply.

Issue: Check that dates and times are stored as dates or times If the results are not what you expected, the column might contain dates or times stored as text and not as dates or times. For Excel to sort dates and times correctly, all dates and times in a column must be stored as a date or time serial number. If Excel cannot recognize a value as a date or time, the date or time is stored as text. (See DATEVALUE Function)

Auto-Fill

Use the fill handle to fill data

To quickly fill in several types of data series, you can select cells and drag the fill handle(fill handle: The small black square in the lower-right corner of the selection. When you point to the fill handle, the pointer changes to a black cross.) . To use the fill handle, you select the cells that you want to use as a basis for filling additional cells, and then drag the fill handle across or down the cells that you want to fill.

Paste Special Options

AllPastes all cell contents and formatting of the copied data.

FormulasPastes only the formulas of the copied data as entered in the formula bar.

ValuesPastes only the values of the copied data as displayed in the cells.

FormatsPastes only cell formatting of the copied data.

CommentsPastes only comments attached to the copied cell.

ValidationPastes data validation rules for the copied cells to the paste area.

All using Source themePastes all cell contents in the document theme formatting that is applied to the copied data.

All except bordersPastes all cell contents and formatting applied to the copied cell except borders.

Column widthsPastes the width of one copied column or range of columns to another column or range of columns.

Formulas and number formatsPastes only formulas and all number formatting options from the copied cells.

Values and number formatsPastes only values and all number formatting options from the copied cells.