Keyboard shortcut to "Select Visible Cells":
<Alt <; that's a semi-colon
OR ... add an icon to the toolbar for a "single click" option:
Don't know how to do it in XL07 (see link below), but in earlier versions
Right click in toolbar and choose "Customize",
Under the "Commands" tab, click on "Edit" in the left window.
Scroll to the bottom of the right window,
and the next to last icon is what you want to drag to your toolbar.
For a "Command Reference Guide" between XL03 and XL07:
http://tinyurl.com/yrj88r
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"Lucian Cornea" <Lucian
wrote in message
...
Hi,
When you apply a filter in an Excel 2007 sheet and wish to change only data
in visible cells you need to select visible cells only. This can be done by
"Ctrl+G", Special and then "Select visible cells only". - This is too much
to
do. Is there any way that you can set that option to default so everytime
you
select under a filter Excel to select just the visible cells?