| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Fill In not shut off.
We are using Windows XP and Excel 2003 - I have a shared workbook - and when
a task has been completed - we fill in the color for that row - just by highlighting the cells we want filled in and click on the fill in drop down button and choose a different color(other than yellow). The problem is when you go to type in the cells below that - and hit enter or tab - that cell is then filled with the same color. I have highlighted a few rows below it and click on the no fill option but it didn't work for long. Is there something we are doing wrong - or is it because we have filled in the last row in the list and it wants to fill in whatever is added after that. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Fill In not shut off.
<tools<options<edit {clear the "extend data range formats and formulas"
check box} "Shanny" wrote: We are using Windows XP and Excel 2003 - I have a shared workbook - and when a task has been completed - we fill in the color for that row - just by highlighting the cells we want filled in and click on the fill in drop down button and choose a different color(other than yellow). The problem is when you go to type in the cells below that - and hit enter or tab - that cell is then filled with the same color. I have highlighted a few rows below it and click on the no fill option but it didn't work for long. Is there something we are doing wrong - or is it because we have filled in the last row in the list and it wants to fill in whatever is added after that. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Fill In not shut off.
Thanks BJ - I will give that a try.
"bj" wrote: <tools<options<edit {clear the "extend data range formats and formulas" check box} "Shanny" wrote: We are using Windows XP and Excel 2003 - I have a shared workbook - and when a task has been completed - we fill in the color for that row - just by highlighting the cells we want filled in and click on the fill in drop down button and choose a different color(other than yellow). The problem is when you go to type in the cells below that - and hit enter or tab - that cell is then filled with the same color. I have highlighted a few rows below it and click on the no fill option but it didn't work for long. Is there something we are doing wrong - or is it because we have filled in the last row in the list and it wants to fill in whatever is added after that. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
| What settings do I use to allow Fill features to show in Excel | Excel Discussion (Misc queries) | |||
| My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
| In MS Excel, how do I fill in a column with the same cell from se. | Excel Worksheet Functions | |||
| Excel instance not shut down | Excel Worksheet Functions | |||
Linear Mode
