2

When filtering, my header columns are overlapped by the arrow buttons as in the below snapshot.

How can I get rid of this?

  • 1
    You could perhaps increase the cell height and format the text to be right aligned? – Jerry May 17 '13 at 7:23
6

I found a different solution to this that may be preferable to some.

There is no reason why the filter has to go on the same row as the header label. So we can simply add in another row under our header to put the filter on, avoiding any overlap with the text in our header row.

With some quick formatting work, we end up with:

enter image description here

Note that I moved the column labels on the right that were not displayed clockwise down to the new row, and erased the border between the old and new row.

  • I love your solution and get it as accepted immediately ^^ Thank you! – Nam G VU May 2 '15 at 1:21
4

There is nothing you can do to push the buttons into the background. Format the cells to be top-aligned, or add a few spaces before the text in each cell.

Top aligned looks like this:

enter image description here

Spaces added in front of the text look like this:

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.