View original (French)

Re-enable automatic cell content increment by dragging

Solved
Sinequanone -  
michel_m Posted messages 18903 Registration date   Status Contributeur 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 réponses

Réponse 1 / 3
michel_m Posted messages 18903 Registration date   Status Contributeur 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
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
michel_m Posted messages 18903 Registration date   Status Contributeur 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
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