| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deselect a cell in a discontiguous range
If I select a range of discontinuous cells (I.E. A1, A3, A5, A8), how can I
deselect "A5" withouth deselecting all cells and then having to then select all cells except "A5"? (This scenario is vastly simplified). Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deselect a cell in a discontiguous range
bad luck!
workaround: http://www.cpearson.com/excel/UnSelect.aspx -kc *Click YES if this helps "Excel_VBA_Newb" wrote: If I select a range of discontinuous cells (I.E. A1, A3, A5, A8), how can I deselect "A5" withouth deselecting all cells and then having to then select all cells except "A5"? (This scenario is vastly simplified). Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deselect a cell in a discontiguous range
This is how to solve it programatically; I'm wondering if there is a
keystroke to accomplish this? "KC" wrote: bad luck! workaround: http://www.cpearson.com/excel/UnSelect.aspx -kc *Click YES if this helps "Excel_VBA_Newb" wrote: If I select a range of discontinuous cells (I.E. A1, A3, A5, A8), how can I deselect "A5" withouth deselecting all cells and then having to then select all cells except "A5"? (This scenario is vastly simplified). Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deselect a cell in a discontiguous range
You assign said keystroke to the macro.
Excel_VBA_Newb wrote: This is how to solve it programatically; I'm wondering if there is a keystroke to accomplish this? "KC" wrote: bad luck! workaround: http://www.cpearson.com/excel/UnSelect.aspx -kc *Click YES if this helps "Excel_VBA_Newb" wrote: If I select a range of discontinuous cells (I.E. A1, A3, A5, A8), how can I deselect "A5" withouth deselecting all cells and then having to then select all cells except "A5"? (This scenario is vastly simplified). Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I select a cell in Excel I cannot deselect it. Ideas? | Excel Discussion (Misc queries) | |||
| Is it possible to plot discontiguous cells? | Charts and Charting in Excel | |||
| Is it possible to plot discontiguous cells? | Excel Discussion (Misc queries) | |||
| deselect rows | Excel Discussion (Misc queries) | |||
| ActiveChart.Deselect won't Deselect | Charts and Charting in Excel | |||
Linear Mode
