Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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?

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default 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?




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a new Excel file with selected cells john Excel Discussion (Misc queries) 2 July 18th 06 12:28 AM
A validated List which link to selected cells according to what is selected on the list WL Excel Worksheet Functions 1 June 5th 06 08:52 PM
Excluding selected cells in excel Farhad Excel Discussion (Misc queries) 3 May 29th 06 08:45 PM
Selected cells: item count versus summation Neal Zimm Excel Discussion (Misc queries) 3 October 9th 05 02:30 PM
Autosum returns an incorrect zero value on the selected cells trying hard Excel Worksheet Functions 4 August 25th 05 11:06 AM


All times are GMT +1. The time now is 08:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"