Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 43
Default cursor in cell 3000+ rows down. why?

I consider myself an excel power user but this has me stumped. Whenever I'm
working with a workbook with multiple tabs and I tab from one to another, a
strange thing often (but not always) happens. It will show the worksheet with
A1 in the upper left corner, normal as you please. But when I hit, for
instance, the right arrow key, it moves me from cell A3284 to cell B3284. It
does this in most if not all files I work with. Why is A3284 the presumed
"live" cell when I tab to a new worksheet? Once I have moved the "live" cell
to my actual work area, it seems to remember it until I close the file and
open it the next time, when it starts all over.

What gives?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 860
Default cursor in cell 3000+ rows down. why?

Hi Travis,

Used range in your template perhaps?
Take a look here.
http://www.contextures.com/xlfaqApp.html#Unused

HTH
Martin


"Travis" wrote in message
...
I consider myself an excel power user but this has me stumped. Whenever I'm
working with a workbook with multiple tabs and I tab from one to another,
a
strange thing often (but not always) happens. It will show the worksheet
with
A1 in the upper left corner, normal as you please. But when I hit, for
instance, the right arrow key, it moves me from cell A3284 to cell B3284.
It
does this in most if not all files I work with. Why is A3284 the presumed
"live" cell when I tab to a new worksheet? Once I have moved the "live"
cell
to my actual work area, it seems to remember it until I close the file and
open it the next time, when it starts all over.

What gives?



  #3   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default cursor in cell 3000+ rows down. why?

sounds like there might be a macro which runs when you close out and does
something to each sheet.
Is this all workbooks, or just one workbook?
the sheet to which it opens, iis it the same sheet each time or a
differtent sheet depending on when you saved it.
additionaly do you save the workbook when you close it?


"Travis" wrote:

I consider myself an excel power user but this has me stumped. Whenever I'm
working with a workbook with multiple tabs and I tab from one to another, a
strange thing often (but not always) happens. It will show the worksheet with
A1 in the upper left corner, normal as you please. But when I hit, for
instance, the right arrow key, it moves me from cell A3284 to cell B3284. It
does this in most if not all files I work with. Why is A3284 the presumed
"live" cell when I tab to a new worksheet? Once I have moved the "live" cell
to my actual work area, it seems to remember it until I close the file and
open it the next time, when it starts all over.

What gives?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 43
Default cursor in cell 3000+ rows down. why?

I think bj nailed it. I thought it was all workbooks because it has been
happening frequently, but I think it was just one workbook that I have been
referring to frequently (but not saving when I close it) -- that would
explain why I couldn't find a "global" fix. It also explains why it happens
frequently but not always. I had apparently selected a range of multiple
worksheets in this one file and when I saved it for the last time many months
ago, the cursor was in cell a3284 (for whatever weird reason). Since it's a
dormant project and I no longer save the file when I close it, it opens with
the cursor in a3284 of every sheet every time I open it.

Thanks for your thoughts bj and Martin.

"bj" wrote:

sounds like there might be a macro which runs when you close out and does
something to each sheet.
Is this all workbooks, or just one workbook?
the sheet to which it opens, iis it the same sheet each time or a
differtent sheet depending on when you saved it.
additionaly do you save the workbook when you close it?


"Travis" wrote:

I consider myself an excel power user but this has me stumped. Whenever I'm
working with a workbook with multiple tabs and I tab from one to another, a
strange thing often (but not always) happens. It will show the worksheet with
A1 in the upper left corner, normal as you please. But when I hit, for
instance, the right arrow key, it moves me from cell A3284 to cell B3284. It
does this in most if not all files I work with. Why is A3284 the presumed
"live" cell when I tab to a new worksheet? Once I have moved the "live" cell
to my actual work area, it seems to remember it until I close the file and
open it the next time, when it starts all over.

What gives?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
auto hiding rows under category heading unless cursor clicks on to Daniel R Excel Discussion (Misc queries) 0 April 4th 07 06:12 PM
i have a list of 3000 zip codes, can i convert to city, st format Richardw Excel Worksheet Functions 2 December 7th 06 02:36 PM
shift the cursor down 2 rows please. Steved Excel Worksheet Functions 2 May 25th 06 07:09 AM
how i do to make a self filter in more than 3000 lines? V. Ivanov Excel Worksheet Functions 1 January 19th 06 03:06 PM
How do I get spellcheck for my MSN e-mail on Dell Dimesnion 3000 [email protected] Excel Discussion (Misc queries) 0 October 19th 05 06:27 PM


All times are GMT +1. The time now is 08:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"