| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| does ctrl f select cells randomly? | Excel Discussion (Misc queries) | |||
| Ctrl Key to Select Cells | Excel Discussion (Misc queries) | |||
| select only used rows and only visible cells | Excel Discussion (Misc queries) | |||
| how do I select, cut, and paste visible cells only | Excel Discussion (Misc queries) | |||
| Select Visible Cells Only | Excel Discussion (Misc queries) | |||
Threaded Mode
