Data appears in wrong cell

Question

When typing data into an Excel for Mac spreadsheet, the data actually appears in the cell below the one I am typing in (after I hit enter).

Thanks in advance for any help.

Answer 1

Hi 400E,

Have you tried my suggestion? Any update will be appreciated.

Best Regards,

Dora

Just copied the last few rows of data into new workbook. Seems to be working OK in this new book.

I wonder if there is some glitch that happens further down the sheet (e.g. after a certain row).

I recall having this same problem about a year ago, that seemed to crop up only after using a workbook for daily entries for a number of months (i.e. getting down into higher numbered rows).

Anyway, thanks for the tip of copying into a new workbook -- seems OK for time being.

Answer 2

You did not indicate the present update level of your Office 2016 installation, so that's the first point I'd suggest addressing. This type of behavior had been reported by a small number of users in some earlier versions of the software. Currently, the latest update available to all users is 15.33, so make sure that update is applied, then Restart your Mac.

I had gotten the 15.33 update I think a week or two ago and am starting to wonder if that's when the problem began?

I did restart my Mac just to make sure, but problem persists.

thanks!

Answer 3

Hi 400E,

You may try below and let us know if it works.

Excel menu>Preference…>Edit>uncheck the after pressing Return, move selection.

After that, if you hit enter it will remain you in the current cell.

For the issue you encountered, please confirm and provide the following information for further troubleshooting.

1.    Does the issue occur to all cells or some specific cells?

2.    When do you encounter this problem? Have you done some configurations before the issue occurs?

3.    Some  related screenshots about how you performed to reproduce this issue.

4.    Does this issue occurs to all workbooks or the specific one?

5.    The version of your Excel（Excel>about Excel）

Best Regards,

Dora

Thank you for this reply!

I tried unchecking the box you mention in the 'edit' place but didn't help, unfortunately.

RE: your other questions:

1.  Seems to be happening in all cells
2. Just started doing this yesterday. No new configurations other than I did manually update all my Microsoft office products maybe a week ago -- so maybe that is related?
3. I'll see if I can capture something relevant on a screenshot
4. Seems to be happening in only one particular workbook.
5. Version 15.33

thanks again

Answer 4

You did not indicate the present update level of your Office 2016 installation, so that's the first point I'd suggest addressing. This type of behavior had been reported by a small number of users in some earlier versions of the software. Currently, the latest update available to all users is 15.33, so make sure that update is applied, then Restart your Mac.

Answer 5

Hi 400E,

You may try below and let us know if it works.

Excel menu>Preference…>Edit>uncheck the after pressing Return, move selection.

After that, if you hit enter it will remain you in the current cell.

For the issue you encountered, please confirm and provide the following information for further troubleshooting.

1.    Does the issue occur to all cells or some specific cells?

2.    When do you encounter this problem? Have you done some configurations before the issue occurs?

3.    Some  related screenshots about how you performed to reproduce this issue.

4.    Does this issue occurs to all workbooks or the specific one?

5.    The version of your Excel（Excel>about Excel）

Best Regards,

Dora