Forum Discussion
Vanessa Guerrero
Nov 16, 2018Copper Contributor
Excel Shortcut
Are there any more efficient ways on changing the pixel width of a column other than dragging it with the arrow?
2 Replies
- Damien_RosarioSilver Contributor
In addition to Lorenzo Kim's suggestion, you can also highlight which columns you want to resize (e.g. use the CTRL key) and drag it wider or smaller. You can also right click onto the column headers and choose Column width.... You'll see all selected columns will resize at the same time.
If you want to adjust columns to the contents, double click onto the lines between the column headers (e.g. A | B) to autofit.
Have fun!
Cheers
Damien
- Lorenzo KimBronze Contributor
click <Column Width> then input desired width number
HTH