Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
Jill D Lennon LLC
 
Posts: n/a
Default Unable to update a spreadsheet

I am guessing I have accidentally set something wrong but hoping someone can
tell me what it is. I open a spreadsheet - any spreadsheet and am unable to
"focus" on a cell. I end up with the plus sign the minute I click anywhere
and after that - everything just paints like I am trying to do a huge "mark".
I am unable to get out of this mode. It happens with spreadsheets I have had
for a while or even if I try to create a new one. I have tried repairing
Excel with my install disk but same thing happens. Has anyone else gotten
into this trouble? Adeas how to get out? At present - Excel is totally
unusable. Thanks in advance!
  #2   Report Post  
Posted to microsoft.public.excel.setup
Gord Dibben
 
Posts: n/a
Default Unable to update a spreadsheet

Jill

A common cause of this is that you are in "Extended" or "Add" mode.

If you see "EXT" or "ADD" down on the status bar try hitting F8 key a couple
of times.

F8 will will toggle you in and out of Extended mode. SHIFT + F8 will put you
in "ADD" mode.

With the "ADD" mode you need to re-click the mouse. This is used to select
non-contiguous cells and ranges without using the CTRL key.

With the "EXT" mode you just click once and drag. All cells will be selected.

If you are using a wheel-mouse tap the wheel a couple times.

Also see David McRitchie's "Ghosting" at

http://www.mvps.org/dmcritchie/excel/ghosting.txt


Gord Dibben Excel MVP

On Tue, 20 Dec 2005 09:16:04 -0800, "Jill D Lennon LLC" <Jill D Lennon
wrote:

I am guessing I have accidentally set something wrong but hoping someone can
tell me what it is. I open a spreadsheet - any spreadsheet and am unable to
"focus" on a cell. I end up with the plus sign the minute I click anywhere
and after that - everything just paints like I am trying to do a huge "mark".
I am unable to get out of this mode. It happens with spreadsheets I have had
for a while or even if I try to create a new one. I have tried repairing
Excel with my install disk but same thing happens. Has anyone else gotten
into this trouble? Adeas how to get out? At present - Excel is totally
unusable. Thanks in advance!

  #3   Report Post  
Posted to microsoft.public.excel.setup
Jill D Lennon LLC
 
Posts: n/a
Default Unable to update a spreadsheet

It was the wheel mouse! Thanks so much for the tips. It seems that Excel was
the only place that this was manifesting itself but I am now back in business.

"Gord Dibben" wrote:

Jill

A common cause of this is that you are in "Extended" or "Add" mode.

If you see "EXT" or "ADD" down on the status bar try hitting F8 key a couple
of times.

F8 will will toggle you in and out of Extended mode. SHIFT + F8 will put you
in "ADD" mode.

With the "ADD" mode you need to re-click the mouse. This is used to select
non-contiguous cells and ranges without using the CTRL key.

With the "EXT" mode you just click once and drag. All cells will be selected.

If you are using a wheel-mouse tap the wheel a couple times.

Also see David McRitchie's "Ghosting" at

http://www.mvps.org/dmcritchie/excel/ghosting.txt


Gord Dibben Excel MVP

On Tue, 20 Dec 2005 09:16:04 -0800, "Jill D Lennon LLC" <Jill D Lennon
wrote:

I am guessing I have accidentally set something wrong but hoping someone can
tell me what it is. I open a spreadsheet - any spreadsheet and am unable to
"focus" on a cell. I end up with the plus sign the minute I click anywhere
and after that - everything just paints like I am trying to do a huge "mark".
I am unable to get out of this mode. It happens with spreadsheets I have had
for a while or even if I try to create a new one. I have tried repairing
Excel with my install disk but same thing happens. Has anyone else gotten
into this trouble? Adeas how to get out? At present - Excel is totally
unusable. Thanks in advance!


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
Update Links problem andyp161 Excel Worksheet Functions 1 August 31st 05 04:19 PM
Scan and copy cells from one spreadsheet to another. Mark Excel Discussion (Misc queries) 1 April 6th 05 06:45 PM
Some exported records do not show on spreadsheet vulcan88 Excel Worksheet Functions 0 March 30th 05 01:11 AM
Applying Existing Password to New Spreadsheet Vic Excel Discussion (Misc queries) 1 January 27th 05 12:37 AM
#REF error on linked spreadsheet Randy Rich Links and Linking in Excel 0 December 15th 04 09:21 PM


All times are GMT +1. The time now is 10:05 PM.

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"