Modern Excel webinar: Working with tables in Microsoft Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1141777%22%20slang%3D%22en-US%22%3EModern%20Excel%20webinar%3A%20Working%20with%20tables%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1141777%22%20slang%3D%22en-US%22%3E%3CP%3EEver%20used%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fformat-an-excel-table-6789619f-c889-495c-99c2-2f971c0e2370%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EFormat%20as%20Table%3C%2FA%3E%26nbsp%3Bin%20Microsoft%20Excel%3F%26nbsp%3B%20Did%20you%20know%20Format%20as%20Table%20can%20be%20a%20whole%20lot%20more%20than%20just%20fancy%20formating%3F%26nbsp%3B%20Join%20MVP%20Jan%20Karel%20Pieterse%20as%20he%20discusses%20working%20with%20tables%20and%20how%20they%20can%20help%20you%20in%20your%20everyday%20work%20with%20Excel.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3C%2FP%3E%3CDIV%20class%3D%22video-embed-center%20video-embed%22%3E%3CIFRAME%20class%3D%22embedly-embed%22%20src%3D%22https%3A%2F%2Fcdn.embedly.com%2Fwidgets%2Fmedia.html%3Fsrc%3Dhttps%253A%252F%252Fwww.youtube.com%252Fembed%252FZyrShlmcujo%253Ffeature%253Doembed%26amp%3Bdisplay_name%3DYouTube%26amp%3Burl%3Dhttps%253A%252F%252Fwww.youtube.com%252Fwatch%253Fv%253DZyrShlmcujo%26amp%3Bimage%3Dhttps%253A%252F%252Fi.ytimg.com%252Fvi%252FZyrShlmcujo%252Fhqdefault.jpg%26amp%3Bkey%3Dfad07bfa4bd747d3bdea27e17b533c0e%26amp%3Btype%3Dtext%252Fhtml%26amp%3Bschema%3Dyoutube%22%20width%3D%22400%22%20height%3D%22225%22%20scrolling%3D%22no%22%20title%3D%22YouTube%20embed%22%20frameborder%3D%220%22%20allow%3D%22autoplay%3B%20fullscreen%22%20allowfullscreen%3D%22true%22%3E%3C%2FIFRAME%3E%3C%2FDIV%3E%3CP%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CEM%3EJan%20Karel%20Pieterse%20is%20the%20owner%20of%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fjkp-ads.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EJKP%20Application%20Development%20Services%3C%2FA%3E%26nbsp%3B(jkp-ads.com).%20Jan%20Karel%20develops%20custom%20solutions%20in%20Microsoft%20Office%20and%20is%20a%20top%20expert%20in%20Microsoft%20Excel%20and%20VBA.%20Jan%20Karel%20has%20been%20granted%20the%20Microsoft%20MVP%20Award%20for%20each%20consecutive%20year%20since%202002%20for%20his%20outstanding%20community%20work%20in%20newsgroups%2C%20forums%20and%20publications.%20Jan%20Karel%20lives%20in%20the%20Netherlands.%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECuong%3C%2FP%3E%0A%3CP%3EMicrosoft%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1141777%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EShow%20and%20Tell%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETips%20and%20Tricks%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETutorial%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1402346%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20Excel%20webinar%3A%20Working%20with%20tables%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1402346%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320924%22%20target%3D%22_blank%22%3E%40cuong%3C%2FA%3E%3C%2FP%3E%3CP%3EHi%2C%20first%20of%20all%20I'd%20like%20to%20thank%20you%20for%20this%20interesting%20webinar.%20I%20just%20have%20one%20question%3A%20I%20have%20an%20Excel%20table%20where%20in%20some%20columns%20for%20certain%20rows%20there%20are%20no%20data.%20If%20I%20filter%20a%20column%20for%20a%20name%2C%20included%20in%20that%20column%2C%20it%20is%20possible%20to%20automatically%20hide%20the%20other%20columns%20where%20there%20are%20no%20data%20inside%3F%20If%20yes%2C%20how%20should%20I%20have%20to%20move%3F%20I%20hope%20to%20have%20been%20clear%20in%20my%20question%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot.%20Best%20regards%2C%20Samuele%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1404376%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20Excel%20webinar%3A%20Working%20with%20tables%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1404376%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F672597%22%20target%3D%22_blank%22%3E%40SamColumn%3C%2FA%3E%26nbsp%3BYou%20may%20need%20a%20macro%2FVBA%20script%20here.%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%20Can%20you%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1405001%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20Excel%20webinar%3A%20Working%20with%20tables%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1405001%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F672597%22%20target%3D%22_blank%22%3E%40SamColumn%3C%2FA%3E%26nbsp%3BI'd%20be%20happy%20to%20help%20but%20I%20am%20sorry%20but%20I%20am%20not%20clear%20on%20your%20requirements.%20Can%20you%20please%20try%20to%20explain%20what%20you%20need%20in%20different%20words%2C%20perhaps%20with%20a%20screen-shot%20attached%3F%20Or%20maybe%20even%20a%20sample%20workbook%20(with%20non-sensitive%20data%20please!)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1426789%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20Excel%20webinar%3A%20Working%20with%20tables%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1426789%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3Bthanks%20for%20your%20help.%20I've%20prepared%20a%20very%20simple%20table.%20In%20this%20case%2C%20if%20you%20filter%20the%20coloumn%20age%20by%2031%2C%20Excel%20will%20show%20you%20only%20the%20raw%20with%20Jack.%20In%20this%20case%2C%20the%20coloumn%20city%20doesn't%20have%20any%20data.%20It%20is%20possible%20in%20this%20case%20to%20automatically%20hide%20this%20column%3F%3C%2FP%3E%3CP%3EIn%20general%2C%20it%20is%20possible%20to%20automatically%26nbsp%3Bhide%20coloumns%20where%20there%20are%20no%20data%20when%20filtering%20for%20other%20coloumns%3F%3C%2FP%3E%3CP%3EI%20hope%20I've%20been%20more%20clear.%20If%20not%20excuse%20me.%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3CP%3ESamuele%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1427169%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20Excel%20webinar%3A%20Working%20with%20tables%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1427169%22%20slang%3D%22en-US%22%3EActually%2C%20there%20is%20no%20need%20to%20make%20your%20table%20this%20big.%20Just%20make%20it%20as%20big%20as%20you%20have%20data.%20If%20you%20have%20more%20data%2C%20just%20type%20under%20the%20last%20row%20of%20the%20table%20and%20it'll%20become%20part%20of%20the%20table%20automatically.%3C%2FLINGO-BODY%3E
Highlighted
Microsoft

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
Highlighted

@cuong

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

Highlighted

@SamColumn You may need a macro/VBA script here.  @Jan Karel Pieterse  Can you help?

Highlighted

@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!)

Highlighted

@Jan Karel Pieterse 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

Highlighted
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.