When using a Finder window in the Column view, you can double click a column divider to automatically resize it to the widest name in that column. This works whether your column is too wide or too thin and you need more room to fit all your file names.