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
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
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
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
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
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
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
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
