Can't get rid of blue line separating my two tables in excel

Solution 1:

You're using the Team ribbon bar, which is connected to a TFS or Azure Dev Ops instance. The data in the table is based on a query, so Excel is automatically formatting the table for you. If you want to amend the formatting, copy the contents of the sheet and paste values into another sheet, to break the link to TFS.

If you alter the data in that sheet whilst it's still connected to TFS, one of 2 things will happen. 1, the data will refresh and you'll get raw data from TFS, undoing all your formatting. 2, you end up pushing the changes into TFS, and your team mates get angry with you for publishing updates to work items from Excel.

If you want to change what you're seeing, edit the TFS query you're using the export the data.

Note - I can tell this is a TFS query due to the Path column, and the data contained within the cells.