Thread: how do make values display in increments of 1?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default how do make values display in increments of 1?
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

On Thu, 22 Oct 2009 16:50:01 -0700, Kira
wrote:

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.

Reply With QuoteReply With Quote