Microsoft Office Tutorials and References
In Depth Information
To Save a Workbook in CSV File Format
Save the worksheet in a different ﬁ le format.
Often, the best way to share data in a worksheet with other applications is to save the ﬁ le
as a text ﬁ le. The CSV ﬁ le format is most the most common type of text ﬁ le. When saving
data to a text ﬁ le, Excel will place one row from the worksheet on one line of text. In this
case, each sales rep record will be represented on one line of text in the CSV ﬁ le. The Grade
column is not included in the range to save because it is computed using the grade table,
which will not be part of the new ﬁ le.
The following steps show how to save the table (range A8:I21) in the Silver Photography Accessories Sales
Rep Table workbook in a CSV (Comma delimited) ﬁ le format so that the ﬁ le can be read by most applications. In
this example, the table is copied to a new workbook, saved using the CSV ﬁ le format, and then displayed and printed
• Click the Home tab on the Ribbon.
• Select the table in the
• Click the Copy button on
• Click the Ofﬁ ce Button
and then click New on the
Ofﬁ ce Button menu.
• When the New Workbook dialog
box is displayed, click the Create
• With cell A1 selected in the new
workbook, click the Paste button
on the Ribbon.
• Click the Select All button, point
to the right border of the column
A heading, and double-click to set
all column widths to best ﬁ t.
• Select cell A16 (Figure 5–68).