Hello Everyone,
I am currently using Excel 2000 and I was wondering if there was a way to copy how cells are merged in a row when inserting new rows.
For example if you have a row that has a certain color fill say yellow and the next cell does not have a color fill it is white and you select it (the white cell) and use the insert row tool, Excel will create a new row and it will be yellow.
But
Lets say Column A and B are merged together and you use the "Insert Row" tool, Excel will create a new row, but this new row will not have Column A and B merged anymore, they will be separate.
Does anyone know of a way (some kind of setting) that will allow you to copy the merged cells from the row above when inserting new rows?
I have found a couple solutions but they aren't as smooth as I would like, I would like this to just happen automatically as stated above.
Methods I have found...
1.) There is a Merge Across tool that allows you to highlight multiple row/columns and it will merge just the rows.
2.) You can copy the merged cells (if they are blank) and paste them
I am sure there a macro can fix it, but I don't know if it would be worth it (I am still willing to try a macro if someone has one already made, but it may be more complicated then it is worth to apply it), I am hoping for a simple setting somewhere, but I don't think there is one for this?
If anyone has any ideas, please share.
Thank You to anyone who reads this.
I am currently using Excel 2000 and I was wondering if there was a way to copy how cells are merged in a row when inserting new rows.
For example if you have a row that has a certain color fill say yellow and the next cell does not have a color fill it is white and you select it (the white cell) and use the insert row tool, Excel will create a new row and it will be yellow.
But
Lets say Column A and B are merged together and you use the "Insert Row" tool, Excel will create a new row, but this new row will not have Column A and B merged anymore, they will be separate.
Does anyone know of a way (some kind of setting) that will allow you to copy the merged cells from the row above when inserting new rows?
I have found a couple solutions but they aren't as smooth as I would like, I would like this to just happen automatically as stated above.
Methods I have found...
1.) There is a Merge Across tool that allows you to highlight multiple row/columns and it will merge just the rows.
2.) You can copy the merged cells (if they are blank) and paste them
I am sure there a macro can fix it, but I don't know if it would be worth it (I am still willing to try a macro if someone has one already made, but it may be more complicated then it is worth to apply it), I am hoping for a simple setting somewhere, but I don't think there is one for this?
If anyone has any ideas, please share.
Thank You to anyone who reads this.