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

[heya]

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

 

[Luke M]

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?

 

[Marc Gagnon]

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 enormou
complications, like, what cell then becomes the active cell? How does i
handle selecting groups (continous/discontinuous)

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

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

:

Previous Posts In This Thread:

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

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 enormou
complications, like, what cell then becomes the active cell? How does i
handle selecting groups (continous/discontinuous)

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

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

:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Entity Framework 4.0 and the AJAX Autocomplete Extender.
http://www.eggheadcafe.com/tutorial...93a-b290f013f649/entity-framework-40-and.aspx