Re: What is the rule for dragging numbers to next cell?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Kevs,

The Excel help topic "About filling in data based on adjacent cells" has more examples of how this feature works. I think Microsoft used to call this behavior "intellisense" or something like that.

-Jim

--
Jim Gordon
Mac MVP
MVP FAQ
<http://mvp.support.microsoft.com/default.aspx?scid=fh;EN-US;mvpfaqs>


kevs wrote: 
Thanks again.
All very interesting.
You see how confusing this can be.
One moment, I put a number in a cell and drag down, and they stay the same
number.  Fine.

Then on another day, the numbers increase.  Cause was a dash...or something
else??

Of course I can get what I want with Option, but I just can't know anymore
when to use Option or not.  It's frustrating.












On 4/24/05 5:42 PM, in article uw66y#SSFHA.1528@xxxxxxxxxxxxxxxxxxxx, "Jim
Gordon MVP" <goldkey74@xxxxxxxxxxxxxxxxxxxxxx> wrote:


Ah yes!

Now that I understand what it is that Kevs is looking for I would like
to add that in addition to Excel trying to figure out patterns, you can
specify your own lists for Excel to use as patterns, too.

To do that, choose Excel > Preferences > Custom Lists.

-Jim 


OS 10.3.8
Office 2004


.

Relevant Pages

  • Re: Best practice to store/manipulate Excel spreadsheet cells
    ... and would adapt well to an irregular floor plan. ... is likely to be a better way of getting a "live" floor plan than Excel. ... part of an event managment database. ... 72 cells at top and 91 cells at the bottom with a height of 44 cells. ...
    (microsoft.public.access.formscoding)
  • All words and Symbols of keybord should be added to Auto Shapes
    ... Suggestions are both for Word and Excel where applicable. ... Transpose should have an extra facility to transpose the selected cells ... display begins in the second line and therefore we cannot see row name A, B, ... And more in a single selection at a time, then there will be no problem. ...
    (microsoft.public.excel.misc)
  • Re: Best practice to store/manipulate Excel spreadsheet cells
    ... 72 cells at top and 91 cells at the bottom with a height of 44 cells. ... excel to have squares properly... ... If it's a module in a database application and the "floor plans" are ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.formscoding)
  • Re: Best practice to store/manipulate Excel spreadsheet cells
    ... Duane's sample database uses the "tall narrow" approach. ... 72 cells at top and 91 cells at the bottom with a height of 44 cells. ... excel to have squares properly... ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.formscoding)
  • Re: Best practice to store/manipulate Excel spreadsheet cells
    ... 72 cells at top and 91 cells at the bottom with a height of 44 cells. ... excel to have squares properly... ... If it's a module in a database application and the "floor plans" are ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.formscoding)