How to get rid of blue line in excel

New Contributor

Hi guys,

does anyone know what this blue line is and how I can get rid of it?

It also appears in the pdf when I export it.


Screenshot 2021-08-30 144340.png

3 Replies

@Amin_Alidoosti It seems you are using structured table with a custom format. Click anywhere in the table and look into the "Table Design" ribbon to select the style without borders.

Screenshot 2021-08-30 at 09.14.49.png

@Riny_van_Eekelen I cleared the Table Style and yet it is still there and when I drag it, it creates more columns. 



@Amin_Alidoosti Well, the fact that new columns are created when upon dragging is not something you can change. It's a key feature of working with structured tables. Can't tell why the blue line persists, even when you choose a totally clean table format.