Now you should be a pro at using the Text-To-Columns feature in Excel! If you’re interested in learning all of Excel, I developed a business-focused course on mastering the 20% of Excel used for 80% of your work (including a whole module on cleaning, manipulating and analyzing data sets!). Type a width value in the 'Column Width' text box and click 'OK' to resize the columns. Let’s take a sample CSV file and walk through the steps to convert delimited text files to spreadsheets. The screenshot below shows a jumble of comma separated values in a Notepad file. Microsoft Excel can help turn this confused jumble into neat rows and columns.
On a PC this is Alt+O,C,A, as explained here.
Is there an equivalent keyboard shortcut in Excel for Mac, to fit the column width to the width of the text?
I'm using the 2011 version.
2 Answers
Although Microsoft did not include many keyboard shortcuts in their Office Suite for Mac, you can make your own for any app including Office apps. To do so:
- Go to System Preferences and then Keyboard.
- Select the shortcuts tab.
- You can add any shortcut there either system-wide for any application or application specific by clicking the Plus button +, selecting Excel and recording your key combination.
Text To Columns
In this case you must type in AutoFit Selection just as it appears on the menu in Excel. (Format > Column > AutoFit Selection)
You can choose any key combination that suits your fancy.
Sorry if may sound slightly off the topic, but for ease,
- Cmd ⌘ + A
- Double click (mouse) on any column divider on top
This gives autofit column width of an active worksheet. To avoid any potential overlapping shortcuts.