Thanks for this - a really useful suggestion! David D
On Tue, 28 Apr 2020, 04:50 Jean Lear, <meld...@gmail.com> wrote: > 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 > > > > >