Question about Microsoft EXCEL 2004 for Mac

2 Answers

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

Posted by on

  • 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

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 1 Answer

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"

Posted on Feb 07, 2010

  • 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

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.

Posted on May 31, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

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

Oct 13, 2015 | Microsoft Excel for PC

1 Answer

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.

Jan 24, 2014 | Lenovo Keyboard

1 Answer

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

Aug 14, 2013 | Microsoft Office Computers & Internet

1 Answer

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.

Feb 11, 2012 | Microsoft Office Excel 2003 for PC

1 Answer

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.

Dec 29, 2010 | Dell Wireless Keyboard Optical Mouse w0147

1 Answer

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.

Jan 22, 2009 | Logitech Marble Mouse Trackball

2 Answers

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!

Nov 14, 2008 | Symbol LS2208 Handheld

2 Answers

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

Nov 06, 2008 | Computers & Internet

1 Answer

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.

Sep 18, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

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!

Oct 15, 2007 | Apple MacBook Pro Laptop Computer with...

Not finding what you are looking for?
Microsoft EXCEL 2004 for Mac Logo

7,585 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...