arrow keys shift the whole range of cells

hirendra7158

New Member
Joined
May 14, 2011
Messages
6
Hi, My Excel 2007, moves or shift the whole range of cells with arrow keys instead of one cell. i.e. when I press upward arrow key, instead of selecting the cell above, the whole range of the cells ( page) move downwards. Any tip?
similarly while pressing the right or left arrow key, the adjacent cells SHOULD be selected. but here the page moves without changing the selected cell.
Any help? Thanks.
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
No sir, Thanks for your tips, but neither F8, nor sticky keys nor the shift nor the scroll lock keys have helped. I am anxious.
 
Upvote 0
Yes SIR. The scroll lock DID help. My fault when I reported to be not working. Since on my HP pavillion, the scroll lock gets activated by function keys, I was repeatedly hitting it with function keys. I got result when I just hit the scroll lock without trying to activate the scroll function.Thanks everybody who has replied me. and sorry fort the misunderstanding.
 
Upvote 0
By the Way, sir. I loved your Excel function =IF(caffeienlevel...... ) Many times I myself am getting my mood updated by this formula!!!!
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,329
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top