Ask Your Question

how to jump to specific row/column [closed]

asked 2016-10-20 06:51:05 +0100

chico801 gravatar image

Hello, just wondering if this operation is possible otherwise I just have to cut and paste. I am hoping that it's possible to set up some kind of setting where I can hit enter and jump into a specific row and column. I have set up a spreadsheet where I only go up to a certain row. If I finish on B30 for example, after I hit enter can it continue to my next page which in this case would be B37.

If that is possible can you also go backwards? For example, delete the information on Row 29 and have Row 30 go into its place? And have all other Row's after 30 go up one? 31 to 30, 32 to 31, 33 to 32, etc. Well I hope any of this is possible and I appreciate in advance any help I can get.

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 2020-09-13 23:30:08.502065

2 Answers

Sort by » oldest newest most voted

answered 2016-10-20 07:24:57 +0100

pierre-yves samyn gravatar image


Not sure this is are you looking for but enter the destination cell in the Name Box (left of the Formula bar) and confirm with Enter exactly answers the question: jump to specific row/column


You can also insert hyperlinks (text or button) to range names.


edit flag offensive delete link more


This worked for me

e.mont01 gravatar imagee.mont01 ( 2019-05-26 20:59:23 +0100 )edit

answered 2016-10-20 18:18:00 +0100

mark_t gravatar image

You could set a page break at row 31 and then B30 would be the last cell on page 1 and B31 would be the first cell on page 2. However the page break would move when you delete or insert rows.

Alternate could be to set the page format to auto insert page break between B30 and B31. From "Format", "Page" on page tab, set bottom margin to 12.5cm and top margin at 2cm works for me on A4 sheet in portrait.

If you set up the page breaks from the page format, then inserting and deleting rows would automatically move the data from B31 to B30. Example select the row 30 and use the delete row icon from the toolbar.

edit flag offensive delete link more


It's a bit difficult to explain this without posting an actual picture of what I was looking for but my work computer isn't windows based but its own company operating system. Any who, I'll try and explain a little bit more. Lets say if we use the image from the comment below as an example. My spreadsheet ends at B34 and my new page begins at B39. Is there a way I can set up the page where once I reach B34 and hit enter, that it will skip over to B39.

chico801 gravatar imagechico801 ( 2016-10-21 06:46:42 +0100 )edit

I think I understand what you want, just not sure why you want it that way. Rows 35 to 38 would be dead space and data would be moved to 34 or 39 on deletion or insertion. I don't think there are built in options to do this. It might be possible to write macros triggered by sheet events but this is tricky to get right, after a cell changes the macro runs and changes a cell which then runs the macro again, can get into a loop.

mark_t gravatar imagemark_t ( 2016-10-21 19:00:24 +0100 )edit

I think a macro is probably the best way to go about this but now I have another problem. When I went to Option>Advanced, I checked off the box "Enable macro recording (limited)" but when I go to Tools the option for recording macros isn't there. Is it because it is "limited"?

chico801 gravatar imagechico801 ( 2016-10-22 00:54:16 +0100 )edit

You need Java installed to record macros. I don't think recorded macros are going to help you much in this case, more likely to be possible if you write the macros in basic, but not an easy choice for your first macro. Take a look at the Andrew Pitonyak book, OOME, and maybe check his site at

mark_t gravatar imagemark_t ( 2016-10-22 01:04:03 +0100 )edit

Question Tools

1 follower


Asked: 2016-10-20 06:51:05 +0100

Seen: 1,896 times

Last updated: Oct 20 '16