Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Entire Row
I have recently purchased the full version of Office 2007 Professional after
having a most enjoyable few weeks using the Beta Version. One feature I found particularly useful was the "Format Entire Row" option when using conidtional formatting. Upon installing the full version today, i have found that this option no longer appears in the dialogue box. Has this feature been omitted from the full release? Regards, Mike Walker |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Entire Row
I have just looked, and it doesn't seem to be. But it is simple enough, just
select the whole row and apply the CF, making the cell reference absolute if appropriate. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "MWalker56" wrote in message ... I have recently purchased the full version of Office 2007 Professional after having a most enjoyable few weeks using the Beta Version. One feature I found particularly useful was the "Format Entire Row" option when using conidtional formatting. Upon installing the full version today, i have found that this option no longer appears in the dialogue box. Has this feature been omitted from the full release? Regards, Mike Walker |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Entire Row
What a strange thing to do, that little tick box saves a lot of formula
writing time! "Bob Phillips" wrote: I have just looked, and it doesn't seem to be. But it is simple enough, just select the whole row and apply the CF, making the cell reference absolute if appropriate. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "MWalker56" wrote in message ... I have recently purchased the full version of Office 2007 Professional after having a most enjoyable few weeks using the Beta Version. One feature I found particularly useful was the "Format Entire Row" option when using conidtional formatting. Upon installing the full version today, i have found that this option no longer appears in the dialogue box. Has this feature been omitted from the full release? Regards, Mike Walker |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Entire Row
Does seem odd, because the manual solution is not intuitive to most Excel
users. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "MWalker56" wrote in message ... What a strange thing to do, that little tick box saves a lot of formula writing time! "Bob Phillips" wrote: I have just looked, and it doesn't seem to be. But it is simple enough, just select the whole row and apply the CF, making the cell reference absolute if appropriate. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "MWalker56" wrote in message ... I have recently purchased the full version of Office 2007 Professional after having a most enjoyable few weeks using the Beta Version. One feature I found particularly useful was the "Format Entire Row" option when using conidtional formatting. Upon installing the full version today, i have found that this option no longer appears in the dialogue box. Has this feature been omitted from the full release? Regards, Mike Walker |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I FORMAT AN ENTIRE WORKBOOK ALL AT ONCE? | Excel Worksheet Functions | |||
how do I copy an entire worksheet to another with text & format? | Excel Discussion (Misc queries) | |||
Help with application of custom format to entire column | Excel Discussion (Misc queries) | |||
Conditional Format Not Working | Excel Discussion (Misc queries) | |||
format an entire column to contain checkbox activex control | New Users to Excel |