Window resets to A1 when entering data

M

Mac User

I'm using Excel 2004 for Mac on a MacBook Pro with OS 10.5.8. When I go to
enter data into a cell, the window automatically moves so that A1 is the
uppermost left cell. This is very frustrating because I then have to find
the cell I was entering data into by scrolling all over the place. Any ideas
on why the cell I'm entering data into won't stay in view?
 
G

Gary Keramidas

not sure never seen a mac, but does it only happen in one workbook on one sheet?
do you have any code on the code page?
 
M

Mac User

Thanks for your response! It does only happen in one workbook on one sheet.
As for the code page, I'm not sure how to check that...
 
G

Gary Keramidas

i can only go by the windows version, but if you open the vb editor, view the
project explorer and then double click the sheet in question, is there any code
there?
 
S

Stephanie Barlow

It's taken me all morning to find someone with the same problem that I have. I'm a new Mac user (Macbook Pro) and am getting so frustrated with this. The spreadsheet was created in Office 2007 but is working fine apart from the same problem.

I have been working out the hotkeys to move around the sheet which I'm getting there with, but now have the issue where the active cell doesn't show on the page. I can use the scroll function to scroll to the active cell but if I start typing into it, the sheet moves to A1 and I can't see the active cell.

If I turn on the freeze panes function it stops doing it. HELP!!

Also, where is the scroll lock function on a Macbook Pro?



Mac User wrote:

Window resets to A1 when entering data
04-Jan-10

I am using Excel 2004 for Mac on a MacBook Pro with OS 10.5.8. When I go t
enter data into a cell, the window automatically moves so that A1 is th
uppermost left cell. This is very frustrating because I then have to fin
the cell I was entering data into by scrolling all over the place. Any idea
on why the cell I am entering data into will not stay in view?

Previous Posts In This Thread:

Window resets to A1 when entering data
I am using Excel 2004 for Mac on a MacBook Pro with OS 10.5.8. When I go t
enter data into a cell, the window automatically moves so that A1 is th
uppermost left cell. This is very frustrating because I then have to fin
the cell I was entering data into by scrolling all over the place. Any idea
on why the cell I am entering data into will not stay in view?

not sure never seen a mac, but does it only happen in one workbook on one
not sure never seen a mac, but does it only happen in one workbook on one sheet
do you have any code on the code page

-

Gary Keramida
Excel 2003

Thanks for your response!
Thanks for your response! It does only happen in one workbook on one sheet
As for the code page, I am not sure how to check that..

:

i can only go by the windows version, but if you open the vb editor, view
i can only go by the windows version, but if you open the vb editor, view th
project explorer and then double click the sheet in question, is there any cod
there

-

Gary Keramida
Excel 2003


Submitted via EggHeadCafe - Software Developer Portal of Choice
The ASP.NET Codebehind vs. Inline Code Debate
http://www.eggheadcafe.com/tutorial...39-69bf068d9437/the-aspnet-codebehind-vs.aspx
 
D

Dave Peterson

You may want to post in
news://msnews.microsoft.com/microsoft.public.mac.office.excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Truncate a data entry cell 3
how to continue writing in a single cell? 3
entering data using tab 1
How to mark down the time when entering input to a cell? 1
moving all data to cell a1 4
Data Validation 4
Adding up within a cell during data input 3
Pulling data from another worksheet 2

Top