View original (French)

Re-enable automatic cell content increment by dragging

Solved
Sinequanone -  
michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   -
Hello,

I can no longer perform an automatic increment by dragging my cursor down.
I would like to code them in the form NEW 001, NEW 002... NEW 00N, but I can only copy the content of my cell. I have tried going to Options / Advanced Options, but I don't know what exactly to reactivate.

Thank you for your help.
Configuration: Windows / Internet Explorer 11.0

3 answers

  1.
    michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    Hello,

    Normally, you need to click and hold on the small square at the bottom right of the first cell and drag


    0
    1. Sinequanone
       
      Thank you Michel,
      That's exactly what I usually do.
      Usually, I have a little extra with the different options (with incrementing, without incrementing, etc.). Here, I can only copy without any other possibility!
      -1
    2. michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
       
      check if by any chance it's checked


      also check in the options if you're set to automatic calculation
      2
    3. Sinequanone
       
      Michel,
      Yes yes, it's already done and unfortunately it didn't solve the problem.
      It just allows me to copy the content of the cell without the increment ;-)
      0