| View previous topic :: View next topic |
| Author |
Message |
wood1e
General User
Joined: 09 May 2008
Posts: 9
|
 Posted: Fri May 09, 2008 4:16 am Post subject: copy and paste dragging mouse |
 |
|
Hi, I want to be able to copy and paste by selectig the source cell then dragging the mouse to paste in the blank cells, This I know how to do what I don't know is how to adjust paste so in the case of dates, I can tell paste to be one month advanced on source cell.
So 01/01/01 in next cell pasted is 01/02/01
Cheers |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Fri May 09, 2008 4:18 am Post subject: |
|
|
Select the first value and the adjacent blank ones.
Menu:Edit>Fill>Series...Time unit: [X]Months
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
|
