Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2007

Tip: Looking for answers? Try searching our database.

RemoveStar on mouse, using Excel  draging Formula etc.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
robo9763 - 14 Apr 2007 20:08 GMT
When I point to a cell to drag it or add a list of consecutive numbers or
drag my formula to adjacent cells  this *&^@^ star appears instead of the
usual pointer. It messes up everything , Please tell me how to get rid of it.
----------an octegenarion amateur!

P.S. I'm using Excel in Office 2003
Gord Dibben - 14 Apr 2007 22:44 GMT
A star generally has 5 points.

I cannot think of any Excel pointer that has 5 points.

Perhaps a better description of the figure and what it does to mess things up.

Does it prevent dragging cells or formulas?

Gord Dibben  MS Excel MVP

>  When I point to a cell to drag it or add a list of consecutive numbers or
>drag my formula to adjacent cells  this *&^@^ star appears instead of the
>usual pointer. It messes up everything , Please tell me how to get rid of it.
>----------an octegenarion amateur!
>
>P.S. I'm using Excel in Office 2003
robo9763 - 14 Apr 2007 23:24 GMT
> A star generally has 5 points.
>
[quoted text clipped - 14 lines]
>
> Dear Gord,   Thank you for answering my request, this has been driving me crazy since  the shop "did me a favour "and loaded Office 2003 in my computer.  I was doing reasonably well with Office 97 . What I called  a star is really the same small cross with an arrowhead at the end of each arm, not + anymore. This (cross arrowhead+ ) appears whenever I try to copy or drag the formula that is in the cell, by clicking on the bottom right
corner.  When I go ahead and use the arrowheaded monstrosity, nothing is
accomplished it does not transfer formula or drag it or do anything, that I
can see anyway, but I used to think the action was done OK.
       I hope this is clearer  and that you have a remedy,
Thanking you in advance ,  Bob Troutman
Dave Peterson - 14 Apr 2007 23:45 GMT
Do you see that same "star" when you hover over the edged of a selected cell?

Do you see the "autofill button" (the little square thingy) in the bottom right
corner of the selection?

I'm guessing that you don't.  And if I'm right, try:
tools|options|Edit tab|check allow cell drag and drop

> > A star generally has 5 points.
> >
[quoted text clipped - 19 lines]
>         I hope this is clearer  and that you have a remedy,
> Thanking you in advance ,  Bob Troutman

Signature

Dave Peterson

Gord Dibben - 14 Apr 2007 23:56 GMT
The 4-headed cross with the arrowheads is the default cursor when you hover over
the edges of a cell.

This allows you to move the cell to another location.

Does this not occur?  What happens if you double-click on that arrowhead?

Cursor should move to last cell in column or row depending upon which edge you
clicked on.

Do you see a small black lump at the bottom right corner of the cell?

This is known as the "fill handle" and you click on that to drag/copy cells.

Are you saying that the normal fat white cross never shows up anywhere?

Gord

>> A star generally has 5 points.
>>
[quoted text clipped - 19 lines]
>        I hope this is clearer  and that you have a remedy,
>Thanking you in advance ,  Bob Troutman
robo9763 - 15 Apr 2007 20:20 GMT
> The 4-headed cross with the arrowheads is the default cursor when you hover over
> the edges of a cell.
[quoted text clipped - 15 lines]
>
> >NEW MESSAGE  Dear Gord,  
        I,m glad you saw my 2nd note to you and thanks for answering.
 Yes I have that large white cross, it shows up during initial hovering
after (1) left click, it's OK.
        Now I see what that 4-head thing is, it does appear on any edge and
it cuts the cell right out and deposits it where designated.
       I had forgotten all about that fill handle,like the skunk in the
wind, so if I ignore the 4-head monster and look for the fill button,and aim
for it,the desired black cross appears,more stable.
      I,ve been practicing this, it seems all right, it seems to me that
4-head could be dangerous can it be turned off do you think?
      Anyway, thank you very much, this has been driving me to senility,
and I 've spent a few hours going thru Help etc. trying to find something
that refers to it so I can get rid of it.   It is still a nuisance while it's
blotting everything out, but now I know where to look for handle and what to
avoid.
                                                                   
Sincerely,
                                                                       Bob
Troutman      
                                                                           
Victoria B.C
                                                                           
                                                                             
                                                                             
           .

> >> A star generally has 5 points.
> >>
[quoted text clipped - 19 lines]
> >        I hope this is clearer  and that you have a remedy,
> >Thanking you in advance ,  Bob Troutman
Gord Dibben - 16 Apr 2007 01:33 GMT
I don't know how to turn the 4-headed cross off except to disable drag and drop,
which will also disable the fill handle.

I wouldn't say it is any more dangerous than many other functions that can mess
up your data, like doing a Sort without selecting all columns or "merging" cells

Keep up the practicing and you'll get the hang of it.

Gord....................from up the street at Parksville, B.C.

>> The 4-headed cross with the arrowheads is the default cursor when you hover over
>> the edges of a cell.
[quoted text clipped - 64 lines]
>> >        I hope this is clearer  and that you have a remedy,
>> >Thanking you in advance ,  Bob Troutman
Dave Peterson - 14 Apr 2007 23:47 GMT
Ahem, The Star of David.

(Named after many of the "David" contributors in the *excel* newsgroups!)

> A star generally has 5 points.
>
[quoted text clipped - 12 lines]
> >
> >P.S. I'm using Excel in Office 2003

Signature

Dave Peterson

Dave Peterson - 14 Apr 2007 23:48 GMT
Yes, I've heard of the Gordian Knot, but that's a different pointer!

> A star generally has 5 points.
>
[quoted text clipped - 12 lines]
> >
> >P.S. I'm using Excel in Office 2003

Signature

Dave Peterson


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.