Ask Your Question

Hi,How can I print also the numbers in libreoffice Calc?

asked 2020-03-25 15:17:35 +0200

When using Calc on the left side appaears everytime with each new row a number. For example 1 before it. The second row number 2 for it. By printing the file the numbers wont be printed standad with it. How can I make it so, that the numbers will be printed also? Kind regards, Erik

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-03-25 15:50:02 +0200

Opaque gravatar image

updated 2020-03-25 16:38:35 +0200


you can't print row numbers only (by an option setting), but you can activate option Format -> Page -> Tab: Sheet -> Section: Print -> Option: [X] Column and row headers, which would result in column letters and row numbers to be printed.

If you want row numbers only, you need to add =ROW() into the first column of your print range.

Hope that helps.

If the answer helped to solve your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more


Thanks! This works. Kind regards, Erik gravatar ( 2020-03-26 09:39:03 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-03-25 15:17:35 +0200

Seen: 14 times

Last updated: Mar 25