Microsoft EXCEL 2004 for Mac Logo
Posted on Feb 02, 2009
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

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

Hello, I cannot use my tab key on the keyboard to move across columns in a spreadsheet which I use constantly

Please help as I have to use the arrow keys

Much Appreciated
Je

  • Anonymous Mar 10, 2009

    Same thing, my tab wont work, or if it does, I cant type anything into the cell its on. It seems to happen on an off. Its going to slow me down like crazy to have to double click on every cell that I want to type info into.

    Hellllllp

    KG


×

2 Answers

Anonymous

Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

Mayor:

An expert whose answer got voted for 2 times.

  • Contributor 1 Answer
  • Posted on Feb 07, 2010
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

Mayor:

An expert whose answer got voted for 2 times.

Joined: Feb 07, 2010
Answers
1
Questions
0
Helped
7785
Points
1

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"

John Morganti

Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

  • Master 864 Answers
  • Posted on May 31, 2009
John Morganti
Master
Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

Joined: May 19, 2009
Answers
864
Questions
4
Helped
373895
Points
2813

If you highlight the row that you are working in (by clicking on the row number at the left), the TAB key will move you to the next column cell each time you press it.
The intermittent problem that requires double clicking to open the cell sounds like a different issue with the computer or keys and is not an Excel problem.

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

0helpful
1answer

How to move the result of a formula up or down one cell

go google and type in --manual for excel version (what ever it is ) and down load the pdf file
go to a book shop and buy a Excel for dummies book
or e-bay and excel for dummies or other excel explained books
explaining it as a reply will be as confusing as the reply would be pages long
0helpful
1answer

Mouse not working

The Tab key moves from field to field and the arrow keys move thru items inside the fields.The enter key executes command in the field. So Tab to user icon or password field type in password if needed and hit enter.
0helpful
1answer

Cell freeze 3 rows together at a time.

Freeze a Row in Microsoft Excel
Microsoft Excel 2010 can freeze, or lock, a top row as you scroll down the worksheet.
For example, you may need to keep the top row of column titles visible at all times.
The "View" tab on the command ribbon contains the "Freeze Panes" button in the "Window" group.
A single row or a range of rows can lock through the "Freeze Top Row" or "Freeze Panes" options.

Open the Excel worksheet.
Click the top row heading.
The row heading displays a number just left of the first column of cells. The selected row appears shaded.


Click the "View" tab on the command ribbon.
Click the "Freeze Panes" button in the "Window" group.
A list of options appears.

Click the "Freeze Top Row" option.
A black horizontal line appears on the worksheet.
This line indicates the locked row that stays on the screen as you scroll down the worksheet.

http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP010342542.aspx?CTT=1
Freeze or lock rows and columns
also
Use Freeze Panes in Excel
Scrolling down to look at a number and then scrolling up to make sure the number you looked at is under the header you expected is not an efficient way to view a spreadsheet.
The Freeze Panes feature of Excel allows you to freeze the labels of your data in place while you review the data.
Follow the instructions in Section 1 to freeze the top row or the left column.
Freeze multiple rows, multiple columns, or rows and columns, by following the instructions in Section 2.Freeze the Top Row or Left Column
1
Open the Excel spreadsheet.
2
Navigate to the "View" tab on the top menu.


3 Click on "View," then click on "Freeze Panes." A drop-down menu opens.

4

Select the "Freeze Top Row" option to freeze the top row.

5

Select the "Freeze Left Column" or "Freeze First Column" option to freeze the left column.

6

Freeze the top row by using the keyboard and sequentially pressing the keys "ALT, W, F, R." Ignore Steps 3 through 7 if using this choice.

7

Freeze the left column using the keyboard by sequentially pressing the keys "ALT, W, F, C." Ignore Steps 3 through 7 if using this choice.

8

Unfreeze panes by repeating Steps 3 through 5 and selecting "Unfreeze Panes" or sequentially press the keys "ALT, W, F, F."

Freeze Rows and Columns, Multiple Rows, Multiple Columns, or Multiple Rows and Columns
9

Open the Excel spreadsheet.

10

Freeze column(s) and row(s) at the same time by selecting the cell to the right of and below the location you want to freeze.

11

Freeze multiple rows only by selecting the cell in the left (first) column below the rows you want to freeze.

12

Freeze multiple columns only by selecting the cell in the top row to the right of the columns you want to freeze.

13

Navigate to the "View" tab on the top menu.

14

Click on "View," then click on "Freeze Panes." A drop-down menu opens.

15

Select the "Freeze Panes" option. You have now frozen the columns or rows, or columns and rows you designated.

16

Freeze panes using the keyboard by sequentially pressing the keys, "ALT, W, F, F." Ignore Steps 5 through 8 if using this choice.

17

Unfreeze panes by repeating Steps 5 through 7 and selecting "Unfreeze Panes" or sequentially press the keys, "ALT, W, F, F."



http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP001217048.aspx
Freeze or lock rows and columns
http://office.microsoft.com/en-us/excel-help/demo-hide-or-unhide-rows-and-columns-HA010241040.aspx
Hide or show rows and columns
0helpful
1answer

I can't get Microsoft Excel 2003 to delete cells

Hello,

Unless the excel spreadsheet is locked for editing then all you should have to do is Left Click on the cell you want to delete and press Backspace or the DEL key on your keyboard.

