Sorting an Excel table when it contains Named Cells

Hi. I am using Excel 2016. I have a three column table with Namd Cells in many of the column three entries. If I use any sort function it does not take the cell name with the sorted entry. Is this ...