Set Column Widths
When you create a worksheet, Excel automatically sets a default width for columns. The width of columns in the Windows version of Excel is 8.43 characters (or 64 pixels). The width of columns in the Mac OS version of Excel is 10 characters (or 1.04 inches).
We've already used the AutoFit feature to increase the width of column A so its text fits in the column. And, if you use the Windows version of Excel, you may have noticed that it widened one or two columns to accommodate the number formatting we applied.
Now we'll make column A a little wider again—remember, we increased the text size and applied bold formatting, which make the text take up more space. We'll also set the width of columns B, C, D, and E to a consistent wider ...
Get Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
