select and drag: sequencing numbers doesn't work

H

Hans

Hi, a user has a problem with the following: when, in a
worksheet, he selects numbered cells in a column and drags
the black cross down, Excel keeps writing the same numbers
again and again, instead of sequencing them. The sheet has
Autofilter switched on. I advised to switch off Autofilter
and switch it on when finished. This only helped in
certain files and ranges.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top