ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Select Visible Cells Only (https://www.excelbanter.com/excel-discussion-misc-queries/10433-select-visible-cells-only.html)

Apparently

Select Visible Cells Only
 
I'm trying to find the tool that allows me to select the visible cells in a
filter. I've looked all around excel and I cannot find it. Is this something
that was deleted from XP.

Jason Morin

F5 Special Visible cells only

HTH
Jason
Atlanta, GA

-----Original Message-----
I'm trying to find the tool that allows me to select the

visible cells in a
filter. I've looked all around excel and I cannot find

it. Is this something
that was deleted from XP.
.


Dave Peterson

You can also customize your favorite toolbar.

tools|customize|commands tab|edit category
near the bottom of the list is: "select visible cells"

drag that icon to your favorite toolbar.

Apparently wrote:

I'm trying to find the tool that allows me to select the visible cells in a
filter. I've looked all around excel and I cannot find it. Is this something
that was deleted from XP.


--

Dave Peterson


All times are GMT +1. The time now is 02:41 PM.

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