Wrap Text within column


#1

It would be helpful to be able to wrap text within a Formula, Single Line Text or a Long Text field if the column width on view is too small. (Rather than truncate the text)


#2

I need to clarify. My original request was for viewing. I subsequently found the “Fit to width” under print, which helps when printing, but not viewing. Just trying to be clear.


#3

While it could be interesting in some cases, I’d prefer it to be optional.


#4

Yep. I can see where this might always not be 'allowable"


#5

One workaround that might help you for the time being is to select the cell you’re interested in, then press Shift+Spacebar to open an expanded cell dialog. Then you can use arrow up/down keys to switch which row is selected and see all the text in the cell for that row.

The lack of wrapping text is an intentional design decision: to allow wrapping text, we would need to support variable row heights. Our rows are a consistent height in order to avoid the bloated mega-rows that you often find in spreadsheets. Generally, we believe that that table/grid view should be a good overview of a number of different records, whereas the expanded record view gives you the details.

Based on the amount of user feedback on this point, we may offer the ability to change the row height at some point. Alternatively, we might look into a non-grid view that shows each record as a card rather than a row, and this “card view” might support multiline text in a way that would enable you to fit more text information on a single card without having to expand it.

Out of curiosity, how would wrapping text fit into your personal workflow? Do you like to scroll down the table row by row in order to view the content? How many lines of text do you need to be visible—just a couple of lines, whole paragraphs, or multiple paragraphs? Do you need to scan through/read multiple cells at a time, or do you just need to quickly find an appropriate cell of interest and read it, without going to the trouble of expanding it?


#6

Katherine. Honestly, I think its a matter of our users being so used to XCEL. We are a community theater with one full time employee and 3 part time. Much of the work of running the theater depends on volunteers. Years ago, one volunteer was an astute spreadsheet user. We run the theater almost entirely using spreadsheets they built… Lots of them. So, our staff and volunteers are familiar with how they work. Any change is not insurmountable, but would require training and familiarization of the new way. These are often obstacles to adopting new/different technologies. I suspect you’ve heard this before. It is perhaps a minor matter, but with scroll wheels making scrolling up and down on a spreadsheet to read a wrapped column, it seems like more clicks to scroll to the enlarge button and have to click it to then see the full text. Again, a matter of what you have been using a long time.

Thanks for your thoughtful reply.


#7

I like the design decision to keep things clean by not wrapping text, but I believe that power should be in the hands of the users to decide if they want to wrap text and have variable height rows or not. If it was a feature that could be switched on or off by each user per table (and not affect other users’ view of that table), that would be ideal. I have certain tables where I and others on my team at work would prefer to see more information at a glance, rather than having to expand each record/cell to get at the details.


#8

I would like the column headings to be allowed to wrap - that would be helpful for explanations of what we’re seeing while not necessarily needing to see the full width of the colun


#9

Kelly, you may find adding field descriptions useful—it’ll allow you to add mouseover descriptions to columns so you don’t have to expand the column width.


#10

I like @Kelly_pratt suggestion. Example – I have a buch of date fields that don’t need to be wider than the date itself, but it’s harder to identify the column because the title is truncated.

In my case in it wouldn’t be so much for an explanation but for ID. I’m sorry I can’t :heart: your suggestion @Katherine_Duh because a) it requires hover so no good for overview, b) it obscures the next column (again not good for overview), c) it takes a bit to show even on hover so no good for quick ID.

If the column headers could wrap to a second row it could help reduce the width of columns without adding excessively intrusive vertical space. Would be happy if there was such an option vs wrap/nonwrap as standard behavior. Or if we could choose to reduce the heading size? [meant heading font size]


#11

ditto to everything you said.


#12

This, I think a limit on the number of wraps would likely solve the headache for most people while still keeping the design looking good.


#13

Plus one for the option to allow column headings to be able to wrap or truncate. All of the reasons that are listed above, but mostly for the ability to have two word column names for single digit fields without wasting 30-40% of the screen real estate. I’ve got a 27" Apple Cinema Display and I can fit 14 columns, but most of my tables are >20. I’d be able to fit a lot of my tables on screen at once without having to hide columns if the column headers wrapped.


#14

I totally concur with Aaron on this. We are very impressed with the Airtable functionality but the waste of “screen real estate” caused by non-wrapping column headers is annoying. Thank you for fixing this ASAP.


#15

Agreed, start with filed/column headers.


#17

@Airtable_Support @Airtable_Team can you please respond to this thread with thoughts on priority and timing for this feature? This is frankly the only limitation keeping me from using AirTable for a really big client.

Thanks!


#18

Please include this feature. I have to work in Numbers/Excel and then upload them once they’re done instead of working within airtable. It’s a basic spreadsheet tool and messes up the design for the user. Please respond. I am trying to introduce airtable to a client and that was a major roadblock for them being serious spreadsheet viewers. Thank you!


#19

I would add that the hide column drop down does not offer any respite from this as it neither stretches to accommodate long names or wraps text - opting instead to abbreviate a long column name only with an unhelpful if it does not fit in the fixed width of the dialogue. This makes identifying and sorting columns very difficult, a must if they are prone to running off screen for width.

I am mostly on board with the decision to keep fixed row heights in grid-view records, long text field types,card views and expanded records soften all of that, but the options are only two with long field titles, stretch the row or use short names.

one note…
If adding width responsiveness or text wrapping to the hide fields drop-down is unpalatable, how about just a tool-tip?


#20

I agree with other posts on this thread. My company would benefit greatly from using a wrap text feature. I would like to see an overview of the cell at a quick glance, without having to click into each cell to expand. That’s a waste of time in my opinion. And, without clicking into each cell, sometimes it’s hard to know if there is more info in a cell or not… so info may be missed, which is upsetting.

Although, I like the option to expand the cells, for other reasons, I would like to have the option to wrap the text in each cell as well. I think it should be a user’s choice.


#21

I would love text wrap in cells. Personally I find Airtable very annoying without this feature. I want to see everything at a quick glance. Instead I have to click to see it or make the entire column wide when only 1 cell in the whole column has more in it. It’s hard to recommend Airtable to others with this missing.