JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,687
- Office Version
- 365
- Platform
- Windows
The default property for text boxes is "Move and size with cells". That is, if I add, delete, or resize a row or column, any text boxes will probably get moved and/or resized.
I just discovered that this also applies to charts. I just had a very carefully and painfully crafted chart all screwed up because I moved some rows behind it. GRRRRRRRRrrrrrr.
I have 2 questions:
1. What percentage of the time do workbook authors want this behavior as opposed to the opposite, which is not to move or resize with cells? My guess is less that 5%. Maybe less than 1%. I know I NEVER want it.
2. In excel 2007, there was no way to change this default. Is there in Excel 365?
I don't have much of a problem with this being the default as long as the geniuses at M$FT provide me with an option to change it. I mean the default, not the setting for a particular object.
Thanks, and sorry for the rant. Excel is so infuriating. It's like that old sexist joke men used to say about women, that they can't live with or without them.
I just discovered that this also applies to charts. I just had a very carefully and painfully crafted chart all screwed up because I moved some rows behind it. GRRRRRRRRrrrrrr.
I have 2 questions:
1. What percentage of the time do workbook authors want this behavior as opposed to the opposite, which is not to move or resize with cells? My guess is less that 5%. Maybe less than 1%. I know I NEVER want it.
2. In excel 2007, there was no way to change this default. Is there in Excel 365?
I don't have much of a problem with this being the default as long as the geniuses at M$FT provide me with an option to change it. I mean the default, not the setting for a particular object.
Thanks, and sorry for the rant. Excel is so infuriating. It's like that old sexist joke men used to say about women, that they can't live with or without them.