Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Color is added to additional rows
I'm using Excel 2007, and I've got a rather odd problem and do not know the
explaination for it. I'm adding information to an already constructed list and as I add information to a row, I am filling the row in yellow so I will know later which rows have added information. However, in addition to the rows I've added information to, I now have some rows where, cells that I do not have anything typed, are filled in yellow. What is causing this odd issue? I have not deleted any rows or cells in this sheet at all so I know it's not just a mis-alignment issue. Thanks for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Color is added to additional rows
Have you set this up as a 'table'? If so if you even temporarily 'add' a
row' it will add the formatting from above too. Just a thought -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Historian" wrote in message ... I'm using Excel 2007, and I've got a rather odd problem and do not know the explaination for it. I'm adding information to an already constructed list and as I add information to a row, I am filling the row in yellow so I will know later which rows have added information. However, in addition to the rows I've added information to, I now have some rows where, cells that I do not have anything typed, are filled in yellow. What is causing this odd issue? I have not deleted any rows or cells in this sheet at all so I know it's not just a mis-alignment issue. Thanks for any help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Color is added to additional rows
A colleague took one look at my spreadsheet and figured out the problem. I'm
not sure if it's set up as a table or not. But what occured was that I added the fill and then sorted based on the column I added information to so that the cell with the new information and the fill would be added to the same area of the spreadsheet as previous cells with the same information. When I did the sort, it would sort based on the columns of data I've got, but then that's where the selection would end, leaving "extra" cells with the fill applied that stayed in the same position even though the cells with the data were moved. "Nick Hodge" wrote: Have you set this up as a 'table'? If so if you even temporarily 'add' a row' it will add the formatting from above too. Just a thought -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Historian" wrote in message ... I'm using Excel 2007, and I've got a rather odd problem and do not know the explaination for it. I'm adding information to an already constructed list and as I add information to a row, I am filling the row in yellow so I will know later which rows have added information. However, in addition to the rows I've added information to, I now have some rows where, cells that I do not have anything typed, are filled in yellow. What is causing this odd issue? I have not deleted any rows or cells in this sheet at all so I know it's not just a mis-alignment issue. Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ADDITIONAL FILL COLORS EXCEL | Excel Discussion (Misc queries) | |||
Additional rows added to spreadsheet when opening text files | Excel Discussion (Misc queries) | |||
Apply fomulas to additional worksheets as added | Excel Discussion (Misc queries) | |||
Excel gridlines disappear when color is added | Excel Discussion (Misc queries) | |||
Automatically insert fill colour when data is added? | Excel Worksheet Functions |