As a regular user of Calc in Apache OpenOffice I have added two extra items to my tool bar (another learning curve to do this). I have added 'Fill Down' and 'Fill Series' Fill Series will bring up the Fill Series window which allows a lot of alternatives for what is being done in the column or row selected. Fill down is also useful to repeat text down a number of rows. Hope this extra information helps. Jean
On Tue, Apr 28, 2020 at 4:27 AM Peter Kovacs <leg...@posteo.de> wrote: > 1) Mark the Cell > > 2) Right Klick -> select copy > > 3) select first Cell of your row. (i.e. the cell below) > > 4) Press shift And mark the last cell -> you now see the rows that you > target marked. > > 5) right click select copy. > > > Am 27.04.20 um 19:08 schrieb David Deeks: > > I have been an Open Office user for many years, but only recently > discovered this group, and have already learned a couple of things! > > > > I am hoping however that someone can help with a specific and > longstanding problem with numbers in spreadsheet columns. If I have a cell > with a number in that I want repeated down the column, I would love to able > to simply highlight the cell and drag down the column. The problem is that > in each line the numbers always increase by 1. This is useful of course > sometimes, but not always! I have tried all formats, including text etc, > and feel as though I’ve looked through every menu - but cannot find how to > stop it doing this. I am sure there must be a way? > > > > Thanks > > > > David Deeks > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > > For additional commands, e-mail: users-h...@openoffice.apache.org > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > >