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
