File Open dialog on macOS does not show folders separately from files

[Romit Mehta]

On macOS with Office 365 version of Excel (and PowerPoint), the File | Open dialog does not group folders separately from files. In my Finder I was able to do it by setting the property "Keep folders on top". 

Is it possible to honor this setting in the file opening dialog? 

[#2]

@Romit Mehta When you open a file in Excel on a Mac (O365), you should see the icon with the horizontal lines and down-arrow. There you can set the default for grouping the items in any folder. The "Kind" option will put folders first.

[#3]

@Riny_van_Eekelen Thanks. I am unable to see that horizontal lines with the down arrow icon. Is that after I open the file? I see this with a spreadsheet open

[#4]

@Romit Mehta First "File", "Open"

... then this one.

[#5]

@Riny_van_Eekelen that shows when you choose "On my Mac"? I am referring to this dialog:

[#6]

@Romit Mehta Sorry. I don't recognise that dialog. Which Excel version are you on?

[#7]

@Riny_van_Eekelen I am on 16.35 (200213200) on Office 365 on Mac. 

When I click File> I see this: 

Then, when I click Open, I see this:

The screenshot you showed only appears when I click on "On My Mac" in that window. 

I am looking for help in the "modern" or "cloud" version of the File Open window which does not seem to be sortable or group-able. 

[#8]

@Romit Mehta Okay. I never use the cloud for my Excel files. Sorry.