I’m a big fan of letting the computer do the work. Is there any way to perform this operation in Calc (jump around from cell or sheet to another cell or sheet) without having to write down previously referenced cells addresses? Naming the cells wouldn’t be helpful because every time I added a new record to the spreadsheet, I’d have to name the cells I’m interested in. Noticing that the Address location had a pull-down arrow to the right, I was hoping that it would maintain a list of typed in addresses on a LIFO stack, but unfortunately the pulldown simply brings up another function. See the attached screen shot from Excel to see what I mean. There’s also no need to write any information down in order to return to the cell that you were previously working on.Ī list of cells that have been used are also displayed, allowing the user to simply select from a list of recently used cells by the ctrl-g goto command. Ctrl-g will allow you to go back and forth between two cells without having to enter the cell address. If I enter ctrl-g again, the same dialog box pops up, but with the previous cell filled in. ![]() I enter the cell I want to go to, and click OK or press Enter. So, if I enter ctrl-g in Excel, I get a dialog box asking for the cell reference. It automatically fills in the previous cell location. ![]() That part does work.īut, there’s another aspect of Excel’s goto which I can’t seem to find in Calc.Įxcel maintains a list of the cells you’ve gone to via ctrl-g goto. I’m aware of the Address location and using F5 to bring up Navigator in LibreOffice Calc. In Excel, when you type a ctrl-g, a dialog box opens which allows you to enter a cell reference, and then allows you to go to that cell. I have searched through the questions on an Excel ctrl-g (goto) equivalent for Calc, and have not seen the variant I’m interested in.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |