Excel cell pointer does not moving around the worksheet

Asked By Carl Park 10 points N/A Posted on - 07/16/2011

Excel cell pointer does not move around the worksheet

I have got a problem in my Microsoft Office Excel while doing my assignment in accounting.

My cell pointer does not move when using the navigation keys from cell to cell instead the whole screen or the worksheet moves.

But when I am using the  mouse the cell pointer moves to the cell I have clicked.

• Status: Open
• Question Views: 2289
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Printers

Best Answer by Windy Miles

Go To Solution

Answered By Lucky Mass 0 points N/A #81577

Excel cell pointer does not moving around the worksheet

Excel cell pointer does not move around the worksheet

Microsoft Office Excel has the option to scroll the worksheet and make the cell pointer stays on the current cell for viewing purposes. Like for instance you want to verify something on the worksheet at it is not visible on the screen, then you want to find it by browsing the area concerned and based on the data you have browsed, from there you will encode a formula or just copying the content of the cell, you can just encode it on the formula bar without going back on the cell.

This option is enabled and also disabled in toggle mode by pressing the Scroll Lock key. Just press the Scroll Lock then you will see a light on your keyboard with the label Scroll Lock.

If the light is on, the scroll lock in your excel worksheet is also enabled and if it is off, the scroll lock on your Microsoft Office excel is also disabled.

About Lucky Mass

Questions
0

Answers
10

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 07/16/2011
• Question Category: Printers

Best Answer

Best Answer

Answered By Windy Miles 0 points N/A #81578

Excel cell pointer does not moving around the worksheet

Hi Mr. Carl,

Here are some strokes key which can help you with your problem;

Strokes of key                                            Movement of Cell Cursor

Right arrow or the Tab                             – Cell to the right

Left arrow or Shift+Tab                            – Cell to the left

Up arrow                                                    – Cell up one row

Down arrow                                               – Cell down one arrow

Home                                                          – Cell in Column A (current arrow)

Ctrl+Home                                                  – First Cell A1 of the worksheet

Ctrl+End or End                                         – Worksheet cell at the intersection of last column and the last row with data 

Page up                                                       – From the same column cell full screen up

Page Down                                                 – From the same column cell full screen down

Ctrl+Right arrow or end                            – In the same row to the right of the first occupied cell which is followed by a blank cell. 

                                                                         If there is no a blank cell, pointers goes to the cell at the end of the row

Ctrl+Left arrow or end                               –   In the same row to the left of the first occupied cell which is followed by a blank cell

                                                                        If there is no blank cell,pointers go to the cell at the beginning of the row

Ctrl+Up arrow or end                                – In the same row to the upward portion of the first occupied cell which is followed by a                                        

                                                                         blank cell. If there is no blank cell, pointers go to the top of the column

Ctrl+Down arrow or end                           – In the same row below the portion of first occupied cell which is followed by a blank  

                                                                          cell. If there is no blank cell, pointers go to the bottom of the cell

Ctrl+Page Down                                         – Cell pointer is to the next page of the worksheet

Ctrl+Page Up                                              – Cell pointer is to the previous page of the worksheet

 When using the above tips just ensure that:

• If keystrokes use arrow keys, use arrow on the cursor keypad or unable the Num Lock 
• When moving quickly from one edge to the other with the large tables of cell, use the keys Ctrl+End
• Hold down Ctrl key while pressing one of the desired key from the four arrow keys to move from edge to edge or from                                
• block to block of the cell

I hope this could make your assignment easy to prepare with the excel. God Bless

 

About Windy Miles

Questions
0

Answers
10

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 07/16/2011
• Question Category: Printers

Answered By Sharath Reddy 590495 points N/A #321407

Excel cell pointer does not moving around the worksheet

That problem happens when the Scroll Lock key is activated on your keyboard. I tried it myself to see what will happen when the Scroll Lock key is turned on when using Microsoft Office Excel and I just reproduced your problem, the entire screen or workspace moved while the cursor is locked or fixed in one cell.

Turning off or deactivating the Scroll Lock key on the keyboard fixed the problem, I was able to move the cursor again in any cell in the worksheet. If this is your problem, check your keyboard and see if the Scroll Lock key is turned on. If the LED indicator of the Scroll Lock key is activated, press the Scroll Lock key again to deactivate the LED indicator.

Once the key is turned off, move the cursor in the worksheet by pressing the arrow keys on your keyboard.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 07/18/2019
• Question Category: Printers