A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How can i invert the selection of cells in Microsoft Excel 2007



 
 
Thread Tools Display Modes
  #1  
Old October 9th, 2009, 04:15 PM posted to microsoft.public.excel.worksheet.functions
heya
external usenet poster
 
Posts: 1
Default How can i invert the selection of cells in Microsoft Excel 2007

Like i select A1, then all other cells are selected except A1.
  #2  
Old October 9th, 2009, 04:46 PM posted to microsoft.public.excel.worksheet.functions
Luke M
external usenet poster
 
Posts: 2,672
Default How can i invert the selection of cells in Microsoft Excel 2007

You can't. If you start to think about it, it would cause enormous
complications, like, what cell then becomes the active cell? How does it
handle selecting groups (continous/discontinuous)?

Curious, why did you want something like that?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"heya" wrote:

Like i select A1, then all other cells are selected except A1.

  #3  
Old May 17th, 2010, 09:40 PM posted to microsoft.public.excel.worksheet.functions
Marc Gagnon
external usenet poster
 
Posts: 1
Default apply/erase formatting, clear content, ...

Let me jump in ...

This option can be very useful just to apply/erase formatting, clear content, convert data, ...



Luke M wrote:

You cannot. If you start to think about it, it would cause enormous
09-Oct-09

You cannot. If you start to think about it, it would cause enormous
complications, like, what cell then becomes the active cell? How does it
handle selecting groups (continous/discontinuous)?

Curious, why did you want something like that?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"heya" wrote:

Previous Posts In This Thread:

On Friday, October 09, 2009 11:15 AM
heya wrote:

How can i invert the selection of cells in Microsoft Excel 2007
Like i select A1, then all other cells are selected except A1.

On Friday, October 09, 2009 11:46 AM
Luke M wrote:

You cannot. If you start to think about it, it would cause enormous
You cannot. If you start to think about it, it would cause enormous
complications, like, what cell then becomes the active cell? How does it
handle selecting groups (continous/discontinuous)?

Curious, why did you want something like that?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"heya" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Entity Framework 4.0 and the AJAX Autocomplete Extender.
http://www.eggheadcafe.com/tutorials...rk-40-and.aspx
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:37 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.