Forum Discussion
cuong
Microsoft
MicrosoftModern Excel webinar: Working with tables in Microsoft Excel
Ever used Format as Table in Microsoft Excel? Did you know Format as Table can be a whole lot more than just fancy formating? Join MVP Jan Karel Pieterse as he discusses working with tables and how...
SamColumn I'd be happy to help but I am sorry but I am not clear on your requirements. Can you please try to explain what you need in different words, perhaps with a screen-shot attached? Or maybe even a sample workbook (with non-sensitive data please!)
JKPieterse thanks for your help. I've prepared a very simple table. In this case, if you filter the coloumn age by 31, Excel will show you only the raw with Jack. In this case, the coloumn city doesn't have any data. It is possible in this case to automatically hide this column?
In general, it is possible to automatically hide coloumns where there are no data when filtering for other coloumns?
I hope I've been more clear. If not excuse me.
Best regards
Samuele
- Actually, there is no need to make your table this big. Just make it as big as you have data. If you have more data, just type under the last row of the table and it'll become part of the table automatically.