0
votes
2answers
312 views

Set Width of Multiple Column in Excel

I have a bunch of columns on a worksheet, these columns do not have the same width, But all these columns must have in total a given width. How can I do that, keeping the ratio? So I have this: ...
0
votes
4answers
8k views

Is there a shortcut in excel that will expand the column width to show the entire column header

Is there a shortcut in excel that will expand all the column width(s) to show the entire column header as well as complete column data. Now I need to go to each and every column in the excel sheet and ...
26
votes
4answers
50k views

Howto expand all columns in Excel spreadsheet?

I have a spreadsheet with many columns. The columns are all a small standard width. Double-clicking the partition line between columns will expand the column width to encompass the longest string in ...