Button in Excel

Hi Experts

I am looking for creating some sort of a Button or some other shortcut type of thing in excel, such that I can place it anywhere within any excel worksheets. And when I click on it, that will take me to 100 cells below, in the very same column.

I should have the freedom to place this button anywhere in any of my excel sheets. And just with one click on it, my mouse will go down 100 cells, without any need of manual scrolling. I am doing this, because I have to work with very large excel sheets and I get tired of scrolling and scrolling more, all the time.

I am using Microsoft Excel Professional x64

Thanks for any help
Peter ParkerAsked:
Who is Participating?
 
Ejgil HedegaardConnect With a Mentor Commented:
Insert this in a module in your personal workbook.
Then it will work in any workbook.

Sub Move100()
    ActiveCell.Offset(100, 0).Select
End Sub

Make a shortcut  to the sub like Ctrl+Shift+M, and it will select a cell 100 cells below the active cell.
2
 
HuaMin ChenConnect With a Mentor System AnalystCommented:
Hi,
Please choose Developer below to enable the Tab, to further add relevant buttons on your Excel file. And create button event to do the job.
8x.png
0
 
Roy CoxConnect With a Mentor Group Finance ManagerCommented:
You can do this manually.

Ctrl + G then simply add 100 to the current Row in the reference box

CTRL-G.png
0
 
Peter ParkerAuthor Commented:
Thank you Experts.
0
 
Roy CoxGroup Finance ManagerCommented:
Pleased to help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.