Copy hidden columns but only filtered rows

[Dr. Demento]

Off the top of my head, I'm going to guess this isn't possible, but I thought I'd put it out there.

I have a filtered table with hidden columns. I need to capture all the columns but only want the filtered rows. Any way to copy/paste (non-VBA) in this scenario?

Thanks y'all.

 

[starl]

No. There's the ability to copy only the visible, but that affects rows and columns.

I'd suggest using Custom Views (View tab) to quickly switch between a view with hidden columns and one showing everything.

Since you've already got your columns hidden, go to Views, Custom Views and click Add, give the view a name.
Then unhide the columns and create another custom view for Showing All.

You can now filter the view showing all, copy just the visible rows (ALT+; to select), then go back to your hidden column view.

 

[Dr. Demento]

That's A-maz-zuh-zing!!! Thank you. I can already see other possible applications.