Thread: How can you select visible cells only by default, without Ctrl+G.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lucian Cornea Lucian Cornea is offline
external usenet poster
  
Posts: 1
Default How can you select visible cells only by default, without Ctrl+G.
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?
Reply With QuoteReply With Quote