HELP Excel is driving me nuts when I try to enter data - ehMac.ca
Facebook
Twitter
YouTube
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read Advertise


Reply
 
LinkBack Thread Tools Display Modes
Old Mar 31st, 2014, 03:00 PM   #1
krs
Honourable Citizen
 
krs's Avatar
 
Join Date: Mar 2005
Location: Ontario and Quebec
Posts: 9,103
HELP Excel is driving me nuts when I try to enter data

Maybe someone has a solution - couldn't find anything via google.

I have a large spreadsheet in Excel 2004

Now, when I want to enter text in a new cell towards the bottom of the spreadsheet, say cell C140, the whole spreadsheet moves, looks as if it is going back to the home position, ie I have cell A1 at the top left as soon as I type the very first character of the new text entry.
I'm not hitting return or any thing else - happens invariably as I enter the first character of the text into that new cell.
If I continue to type the rest of the entry in the spreadsheet it completes but I can't see the cell.
And to type the next entry I have to scroll down again.

I googled for this - nothing
I went through all the Excel preferences - there doesn't seem to be anything that relates directly to an action as soon as one types any character into a new cell.

Any ideas how toprevent this type of operation?
I just want to stay wherever I'm typing.
krs is offline   Reply With Quote
Sponsored Links
Advertisement
 
Old Mar 31st, 2014, 03:25 PM   #2
Full Citizen
 
Join Date: Jul 2004
Location: Oakville, ON
Posts: 602
Any macros?
WCraig is offline   Reply With Quote
Old Mar 31st, 2014, 04:20 PM   #3
Honourable Citizen
 
pm-r's Avatar
 
Join Date: May 2009
Location: Brentwood Bay BC
Posts: 13,915
Try selecting and highlight the whole row or the row under the one you want to freeze and then from the window menu, select freeze panes I think is the option.

Maybe that will help keep things in place so that you can type in the cell you want properly.
pm-r is offline   Reply With Quote
 
Old Apr 1st, 2014, 01:02 AM   #4
krs
Honourable Citizen
 
krs's Avatar
 
Join Date: Mar 2005
Location: Ontario and Quebec
Posts: 9,103
Quote:
Originally Posted by WCraig View Post
Any macros?
No, no macros
krs is offline   Reply With Quote
Old Apr 1st, 2014, 01:07 AM   #5
krs
Honourable Citizen
 
krs's Avatar
 
Join Date: Mar 2005
Location: Ontario and Quebec
Posts: 9,103
Quote:
Originally Posted by pm-r View Post
Try selecting and highlight the whole row or the row under the one you want to freeze and then from the window menu, select freeze panes I think is the option.

Maybe that will help keep things in place so that you can type in the cell you want properly.
Thanks,

That freeze pane option solved my problem.
I never thought to look there - I was just checking all the FF preferences

I still don't know what these "unfrozen" panes are good for - seems to me the implementation was done wrong.
Why would anyone want to automatically go back to the top left part of the spreadsheet whenever one types one character into a cell?
Doesn't make any sense to me.
krs is offline   Reply With Quote
Old Apr 1st, 2014, 12:40 PM   #6
Honourable Citizen
 
pm-r's Avatar
 
Join Date: May 2009
Location: Brentwood Bay BC
Posts: 13,915
Hmmm... "...I was just checking all the FF preferences..." ???
FF to me = Firefox. No Excel settings there.

But good to hear that fixed the problem.

I don't know why some developers do some of the things they do, I just recalled a local MacBook user having some Excel spreadsheet jumping around problems that made entering data almost impossible some years ago and we discovered the freeze thing and decided to give it a try.

I guess things might work differently with a large spreadsheet on a huge big display.
pm-r is offline   Reply With Quote
Old Apr 1st, 2014, 03:47 PM   #7
krs
Honourable Citizen
 
krs's Avatar
 
Join Date: Mar 2005
Location: Ontario and Quebec
Posts: 9,103
Quote:
Originally Posted by pm-r View Post
Hmmm... "...I was just checking all the FF preferences..." ???
FF to me = Firefox. No Excel settings there.
Sorry, I should have been Excel preferences.
I'm just so focussed on FF right now to see it that firefox, small f process is coming back (different thread on ehMac)

Quote:
But good to hear that fixed the problem.

I don't know why some developers do some of the things they do, I just recalled a local MacBook user having some Excel spreadsheet jumping around problems that made entering data almost impossible some years ago and we discovered the freeze thing and decided to give it a try.

I guess things might work differently with a large spreadsheet on a huge big display.
My spreadsheet is actually rather small, 124 rows and 36 rather wide columns, screen is not huge but at a full 24 inches (1920x1200) not small either - both pretty average I would say.
krs is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adobe Reader driving me nuts. kps Mac, iPhone, iPad and iPod Help & Troubleshooting 15 Jan 5th, 2010 11:43 AM
White Screen crash... csonni Mac, iPhone, iPad and iPod Help & Troubleshooting 2 Sep 29th, 2007 06:10 PM
April 16th - 22nd - Computation's FREE Earth Week Computer Recycling in Montreal & TO gmug Everything Else, eh! 2 Apr 19th, 2007 08:01 AM


All times are GMT -4. The time now is 08:52 AM.



Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
vBulletin Security provided by vBSecurity v2.2.2 (Pro) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
Copyright 1999 - 2012, ehMac.ca All rights reserved. ehMac is not affiliated with Apple Inc. Mac, iPod, iTunes, iPhone, Apple TV are trademarks of Apple Inc. Content Relevant URLs by vBSEO 3.6.0 RC 2

Tribe.ca: Urban living in Toronto!