2008/5/12 Dotan Cohen <[EMAIL PROTECTED]>: > 2008/5/12 Henning von Roeder <[EMAIL PROTECTED]>: > > Left-click the field, where the row-numbering and the column-lettering > > meet. Then pul the mouse over one of the column letters and right > > click. On the pop-up select column width. Now you can change the > > width of all the columns. If you just want to change the width of on > > column, select just the column you want, by left clicking on it's > > letter, and then do the same thing. > > > > The OP was very specific in saying that he does not want to change the > width of all the columns, only the width of columns that have not yet > been changed. This is a great question and is one of the small > annoyances in Calc that is hard to identify yet make the program > unfriendly. > > Real life scenario illustrating OP's concern: > Opening a particular Calc document containing ME information with 144 > columns, the column widths are by default 0.89", with the exception of > the 64 columns that the user had widened to 3" to suit the data. Now, > a coworker needs to see the document and decides that the column > widths are too small, which makes the document difficult to read. She > wants the width default to be 1.5", but of course she does not want to > resize the 64 wided columns. How is this done? > > To the OP: What spreadsheet program do you use that has this > functionality? How is this done in that program? > > Dotan Cohen > > <http://what-is-what.com>
You can do this. How convenient it is depends on exactly how the "64 widened columns" are distributed within the sheet: 1. Left click on the letter of the first column to be changed. 2. Select the columns to be changed: a) If the columns to be changed are contiguous, hold down the Shift key and left click on letter of the last column to be changed - all the columns from first clicked to last clicked inclusive will be selected; b) if the columns are not contiguous, hold down the Ctrl key and then left click on each column's letter in turn - again, all of them will be selected. c) you can select a disconnected set of contiguous regions e.g c-f, h-j, x-z with judicious use of the Shift and Ctrl keys. 3. Right click on the letter belonging to one of the selected columns and choose Column Width. Change it to what you want and click OK. You can also deselect a few columns by selecting all of them and applying the above procedure - left clicking a column's letter is a toggle: it selects an unselected column and deselects a selected one. To select all the columns, either click in the field where colum letters and row numbers meet (as described in the previous e-mail) or by using Edit>Select All or by hitting Ctrl-A. The principle here is that changing the column width (#3) affects all *selected* columns. This is perhaps not 100% what is wanted because the width of *new* columns will not be what you set at #3 above. But I think it's close ... -- Harold Fuchs London, England Please reply *only* to [email protected]
