I rarely ever post on forums like this because I can usually find an answer via Google where someone has already asked the same question, but in this case I have searched quite a bit and am not finding an answer.
My question is in regard to a perceived changed behavior in Excel that I assume is a recent change, although I can't say for sure in which version this started happening.
Say I have a worksheet where I have cells A1:A3 all merged. If on this worksheet I select the entire row 2, right click, and choose Delete:
The same goes for deleting columns if some range is merged across columns.
Also, similar for inserting rows (or columns). Previously, inserting a row (or column) between merged cells would just expand the merged content to include the added row(s) or column(s). Now, it inserts before the start of the merged range, and it inserts the number of rows that you have in the merged range. So, in my example, if I would have inserted row by selecting row 2 and right click, insert, it would insert 3 rows above my merged range, and my merged range would now be A4:A6 since 3 rows got inserted above the range.
Is there anyway to go back to the way it behaved that I remembered in the past? Like a setting or a different way of inserting or deleting that I could do?
And yes I realize that there isn't a ton of benefit to merging cells, but it's a habit I have gotten into when writing audit documentation that I'm used to and prefer not to break if there are any options!
My question is in regard to a perceived changed behavior in Excel that I assume is a recent change, although I can't say for sure in which version this started happening.
Say I have a worksheet where I have cells A1:A3 all merged. If on this worksheet I select the entire row 2, right click, and choose Delete:
- Current behavior: The entirety of the merged cells A1:A3 ALL get deleted.
- Past behavior: Only row 2 would be deleted, and the merged range would shrink to now be just A1:A2
The same goes for deleting columns if some range is merged across columns.
Also, similar for inserting rows (or columns). Previously, inserting a row (or column) between merged cells would just expand the merged content to include the added row(s) or column(s). Now, it inserts before the start of the merged range, and it inserts the number of rows that you have in the merged range. So, in my example, if I would have inserted row by selecting row 2 and right click, insert, it would insert 3 rows above my merged range, and my merged range would now be A4:A6 since 3 rows got inserted above the range.
Is there anyway to go back to the way it behaved that I remembered in the past? Like a setting or a different way of inserting or deleting that I could do?
And yes I realize that there isn't a ton of benefit to merging cells, but it's a habit I have gotten into when writing audit documentation that I'm used to and prefer not to break if there are any options!