Forum Discussion
MicrosoftModern Excel webinar: Working with tables in Microsoft Excel
Hi, first of all I'd like to thank you for this interesting webinar. I just have one question: I have an Excel table where in some columns for certain rows there are no data. If I filter a column for a name, included in that column, it is possible to automatically hide the other columns where there are no data inside? If yes, how should I have to move? I hope to have been clear in my question
Thanks a lot. Best regards, Samuele
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.