Skip Column in the excel file
Any dummy column can be used in excel file for any calculation or any value for reference. Those column will not to be loaded and imported to Tally.
Prefix ” ! ” symbol with any column title in the excel to skip such column
Skip Row in the excel file
Any row can be skipped while loading data from excel file. Those rows will not to be loaded and imported to Tally. For example to in a large data, if users want to skip or filter any data to skip on import, this facility available.
Use column name “Skip” in excel file and set value “Yes” to skip any row.