Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel,;,microsoft.public.excel.misc
Tcs
 
Posts: n/a
Default Help!

I'm using Excel 2k on XP, SP1...

My problem is that I did something to lock (for lack of a better word) a
particular cell. (No, I didn't do this on purpose.) Now, whenever I click on
another row, Excel highlights all the rows from (and including) that "locked"
cell, to the row on which I just clicked. If I click on a row in just another
column, Excel highlights the range of cells from my "locked" cell to the cell on
which I just clicked. In other words, Excel always makes sure that the "locked"
cell creates a 'range' of highlighted cells from where I really am.

Since I don't know if this is normal, and I don't know what it's called, I don't
know how to look it up in help to see what it is, and how to turn it off.

I tried closing my spreadsheet, then opening it again. Doesn't work. Excel
still remembers my "locked" cell. When I rebooted my PC however, Excel forgot
about the "locked" cell, and I could continue my work.

Is this some normal feature of Excel that I've managed to turn on by accident?
If so, what's it called? And how do I turn it off?

Thanks in advance,

Tom
 
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



All times are GMT +1. The time now is 05:49 AM.

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

About Us

"It's about Microsoft Excel"