Excel - Hide Filter Arrow Button from Overlapping Text

preview_player
Показать описание
How to get rid of the text overlapping with the Excel Auto Filter Arrow Button? You can filter it on the second row, instead of the header row, and so, with that you can still see the entire header text without any overlapping and still use all Excel Filter's functionalities.
Рекомендации по теме
Комментарии
Автор

This is a bit messy in my opinion. For example you will not be able to use the column sort. No column names will appear. Obviously you could have invisible column headings but as I said, it is messy.


The solution, I just found is, use cell formating. So, for example a numerical column heading, I format the header cell, Horizonal: right; Vertical: Bottom; Indent:2 and Wrap Text

davidl
join shbcf.ru