go to - special - visible cells only - takes too many key strokes

[Guest]

I am aware that I should write a macro in personal.xls but for the next
version of excel please put the function: "edit - go to - special - visible
cells only" somewhere more accessible.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...d-2602fe8e29e4&dg=microsoft.public.excel.misc

 

[Ed Ferrero]

Hi,

You could right-click a toolbar, select Customize..., select the Commands
tab, select the Edit category, scroll down to the end of the commands list.
Third from the bottom is a button to select visible cells only.
Click-and-drag that to a toolbar.

No macros required - just customizing your toolbar.

Ed Ferrero
http://edferrero.m6.net

 

[Dave Peterson]

You can customize your favorite toolbar with an icon that does that for you.

Tools|Customize|Commands tab|Edit category
Look for select visible cells
and drag to your favorite toolbar.

Select your bigger range and then click that button!

 

[Guest]

Ah - I forgot about this - thanks Dave and Ed - this makes it much quicker.