View original (French)

Re-enable automatic cell content increment by dragging

Solved
Sinequanone -  
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

  • Votes
  • Date
  • Descending date
  1. michel_m Contributor
    Hello,

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


    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!
    2. michel_m Contributor
      check if by any chance it's checked


      also check in the options if you're set to automatic calculation
    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 ;-)