Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
When I double-click the right border of a column's header, the column will be resized according to the largest width of all its cells.
How can I do that resize instead according to the width of the contents of a selected cell?
How to simply (automatically) resize column to width of selected cell?
I don't think there's any way of automatically resizing cells based on their contents that doesn't involve script. However if you know the width of a particular cell (perhaps by temporarily copying it into an empty column, double clicking on the column header border as you already have done, then right clicking on the column header and selecting 'resize column' to view the numerical value of the column width) and wish to apply that more widely, then you can bulk-resize columns to that size by clicking on their headers whilst holding Ctrl, then right click on any of the selected headers, select 'resize columns' and enter the appropriate width in the box.
