Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 2 Working with Data 67

Notice that the data for the fi rst two columns appear to be cut off, but

don’t worry. When Excel imports a fi le, it formats the new workbook with a

standard column width of about nine characters, regardless of column con-

tent. The data are still there but are hidden.

To format the column widths to show all the data:

1 Press CTRL 1 a twice to select all cells in the worksheet.

2 Move the mouse pointer to the border of one of the column head-

ers until the pointer changes to a and double-click the column

border.

Excel changes the column widths to match the width of the longest

cell in each column.

3 Click cell A1 to remove the selection.

Save and close the workbook.

4 Click the Offi ce button and then click Save As.

5 Type Wheat Data in the File Name box and select Excel Workbook

(*.xlsx) from the Save As Type list box.

Figure 2-24
Wheat data

imported

into Excel