Format as Table without Autofilter

[jbfrank]

I have a really annoying problem that seems like it would be an easy fix, but I'm not able to figure this out.

When I select a range and click "Format as Table", Excel 2007 automatically adds a row with an autofilter on it. When I click "My table has headers", Excel still inserts column headings with autofilters. Unless I change the color of the text to 'white', the column names are visible.

Is there a way to disable the autofilter option when formatting as a table? And is there a way to prevent Excel from adding column headings to my worksheet when I do this? This columns are blank, and I'd like them to stay that way.

Why is this important? I've created a gantt chart with several timelines. As these timelines change, I have to go through and modify all of the cell borders. Formatting that range as a table prevents me from having to do this, which saves me a ton of time.

Seems like there's a solution for this that I'm overlooking.

Thanks in advance for your help.

 

[mr_vodoo]

I have a really annoying problem that seems like it would be an easy fix, but I'm not able to figure this out.

When I select a range and click "Format as Table", Excel 2007 automatically adds a row with an autofilter on it. When I click "My table has headers", Excel still inserts column headings with autofilters. Unless I change the color of the text to 'white', the column names are visible.

Is there a way to disable the autofilter option when formatting as a table? And is there a way to prevent Excel from adding column headings to my worksheet when I do this? This columns are blank, and I'd like them to stay that way.

Why is this important? I've created a gantt chart with several timelines. As these timelines change, I have to go through and modify all of the cell borders. Formatting that range as a table prevents me from having to do this, which saves me a ton of time.

Seems like there's a solution for this that I'm overlooking.

Thanks in advance for your help.

To disable the filter row that is created when you format as table you have to do the following:

1. Select cells and click on "Format as Table". Choose your design and click OK when prompted.
2. Go to the "Design" Tab under "Table Tools" Tab (This tab only appears if you select the table).
3. Uncheck the option "Header Row" under "Table Style Options" and Done.

Hope it helps though is a bit late.

Regards

 

[pukenzz]

That works for me except I still want to be able to apply a filter to one column and when you uncheck the Header Row option it also takes away the ability to filter.