ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to get back my selected cells ? (https://www.excelbanter.com/excel-discussion-misc-queries/102616-how-get-back-my-selected-cells.html)

[email protected]

How to get back my selected cells ?
 
I am working with Microsoft Excel 2003, performing selections on a
worksheet with the CTRL key. After a few selections and still more to
select, I have inadvertently let go of the CTRL key while clicking in a
cell, thereby losing my previous selections.
Is there a way to get them back or do I have to re-start the tedious
selection exercise?


Gord Dibben

How to get back my selected cells ?
 
You don't have to use the CTRL key while clicking.

Hit SHIFT + F8 key to enter ADD mode.

Now just click to select cells.

Hit F8 twice to leave ADD mode.


Gord Dibben MS Excel MVP

On 1 Aug 2006 23:48:45 -0700, wrote:

I am working with Microsoft Excel 2003, performing selections on a
worksheet with the CTRL key. After a few selections and still more to
select, I have inadvertently let go of the CTRL key while clicking in a
cell, thereby losing my previous selections.
Is there a way to get them back or do I have to re-start the tedious
selection exercise?



Bob Phillips

How to get back my selected cells ?
 
Good one to know!

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
You don't have to use the CTRL key while clicking.

Hit SHIFT + F8 key to enter ADD mode.

Now just click to select cells.

Hit F8 twice to leave ADD mode.


Gord Dibben MS Excel MVP

On 1 Aug 2006 23:48:45 -0700, wrote:

I am working with Microsoft Excel 2003, performing selections on a
worksheet with the CTRL key. After a few selections and still more to
select, I have inadvertently let go of the CTRL key while clicking in a
cell, thereby losing my previous selections.
Is there a way to get them back or do I have to re-start the tedious
selection exercise?





Gord Dibben

How to get back my selected cells ?
 
Great for those of us with slippery fingers.

I just have to start eating somewhere else<g




On Wed, 2 Aug 2006 23:30:56 +0100, "Bob Phillips" wrote:

Good one to know!


Gord Dibben MS Excel MVP


All times are GMT +1. The time now is 11:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com