Cell incremental increase

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

Guest

Is there anyway to turn this feature off within cells? In other words, I
want to drag the contents of one cell, Fall 06, for example, and keep that
value instead of Excel increasing the number by 1 with each successive cell;
07, 08, etc.

Thanks
 
One way. Just do a right-click drag down on the fill handle (instead of the
usual left-click drag down), then choose "Copy Cells" from the menu pop up
 
Is there anyway to turn this feature off within cells?

Hi. To turn it off, hold the Ctrl key as you drag the cell down. :>)
 

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

Back
Top