Brian, Alan Thanks so much for your very prompt replies - problem solved!
Well pleased I discovered the group! All best David > On 27 Apr 2020, at 18:25, Brian Barker <b.m.bar...@btinternet.com.INVALID> > wrote: > > At 18:08 27/04/2020 +0100, David Deeks wrote: >> I have been an Open Office user for many years, but only recently discovered >> this group, and have already learned a couple of things! > > Only two? > > ;^) > >> 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! > > There are various ways to do this. > > o (As someone has already said) Use Ctrl+fill instead of normal fill. > > o Enter the same number again in the cell immediately below the original. > Select both cells. (Drag over them or use click and Shift+click). Now fill > down as usual. > > o Select the entire range you want filled - including your original cell. Go > to Edit | Fill > | Down. > > o For more complex requirements, select the entire range and use Edit | Fill > > | Series... . > > I trust this helps. > > Brian Barker > > > --------------------------------------------------------------------- > 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
