Ask Your Question
0

bookmarking a row in calc?

asked 2019-07-31 05:28:30 +0200

clos911 gravatar image

my calc file has 7214 rows... 1 row for each individual items in an inventory.. I know it sounds messy but I have it organized so that identical item types are next to each other going down the rows..

I would like to know if there is a way to quickly get to a row in a spreadsheet that doesnt involve scrolling endlessly?

also i can't rely on referencing the row's number, i add rows in several locations..

what i currently do is; I use auto filter to select the item type I'm looking for in a column, I note the row number of the item type, then scroll down the sheet to said row.. i know there's got to be a more efficient way...?

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted
1

answered 2019-07-31 14:00:19 +0200

Opaque gravatar image

Hello,

If you know the row - just add the name A<row> (e.g. A3752 ) into the Name Box left most of the Formula Bar and press ENTER. This takes you to the desired row (in general: To any desired cell). At least this would elliminate the scrolling.

edit flag offensive delete link more

Comments

1

@clos911: And how many references are needed there? You mentioned that you "can't rely on referencing the row's number, i add rows in several locations" - but instead, you could assign names to the ranges, and then extend the advise by @Opaque using the Name Box, which has a drop-down with the list of names...

Mike Kaganski gravatar imageMike Kaganski ( 2019-07-31 14:16:28 +0200 )edit

This solved my problem! I added a name to the cell in the row I want to view using formula bar, then use the drop down box to quickly get to said row. as far as how many rows I'm referencing, its about 75 throughout the spreadsheet, so that dropdown box is going to be full!

clos911 gravatar imageclos911 ( 2019-07-31 23:45:52 +0200 )edit
0

answered 2019-07-31 08:19:30 +0200

Cookievore gravatar image

updated 2019-07-31 08:22:01 +0200

Hello clos911,

a simple solution could be to add another column named bookmark, place a x into the row you want to bookmark, use 'search' on the bookmark column next time to jump to the specific row (to perform that, mark the whole column bookmark and go to menu 'edit', 'search', this will lookup the searched word only in the marked column).

Extended version: You could use several letter codes to bookmark more than one position if there is need to return to several item sections or other favoured positions.

Seperate from this solution, doesn't Calc open on the last saved position? Here it does. Maybe there is a way to set and edit this internal bookmark by macro code but I don't have a clue on this.

edit flag offensive delete link more
0

answered 2019-08-01 14:41:30 +0200

Lupp gravatar image

There were somehow related questions earlier. One I found again was this one in the German branch.

Despite the fact that already an accepted answer exists, I add an example going different ways. That's becasuse I wouodn't like to need to define a potenially infinite number of named ranges, and to add new named ranges probably again and again.

If I understood the situation correctly, there are ways to solve the task using th HYPERLINK() function without needing any specific measures per "item type". One of these ways can use a dedicated sheet containing a complete list of these types, and using an adjacent column to get links very similar to bookmarks automatically. Another way accepts the input of one of the "types" into a specific cell supported by a 'Validity' setting if wanted. Both these solutions are demonstrated in the attached demo. The maintenance of the "bookmark-solution" may suffer from problems caused by a bug or by general shortcomings of HYPERLINK.

There is also demonstrated a solution based on user code whitch should be even more comfortable, but comes with the general disadvantages of relying on "macros". Ths solution can, of course, only work if macros are permitted or if the needed code is moved to the local 'Standard' library.

You find the demonstrating file here.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-07-31 05:28:30 +0200

Seen: 38 times

Last updated: Aug 01