r/excel•
p90036

how do i make 'format as table' without column header-indicator things

unsolved

last year i made a spreadsheet and a certain range using 'format as table'

it didnt have headers, but it was very useful to have as the 'background' cell coloring for that area and then be able to color cells on top without affecting the background

however now when i try to format an area as 'format as table' it introduces column header-indicators - the left side gray button thing .

https://preview.redd.it/jmcrxyy3ngfh1.png?width=112&format=png&auto=webp&s=a89d4a6740f58a07885addc41c709c48e83f3089

Even if i do not click 'has headers' or i do, still outputs the column header indicators.

see the img below the range a4:n11 has the 'table' style and there's no header things while the right side q2:u11 does...

how do i do the 'format as table' without having the header indicator things

https://preview.redd.it/u1l62pusmgfh1.png?width=1152&format=png&auto=webp&s=e315cefde1467ac5c07b17266c3392f612a93fee

Posted Jul 25, 2026, 11:29 PM UTC

1413
Loading comments…