Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Hi,
Is it possible to ensure that wrap text is assigned at all times on a sheet? I seem to be adding lots of detail to numerous rows and I have to constantly select the wrap text icon for each row - it would save time if wrap text could be applied to all rows on a sheet.
Thanks
Tom
Hi Tom,
There isn't currently a way to apply formatting options to an entire sheet without selecting all the cells. When you have a moment, submit an enhancement request using the form under Quick links on the right of the community site.
As a workaround, it may be easier to apply the Wrap Text feature to your columns, which will apply it to all cells in that column. To do this, select the column header and user the Wrap Text button in the toolbar.
As I test I selected the first column + Shift + select the last column and I can toggle word wrap across all the columns. While not allowing it to be on by default you can toggle it whole columns at a time.