how do make values display in increments of 1?

K

Kira

Without me having to type the values myself, let's say that I want to use the
fill handle to do this instead. I want the numbers to increase in increments
of 1 in cells c10-L10.
 
G

Gord Dibben

Enter 1 in C10

Right-click on the fill handle and drag across to L10

Release button and "Fill Series"


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

Calculate the median value before a specified list 0
Drag without incrementing 2
Need VBA Macro to Loop through pages and print counter in footer of each page 9
Filling In A Column With Incrementing Values ? 2
Finding the proper style field and the numbered paragraph value within the style 0
VBA Coding Help for Beginner 0
Finding the right style field in VBA 0
Incrementing amounts when text is used 4

Top