1st February 2001
Coming from the "Accelerating Excel" Department, Lockergnomie Stephen Blythe curtails a couple of cutting questions. Columns come in all shapes and sizes; I left "Corinthian" off my last list only because I couldn't fit it into natural discourse. Without electronic pilars, spreadsheets would be weak. As it is within the Windows Explorer, you can (left) double-click on a dividing line to auto-resize a column's width in Excel (to accommodate the longest string). Great! Now we have fourteen columns of varying lengths. Wouldn't you rather have them uniform? Select a range of columns, right-click on one of them, then choose the "Column Width" option. Enter a reasonable number and click the "OK" button. You can do the same thing with rows, too. While we're working with horizontal and vertical data, have you ever wanted to flip flop 'em? That is, take up-and-down data and turn it into left-to-right data? Copy a range, select its destination, then call the "Paste Special" function; be sure the "Transpose" option is checked.