Hi there and welcome
I believe you are referring to the option to groping rows
Select the problem rows, then Try Data > Group > UnGroup
Does this then stop it?
Columns will always appear...
Can you attach the file do I can see which columns you are referring to please?
ok, well the columns you either need to delete by right clicking on the label at the top then Delete
The sliders is Grouping and this you did via Data > Group > Group by accident. It is a feature in Excel that allows you to manage the display of data easily.
I am not sure what though you mean with the No Thanks... but if you would like any additional information or assistance, please do not hesitate to let me know.
And please take a second to rate my service by clicking one of the stars at the top of the screen then submit