Nagoya Kita, you should define the 'by column' setting before you prepare your Excel file.
Also important: the SpreadsheetML v.1 file type ID on your screenshot means that Studio applied the Excel 2016 filter to your Excel 2013 file.
You have to move up the Excel 2013 filter (where this setting is available) above the Excel 2016 filter (where this setting is not available at all) and uncheck the latter.
In your case the file type must read "Excel 2007 v. 22.214.171.124", but I can see it is "SpreadsheetML v.1"
This will work.
Another question to SDL:
It seems SDL chose to remove this superfluous feature for newer versions.
Is it no longer available for Excel 2016?
At the same time, if you try to select Excel 2013 filter for Excel 2016 files, Studio just will drop an error when saving target:
How do I select the processing sequence for Excel 2016?