Re: Numbers automatically advance in spreadsheet columns
Thanks for this - a really useful suggestion! David D On Tue, 28 Apr 2020, 04:50 Jean Lear, 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 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 > > > > >
Re: Numbers automatically advance in spreadsheet columns
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 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 > >
Re: Numbers automatically advance in spreadsheet columns
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
Re: Numbers automatically advance in spreadsheet columns
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 > 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
Re: Numbers automatically advance in spreadsheet columns
TNX Alan: I had experienced same as David did; now I know that I must hold Ctrl key to repeat the number while dragging the mouse pointer. Regards, and please ALL, stay safe. VinceB. On 4/27/2020 1:13 PM, Alan B wrote: 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 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
Re: Numbers automatically advance in spreadsheet columns
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
Re: Numbers automatically advance in spreadsheet columns
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 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
Numbers automatically advance in spreadsheet columns
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