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

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

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

To invert the selection of cells in Microsoft Excel 2007, you can follow these steps:

1. Select the cell or range of cells that you want to exclude from the selection. In this case, select cell A1.
2. Press and hold down the Shift key on your keyboard.
3. Click on any other cell or range of cells that you want to include in the selection. This will add those cells to the selection while excluding the originally selected cell or range.
4. Release the Shift key.

Now you should have inverted the selection of cells in Excel 2007. All cells except the originally selected cell or range should be highlighted. You can then perform any desired actions on the selected cells, such as formatting or data entry.

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.

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