• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 138
  • Last Modified:

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
0
Peter Parker
Asked:
Peter Parker
3 Solutions
 
Ejgil HedegaardCommented:
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
 
HuaMinChenBusiness 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 CoxGroup 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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now