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?

1 Answer 1


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.