ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how can i choose only visible cells from a autofilter? (https://www.excelbanter.com/excel-worksheet-functions/143708-how-can-i-choose-only-visible-cells-autofilter.html)

gonzolio

how can i choose only visible cells from a autofilter?
 
A coworker once showed me a toolbar function that allowed me to choose and
copy only the visible cells from a worksheet with an autofilter. The function
also allowed me to copy only the visible cells from a worksheet that had a
pivot table in it where the subsequent rows were grouped. How do I find this
function in Excel? It looks like a plus sign inside of a box and it's white.


All times are GMT +1. The time now is 06:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com