In Calc there is a "Name Box" also referred to as the "Active cell reference."
It is illustrated and labeled in "Figure 1: Calc main window." It is the first illustration at this link. https://books.libreoffice.org/en/CG74/CG7401-Introduction.html This Name Box shows the address of the currently selected cell. If you want to navigate to a particular cell, B1 in your case, type B1 in the Name Box and press enter. The cell will immediately become the active cell. This method requires you know the address of the cell you wish to select but, provided you know that, it will move the cell selector there from anywhere on the sheet. On Sat, May 23, 2026 at 4:39 PM Johnny Rosenberg <[email protected]> wrote: > Den lör 23 maj 2026 kl 19:54 skrev nine9feet <[email protected]>: > > > Try as follows from the manual : > > " Home moves the cell focus to the start of a row. Ctrl+Home moves the > cell > > focus to the > > > > first cell in the sheet, A1" > > > > HTH > > > > I don't understand why he would try any of that, since none of that is what > he wants to do. He wants to move to the top of the column. > Of course you can do that by repeatedly hitting Page Up, but I guess that's > not what he was looking for. > > > > > > > On Sat, 23 May 2026 at 18:49, Jarek Krcmar <[email protected]> > wrote: > > > > > Good evening team, > > > > > > I write this message to you, because I would know, how to return to the > > > cell for example B1, if I am on the cell B13. > > > > > > If I will use Ctrl + Home, I will be on the cell A1. (In this moment I > > > doesn't need it.) > > > > > > Could you give me an advice, please? > > > > > > Does exist hotkey for it? > > > > No, you have to create your own, I'm afraid, unless you are happy with > hitting PageUp repeatedly until you reach the first row of that column. > You can write a macro for it, a macro that just checks the current > selection, set the row to 0 and selects that. Then you can assign that > macro to whatever keyboard shortcut (or menu, or toolbar, or event, or > whatever) you like. > The macro should be very simple, something like: > > Option Explicit > > Sub SelectFirstRowOfActiveColumn() > Dim oCurrentSelection As Object > Dim oActiveCell As Object > Dim oSheet As Object > Dim lTargetColumn As Long > Dim oTargetCell As Object > > ' Get the current selection in the document > oCurrentSelection = ThisComponent.getCurrentSelection() > > ' Ensure the selection is a single cell or a range > If > oCurrentSelection.supportsService("com.sun.star.sheet.SheetCellRange") Then > > ' Get the active sheet > oSheet = ThisComponent.getCurrentController().getActiveSheet() > > ' Get the column index of the top-left cell in the current > selection > lTargetColumn = oCurrentSelection.getRangeAddress().StartColumn > > ' Get the cell in row 1 (index 0) of that column > oTargetCell = oSheet.getCellByPosition(lTargetColumn, 0) > > ' Select the target cell > ThisComponent.getCurrentController().select(oTargetCell) > End If > End Sub > > The code above was generated by AI, and I didn't test it, but I see nothing > wrong with it, so I think it might work. If not, I guess we could dive into > it and fix it. > If it works and you want to assign it to a keyboard shortcut, you can do > that at ”Tools → Customise → Keyboard”. > > For this to work in all Calc files, you need to make the macro global. > Here's the whole procedure: > Tools → Macros → Organise macros → Basic > In the left pane in the new window that pops up, select My macros and > dialogues → Standard > Hit New > the Basic IDE opens and there's some code: > Sub Macro1 > > End Sub > > Just replace this with the code above. > > To test it, select a cell in your spreadsheet and start the macro by > placing the cursor somewhere inside the macro code and hit F5. The top cell > of that column should now be selected. > > > Ok, since I wrote all this text, I actually had to test the code, and yes, > it works. > > > Kind regards > > Johnny Rosenberg > > > > > > > > > Sincerely > > > > > > > > > -- > > > Jarek > > > > > > > > > -- > > > To unsubscribe e-mail to: [email protected] > > > Problems? > > > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > > > Posting guidelines + more: > > https://wiki.documentfoundation.org/Netiquette > > > List archive: https://listarchives.libreoffice.org/global/users/ > > > Privacy Policy: https://www.documentfoundation.org/privacy > > > > > > > -- > > To unsubscribe e-mail to: [email protected] > > Problems? > > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > > Posting guidelines + more: > https://wiki.documentfoundation.org/Netiquette > > List archive: https://listarchives.libreoffice.org/global/users/ > > Privacy Policy: https://www.documentfoundation.org/privacy > > > > -- > To unsubscribe e-mail to: [email protected] > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- Alan Boba CISSP, CCENT, ITIL v3 Foundations 2011 -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
