Excluding selected cells in excel
 

Hi

I have worked with Open office and like one of its features. You can select
all the cells once, exclude a number of cells, and apply the format to
selected area. But it seems that you can not exclude a selected cell in excel.
How can i do this in Excel?

Thanks

Excluding selected cells in excel
 

There's nothing built into excel that allows for this.

But you could just be careful when you selected the multiple areas to avoid the
cells you want to avoid.

Farhad wrote:

Hi

I have worked with Open office and like one of its features. You can select
all the cells once, exclude a number of cells, and apply the format to
selected area. But it seems that you can not exclude a selected cell in excel.
How can i do this in Excel?

Thanks

--

Dave Peterson

Excluding selected cells in excel
 

Ever notice that in Windows Explorer, in the <Edit menu, there's an option
to "Invert Selection".

Too bad it's not included in the other apps.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Dave Peterson" wrote in message
...
There's nothing built into excel that allows for this.

But you could just be careful when you selected the multiple areas to
avoid the
cells you want to avoid.

Farhad wrote:

Hi

I have worked with Open office and like one of its features. You can
select
all the cells once, exclude a number of cells, and apply the format to
selected area. But it seems that you can not exclude a selected cell in
excel.
How can i do this in Excel?

Thanks

--

Dave Peterson

Excluding selected cells in excel
 

If it's really important, you could use a macro from Chip Pearson:

http://www.cpearson.com/excel/unselect.htm



Ragdyer wrote:

Ever notice that in Windows Explorer, in the <Edit menu, there's an option
to "Invert Selection".

Too bad it's not included in the other apps.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Dave Peterson" wrote in message
...
There's nothing built into excel that allows for this.

But you could just be careful when you selected the multiple areas to
avoid the
cells you want to avoid.

Farhad wrote:

Hi

I have worked with Open office and like one of its features. You can
select
all the cells once, exclude a number of cells, and apply the format to
selected area. But it seems that you can not exclude a selected cell in
excel.
How can i do this in Excel?

Thanks

--

Dave Peterson

--

Dave Peterson