Thanks, Harold, but when paste, that will overwrite the existing data.... Best Regards! Tony Li
Before printing, think about Environmental Responsibility -----Original Message----- From: Harold Fuchs [mailto:hwfa.openoff...@googlemail.com] Sent: Monday, October 19, 2009 4:55 PM To: users@openoffice.org Subject: Re: [users] How to insert cut cells in Cacl 2009/10/19 Tony Li <tony...@viscountchina.com> > Dears, could somebody give the tips on how to insert cut cells in cacl, > > > > My requirement is: > > 1) Select on row / column in cacl, and click cut > > 2) Insert the cut row / column to another place like between column A > and column B without overwriting the content in column B. > > > 1. Select the row/column 2. Edit>Cut (or Right click>Cut) 3. Select the row/column *before which* the data are to go 4. Right click the selected row/column 5. Insert Row/column 6. Edit>Paste (or Right click>Paste) Note that step #2 cuts the data but does not remove the column/row. That would need an extra step. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org