Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 20th 05, 04:34 PM
BorisS
 
Posts: n/a
Default dragging without interference

In my Excel 2002, I am finding that when I am trying to drag a set of cells
right, at the lower right of the area is this "helpful" dropdown box, which
gives me options like "fill, fill with format" or some other crap. I don't
want it, because it places itself right where the lower right drag corner is.
How do I get rid of that little box. It also appears when there are
incosistent formulas across a row or down a column, and I don't want it there
either.
--
Boris

  #2   Report Post  
Old May 20th 05, 04:40 PM
N Harkawat
 
Posts: n/a
Default


"BorisS" wrote in message
...
In my Excel 2002, I am finding that when I am trying to drag a set of
cells
right, at the lower right of the area is this "helpful" dropdown box,
which
gives me options like "fill, fill with format" or some other crap. I don't
want it, because it places itself right where the lower right drag corner
is.
How do I get rid of that little box. It also appears when there are
incosistent formulas across a row or down a column, and I don't want it
there
either.
--
Boris



  #3   Report Post  
Old May 20th 05, 04:42 PM
N Harkawat
 
Posts: n/a
Default

Go to
Tools--options--Error checking--
and uncheck the "enable background checking"
and all the choices under Rules

"BorisS" wrote in message
...
In my Excel 2002, I am finding that when I am trying to drag a set of
cells
right, at the lower right of the area is this "helpful" dropdown box,
which
gives me options like "fill, fill with format" or some other crap. I don't
want it, because it places itself right where the lower right drag corner
is.
How do I get rid of that little box. It also appears when there are
incosistent formulas across a row or down a column, and I don't want it
there
either.
--
Boris



  #4   Report Post  
Old May 20th 05, 08:16 PM
Gord Dibben
 
Posts: n/a
Default

For the first requirement.......

ToolsOptionsEdit uncheck "show paste options buttons".

And "show insert option buttons"


Gord Dibben Excel MVP

On Fri, 20 May 2005 11:42:14 -0400, "N Harkawat" wrote:

Go to
Tools--options--Error checking--
and uncheck the "enable background checking"
and all the choices under Rules

"BorisS" wrote in message
...
In my Excel 2002, I am finding that when I am trying to drag a set of
cells
right, at the lower right of the area is this "helpful" dropdown box,
which
gives me options like "fill, fill with format" or some other crap. I don't
want it, because it places itself right where the lower right drag corner
is.
How do I get rid of that little box. It also appears when there are
incosistent formulas across a row or down a column, and I don't want it
there
either.
--
Boris





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
Dragging formulas Ben Greenwood Excel Worksheet Functions 7 July 12th 07 06:04 PM
Dragging year - Ajit Ajit Munj Excel Discussion (Misc queries) 2 February 23rd 05 07:24 AM
Dragging Across Yasmeen Excel Discussion (Misc queries) 2 February 15th 05 01:39 PM
Copy and dragging cells Alex Jacinto Excel Worksheet Functions 1 November 10th 04 09:19 PM
VLOOKUP dragging down Ozlem Excel Worksheet Functions 1 November 8th 04 06:13 PM


All times are GMT +1. The time now is 12:07 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017