On 15/02/2009 11:39, Dotan Cohen wrote:
I have a file open in OOo 3.0, that has many columns with no data in
any of their cells with the exception of cell 1* (because the columns
have titles). How can I easily remove the blank columns?
Don't know if this is the easiest but ...
1. Add an extra row, at the bottom of the data, containing the numbers
1, 2, 3, 4, ... This will be used to remember the original order of the
columns.
2. Sort the range using options:
- no headers ("labels") in data
- sort by columns
- sort on row 2
This will put all the "empty" columns after all the non-empty ones
3. Select and delete the range of empty columns; this is now easy as the
empty columns constitute a single range and are thus easily selected:
select first column, hold down Shift key, select last column.
4. Sort the data again using the same options as above but specifying as
the row to sort by the "numbered" row you added in #1. This puts the
non-empty columns back in their original order.
5. Delete the "numbered" row
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
