Forum Discussion
About the truncation of text inside a shape like popup in Excel
We are using some shape with texts to pin some direction or notice inside an excel document.
However, the display method (especially the text truncation) of those texts can be very different from computers.
This is to say, when my colleague opens an excel file which displays normally in my computer in his/her computer, many of texts are truncated.
This can be quite confusing, especially when those files may be delivered to our clients.
Every times I need to rework with such documents, enlarging the shapes and hope this may be enough to be displayed in other devices.
I'd like to know, if there are some methods or options to avoid this, at least to keep the same display method in me and my colleagues' computer (We are all using the latest Office 365 edition Excel)?
Does this related to excel version, system version, or the scale setting of monitor / excel?
Regards.
zhaoli777 Try this:
Once done with all your shapes follow these steps (I assume there are only shapes on the sheet like the ones your screen-shot shows, so no charts or other objects)
- Press F5, click Special, select Objects and click OK (this selects all shapes)
- Right-click any of the shapes, choose "Format shape"
- In the task-pane, click Text Options:
- Click the Textbox icon:
- Click "Resize shape to fit text":
2 Replies
zhaoli777 Try this:
Once done with all your shapes follow these steps (I assume there are only shapes on the sheet like the ones your screen-shot shows, so no charts or other objects)
- Press F5, click Special, select Objects and click OK (this selects all shapes)
- Right-click any of the shapes, choose "Format shape"
- In the task-pane, click Text Options:
- Click the Textbox icon:
- Click "Resize shape to fit text":
- Thanks for the quick reply. It seems to be worked, and I'll test it again with my colleagues tomorrow!
