Hello I need some assistance please 

So I've created my excel data sheets for importing as required and uploaded it into QBO, once I get to the data mapping fields, certain fields that need changing are marked in red and I have to now change these fields line by line, eg: income and expense accounts and qty etc.

Is there a way to change this data for all the line items in one go, sort of like a "select all" feature instead of changing each line individually?

I am importing split files to cater for all the inventory items and it's rather frustrating to change the required fields line by line as files can contain up to 900 lines at a time.

Please advise if there is a work around this.