Ask Your Question

How to create increment number inside text on L.O. Calc sheet [closed]

asked 2017-12-25 11:57:36 +0100

fladramon gravatar image

updated 2017-12-25 13:05:55 +0100

hi, i want to do the "thing" that I drag the down-right symbol and numbers are being increasing

So we have this:
and I want to make multiple links but with the number 1 going like 1,2,3,4,5...

Result: . . . Or how i can add 3 cells into 1 so i can split the link into 3 cells

thanks in advance

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-25 00:19:18.490789

2 Answers

Sort by » oldest newest most voted

answered 2017-12-25 14:58:21 +0100

librebel gravatar image

Hello @fladramon,

In the first cell put the formula =HYPERLINK("" & ROW() & "/lalala"; "" & ROW() & "/lalala"), then drag the thingy downwards.

HTH, lib

edit flag offensive delete link more


The thingy is called a "fill handle" at

Jim K gravatar imageJim K ( 2017-12-26 21:25:21 +0100 )edit

answered 2017-12-25 17:59:42 +0100

fladramon gravatar image

Oh my... it worked! *Thank you so much librebel *, I wouldnt and couldn't think this formula

edit flag offensive delete link more


You're welcome @fladramon :D, i'm always glad if i could be of help.

With Regards, lib

librebel gravatar imagelibrebel ( 2017-12-26 00:53:49 +0100 )edit

@fladramon: This should be a comment on the question, not an answer. See guidelines for asking. Still, this was a good enough question that I upvoted it.

Jim K gravatar imageJim K ( 2017-12-26 21:21:59 +0100 )edit

Question Tools

1 follower


Asked: 2017-12-25 11:57:36 +0100

Seen: 1,190 times

Last updated: Dec 25 '17