Forum Discussion
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 they can help you in your everyday work with Excel.
Jan Karel Pieterse is the owner of JKP Application Development Services (jkp-ads.com). Jan Karel develops custom solutions in Microsoft Office and is a top expert in Microsoft Excel and VBA. Jan Karel has been granted the Microsoft MVP Award for each consecutive year since 2002 for his outstanding community work in newsgroups, forums and publications. Jan Karel lives in the Netherlands.
Cuong
Microsoft
5 Replies
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
- cuong
SamColumn You may need a macro/VBA script here. JKPieterse Can you help?
