Ask Your Question

Calc - Jump to Column by Index (integer not letters) [closed]

asked 2014-03-26 11:35:45 +0200

progrramster gravatar image

updated 2014-03-26 11:38:26 +0200

How does one jump to the nth column in LibreOffice Calc (spreadsheet) without having to try and convert the number 'n' to the corresponding alphabetical characters? E.g. in my case I would like to jump to the 79th column. If jumping to the column is not possible, is there a way to change the headers so that they display 1,2,3... or 0,1,2... instead of A,B,C...?

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 2016-02-20 15:30:47.439742

1 Answer

Sort by » oldest newest most voted

answered 2014-03-26 12:56:21 +0200

JohnSUN gravatar image

Choose Tools - Options - LibreOffice Calc - Formula Choose Tools - Options - LibreOffice Calc - Formula

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-03-26 11:35:45 +0200

Seen: 3,391 times

Last updated: Mar 26 '14