Ask Your Question
0

how to jump to specific row/column

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

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 close merge delete

2 Answers

Sort by » oldest newest most voted
0

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

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

Comments

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 +0200 )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 +0200 )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 +0200 )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 http://www.pitonyak.org/oo.php.

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

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

pierre-yves samyn gravatar image

Hi

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

screenshot

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

Regards

edit flag offensive delete link more

Comments

This worked for me

e.mont01 gravatar imagee.mont01 ( 2019-05-26 20:59:23 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 1,219 times

Last updated: Oct 20 '16