Question about Microsoft Excel for PC

1 Answer

Moving between cells

When I use the keyboard arrows to move between cells - the focus doesn’t change between the cells but stays on the same one and just moves the whole sheet down. Why?

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert that has over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 5 Answers
Re: Moving between cells

It is because you probebly clicked on 'Scroll Lock'.
Click it again

Posted on Dec 19, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

1 Answer

My laptop keyboard can't work, its locked and i cant type

This can be done by software (locking the keyboard). I'd try a hard reboot, and see if that solves the problem.

If that doesn't work, sometimes keys get stuck down and cause the keyboard to stop working, it's odd but I find pressing (mashing) each of the keys 2-3 times will often fix keyboard issues. I typically start with the common keys like the ctrl, alt, shift, space, enter, etc.

Hope that gets ya moving again.

Apr 07, 2014 | Microsoft Office Professional 2007 Full...


How to find no. of rows and columns in Worksheet.

Hello everybody, this would be my first tip on Number of people might not be aware how many rows and columns are there in Microsoft Worksheet.
This is how you can find out.
1. Select A1 cell in the worksheet
2. Now press Ctrl + down arrow from your keyboard, that will take you to the bottom of the row. You can find the number on the left side.
3. Again select A1 cell in the worksheet and press Ctrl + left arrow from your keyboard, that will take you to the last column of the worksheet. Now to number, just type "=column() " , without quotations, that will give you the number of the column.
Microsoft Worksheet columns is number from A to Z, again from AA to AZ, again from BA to BZ and so on till it reached IV in Excell 2003 and earlier version.
Microsoft Excel 2003 and old version has 16,777,216 cells per worksheet (65,536 rows * 256 columns).
Excel 2007 has 17,179,869,184 cells per worksheet (1,048,576 rows * 16,384 columns).

on Jul 27, 2010 | Microsoft Excel for PC


Top 10 most useful secrets in Office

Here are my top 10 most useful secret ninja moves to increase your productivity and win friends and lovers.
#1: Format painter (Office) The Format Painter tool replicates the formatting from one part of a document to another. So instead of manually redoing all the formatting yourself, you can use the Format Painter. First, select the text whose formatting you want to replicate. Then, click the Format Painter toolbar button. Finally, select the text you want to imbue with the format. For bonus points, you can double-click the Format Painter button to replicate the formatting to multiple areas of the document!

#2: Paragraph in/out/up/down (Office) You can easily move a paragraph in four directions by pressing Alt+Shift+[Arrow]. To increase or decrease the indentation level of a paragraph or bullet point, press Alt+Shift+Right and Alt+Shift+Left respectively. To move a paragraph up or down, press Alt+Shift+Up or Alt+Shift+Down. This works especially well in PowerPoint, where it's common to reorder bullet points or change indentation levels.
#3: Increase or decrease font size (Office) To quickly increase the font size of selected text, press Ctrl+Shift+>. To decrease the size, press Ctrl+Shift+<. I find it easy to remember these keyboard shortcuts because the one with the greater-than symbol increases the font size while the less-than symbol decreases it.
#4: Quick Access Toolbar (Office) Office 2007 has a Quick Access Toolbar that can be customized to include buttons for your favorite commands. The Quick Access Toolbar is in the top left corner of many Office applications. You customize it by clicking on the drop-arrow on its right.

#5: Fill handle (Excel) Excel can auto-fill cells in eerily smart ways. Instead of manually typing a sequence in cells, you can simply type the first few values of the sequence and drag the fill handle to auto-fill the rest of the cells. The fill handle is the little black square at the lower right corner of a selected cell's border. Drag it to automatically fill adjacent cells.

If you drag the fill handle with only one cell selected, it will repeat that cell's value into adjacent cells. However, if you drag the fill handle with multiple cells selected, Excel is smart enough to figure out the series. For instance, in the following example, Excel will fill subsequent cells with the increasing series of odd numbers. This even works for other types of series, like dates and percentages.

#6: Moving and copying cells by dragging selection borders (Excel) Quite possibly the most useful yet completely undiscoverable feature in Excel is the ability to move and copy cells by dragging selection borders.

For instance, to move row four between rows one and two, select row four and drag the selection border while holding down the Shift key in order to insert it in its new position. If you drag the border without holding down the Shift key, the selected cells will instead replace the cells you drop them on. Conversely, if you hold down Ctrl while dragging a selection border, the selected cells are copied to their new location.
#7: Status bar statistics (Excel) The status bar in Excel shows handy statistics when multiple cells are selected. In Excel 2007, the status bar shows the selected cells' average, count, and sum. This is an easy way to quickly analyze data without authoring formulas.

#8: Clear formatting (Word and PowerPoint) To remove formatting from selected text, press Ctrl+Spacebar.
#9: Advanced field search (Outlook) In Outlook, you can quickly search through a mail folder by using the Instant Search box. In addition to searching for keywords, you can do a fielded search by prefixing your search text with a variety of field names.

For instance, the above example searches for all mail from people named "jimmy" sent in May with attachments that have "jpg" in the filename. I most often use this feature for two things: to easily find email from a specific person, and to find specific attachments.
#10: Presenter view (PowerPoint) PowerPoint has for many years had a great feature called Presenter View, which allows you as the presenter to see a different view of the presentation from your audience. In Presenter View, your monitor shows not only the slides, but also your notes as well as the current elapsed time in the presentation. This makes giving a presentation far easier. To enable Presenter view, go to the Slide Show ribbon and check Use Presenter View. In that same section, you can also change the monitor which the presentation is shown on. One note: the Use Presenter View checkbox can only be checked if you already have a second monitor connected and enabled.

on Dec 29, 2009 | Business & Productivity Software

1 Answer

Cursor not moving when using keyboard arrows

they won't move the cursor.
Only the selection.

Nov 22, 2013 | Microsoft Excel for PC

1 Answer

On excel, how do I resize and move a pie chart (not the whole plot area)?

click on the frame of the chart, then hover over the frame of the chart. If the cursor is hovered at the corners or centre of each of the sides, the pointer changes into a two way arrow, click and drag at this point to resize. To move the chart, hover over the frame of the chart at any other point and and the cursor changes into a 4-way arrow, click and drag to move the chart to your desired posi.tion

Aug 26, 2013 | Business & Productivity Software

1 Answer

When in a spreadsheet, the arrow keys do not move cursor

first try to see the cursor is not within the cell blinking cause sometimes when the cursor is within the cell it traps the controls and will not able to function on your desire output. so try to observed it again.

Jun 16, 2009 | Microsoft Excel for PC

2 Answers

Tab key on keyboard will not work for moving across columns excel

You need to go into options, open the transition box and un tick the "transitions navigations key" box... This same problem has been ignoring me... You can also fix the double clicking problem in here too... under "edit"

Feb 02, 2009 | Microsoft EXCEL 2004 for Mac

1 Answer

Excel Mac 2004: Cursor Problem

Sounds like Scroll Lock is on. Shift-F14 should disable it, unless the default shortcut keys have been changed.

Jan 02, 2009 | Microsoft EXCEL 2004 for Mac

2 Answers


It is very useful to learn excel shortcut realy i thank you

Sep 26, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

31 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides