User Guide

year-to-date figures from monthly notebooks to create a cumulative notebook showing
year-to-date expense totals.
To insert a file into a notebook
1 Close the file you want to insert.
2 Click Insert } Insert file.
3 Choose a filename.
If you want to insert a file from another application, include its filename extension.
4 Type the cell location before which you want to place the inserted file in the Before sheet
box.
If the file is inserted within the boundaries of a named selection of cells, or cells
referenced by a formula, references expand to include the new spreadsheets.
If inserting a file expands a named selection of cells or cell reference beyond the limit
of a notebook (beyond spreadsheet ZZZ), the reference becomes ERR.
To import a text file
1 Click File } Open.
2 Choose the drive and folder where the file is stored.
3 Choose ASCII Text (*.txt) from the File type list box.
4 Double-click the filename.
5 From the Parse settings list box, choose one of the following:

Automatic — automatically determines how best to parse the imported text file

Delimited auto — automatically parses imported delimited text files

Fixed width auto — automatically parses imported fixed-width text files
Lines larger than 4 KB are not imported. If the total number of lines (rows) you
import exceeds the limit of the number of rows you specified for a spreadsheet, the
data is truncated to this limit.
Files must be unformatted and saved as plain ASCII text files without any control
codes or other word-processor formatting. Before you open a text file, remove any
special formatting characters such as bold, underlining, or centering.
To save a text file
1 Select a cell on the relevant sheet.
2 Click File } Save as.
3 Type the filename with the extension .txt in the Filename box.
4 Choose ASCII Text (tab delimited or comma delimited) from the File type list box.
Only the contents of the current sheet (or, if it is empty, the first non-empty sheet) of
a notebook are saved.
222 Quattro Pro 10