Notice: The information on this page is only for users of Personal Taxprep 2018. If you are using Personal Taxprep Classic 2018, consult the help available in the program. |
Modify the Import and Export Settings of Excel Files
Personal Taxprep allows you to modify the settings used during .xls* file import and export.
To modify these settings, proceed as follows:
- On the Tools menu, click Options and Settings.
- Under Import/Export, click XLS* Files .
- In the Worksheet box, enter the number of the worksheet used during the import or export.
In the Position area:
in the Cell ID column box, enter the position of the column which will contain the cell number;
in the Value column box, enter the position of the column which will contain the cell value;
in the Old value column box, enter the position of the column which will contain the cell value from last year;
in the Cell name column box, enter the position of the column which will contain the cell name;
in the First row box, enter the line number where the first imported (or exported) data is to be entered; and
in the Last row box, enter the line number where the last imported data is to be entered (this step is optional).
- Click OK.