Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Filtering columns

Copper Contributor

IMG_4096.jpeg

Can you filter the columns to show only those filled (E) after row 4?

3 Replies

@Lulu1180 

Excel can filter rows, but not columns.

It would be possible to hide columns using VBA code. Would that be OK?

Yes that would be ok, can you please help me with what VBA code to use

@Lulu1180 

See the attached workbook. You'll have to allow macros.