To delete multiple cells left click and hold in the middle of the first cell and drag your mouse down or across to highlight multiple cells. Then press the Backspace or DEL key on your keyboard.
0helpful
1answer

Having replaced batteries on a Dell mouse and keyboard, switched on keyboard and mouse not working. Dell support window says both connected? Cannot move mouse to acknowledge message saying that new device...

If the keyboard is working, try the "tab" key or a combination of the "tab" and "shift,ctl or alt" key.
You should be able to move the cursor to highlight to Ok message, then hit return.
0helpful
1answer

Need the ability to "tab" from field to field on right of kybd

When you press ENTER to finish working in a cell, Microsoft Excel moves the cursor one cell down by default. However, you can select the direction in which you want the cursor to move.
  1. On the Tools menu, click Options.
  2. On the Edit tab, do one of the following:
    • To change the direction in which the cursor moves, select the Move selection after Enter check box, and then select a direction in the Direction box.
    • To keep the cursor in the current cell, clear the Move selection after Enter check box.
Note When a range or set of ranges is selected, pressing ENTER moves the cursor within the range or set or ranges only.
2helpful
2answers

Move to next cell in excel

In Excel 2003 Offline help, i see this helpful note:

Change which cell is selected next When you press ENTER to finish working in a cell, Microsoft Excel moves you to an adjacent cell or leaves you in the current cell.
  1. On the Tools menu, click Options, and then click the Edit tab.
  2. To move to an adjacent cell, select the Move selection after Enter check box, and then select a direction in the Direction box. To stay in the current cell, clear the check box
for our Symbol scanner we are using this apparently is not working, but it might for you!
2helpful
2answers

Cannot insert columns in excel spreadsheet. Comes up with error cannot shift object off sheet

This error message occurs if the following conditions are true:
  • The option Nothing (hide objects) is selected in the Display options for this workbook section in the Excel Options dialog box.
  • You create an object, such as a cell comment, in any cell in a column.
  • You try to hide the column to the left of the column that contains the object, the column that contains the object, or all the columns to the right side of the column that contains the object. Or, in some cases, you try to insert a row or column in the worksheet.
There are two ways to fix this problem.
Method 1:  Temporarily toggle the option from "Nothing (hide objects)" to All In Excel 2007, temporarily toggle the option from Nothing (hide objects) to All, and then insert the rows or columns as needed. To do this, follow these steps:
  1. In the upper-left corner of the Excel window, click the Microsoft Office button.
  2. At the bottom of the menu, click Excel Options.
  3. Click Advanced from list of options on the left.
  4. Scroll down to the Display options for this workbook section, and then click All under For objects, show:, and then click OK.
Notes To use the keyboard shortcut to toggle this selection, press CTRL+6. 
If these steps do not let you hide rows or columns or insert rows or columns in Excel 2007, try the steps in method 2.
Method 2: Change the position property of the object to Move and size with cells To work around this issue, Excel 2003, Excel 2002, and Excel 2000, change the position property of the object to Move and size with cells. To do this, follow these steps:
  1. If the object is a cell comment, select the cell that contains the comment, right-click the cell, and then click Show Comment or Show/Hide Comments. Note This makes the comment visible.
  2. Move the pointer to the edge of the object until the pointer changes into a white arrow with four small black arrows on the pointer. Then, click the object to select it.
  3. In Excel 2003 and earlier version of Excel, click <object name> on the Format menu. Note In this menu command, <object name> is the name of the object, such as "Comment" or "AutoShape."  In Excel 2007, click Format <object name>.
  4. In the Format dialog box, click the Properties tab.
  5. Click Move and size with cells, and then click OK.
  6. If you want to hide the cell comment again, right-click the cell that contains the comment, and then click Hide Comment.
  7. Follow these steps for each object in the affected column as described in the "Cause" section. When you hide the columns, you do not receive the error message.
For more information, visit the Microsoft Knowledge Base article: http://support.microsoft.com/kb/211769
0helpful
1answer

Scroll lock in excel 2007

When SCROLL LOCK is on, "SCRL" appears on the Excel status bar. If you press the arrow keys when SCROLL LOCK is on, you scroll one row up or one row down. Or, you scroll one column to the left or one column to the right. To use the arrow keys to move between cells, you must turn SCROLL LOCK off.
6helpful
1answer

Using tab key to move around on a field page on a Mac

Hello there!

Navigating around fields on a Mac is actually just about identical to how you do it on a PC - the 'Tab' key should work the same as what you are used to.

However, by default, hitting the tab key will go to "Text boxes and lists only", as opposed to "All controls", so this level of tabbing may be what you are looking for!  To enable this, try following these steps:

  1. Click on the blue Apple menu, at the top-left of your display.
  2. Click on "System Preferences" (basically this is the equivalent of the Control Panel on the PC).
  3. Click on the icon for "Keyboard & Mouse" in the System Preferences panel.
  4. Click on the "Keyboard Shortcuts" tab.
  5. In the bottom of this pane, you'll see two radio buttons you can choose from for tab behavior.  It is probably set to "Text boxes and lists only"... try switching it over to "All controls", and see if this suits you better.
Hope this helps... Good luck!
Not finding what you are looking for?

7,795 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...