GOTO FUNCTION

0

How to make a user to jump to a specific cell in the row if he needs to enter data without having  to go cell by cell until find that specific cell? For instance, I have spreadsheet where the user enters data like hours worked, pay rate, etc, in each month for the actual payroll to process; but the user also needs to enter the job position and type of job at the initial procedure, which both cells are located in the last two columns of each row. Thank you for your help. Ahmed

Answer
Discuss

Answers

0
Selected Answer

The best way is to lock all of the cells except the ones where the user will enter data. However, I get the feeling that that won't work in your case.

A quick way to get to the end of any row or column is using keyboard shortcuts, Ctrl + Arrow Key.

Discuss
0

I found a better work around solution to my problem, i.e., the Go To function by pressing F5 and in the reference field one enters the column letter(s) and row number; thanks to YouTube video by Hun Kim. You can also access HunKim.com. This is an additional comment.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login