Hello David, Have you tried, - select cell - grab cell handle at bottom right with mouse left click and hold - press and hold Ctrl key - drag mouse
That will produce a column that repeats the number in the highlighted cell. On Mon, Apr 27, 2020 at 1:08 PM David Deeks <prof.david.de...@gmail.com> 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! > > 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 > > -- Alan Boba CISSP, CCENT, ITIL v3 Foundations 2011