how do I disable the option that keeps incrementing cells by 1?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

An option has been pre-set that I am trying to disable. Every time I drag a
group of cells across, some of the cells are automatically incremented by 1
when all I want is the exact number to drag across.
 
Right-click and drag.

Release button and select "Copy Cells" from the options.


Gord Dibben MS Excel MVP
 

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

Similar Threads

Dragging across columns: I want column constant, but row increment 6
increment cells in repeating formulas by something other than 1 8
Incrementing Formula by Column Instead of by Row 1
number cell increment +1 when dragging down box 4
Formula for Next Sheet and Every Other Cell 12
Incrementing, Even Though Formatted As Text: Why ? 6
Auto-increment cell values by one 2
Drag without incrementing 2

Back
Top