Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
How do I stop all cells from being selected in excel? | Excel Discussion (Misc queries) | |||
HOW DO I DISPLAY ZERO VALUES IN SELECTED CELLS IN EXCEL. | Excel Discussion (Misc queries) | |||
Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
changing the way Excel displays selected cells | Excel Discussion (Misc queries) |