| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do make values display in increments of 1?
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| some cells display formulas, some display values | Excel Discussion (Misc queries) | |||
| Make one row a constant display? | Excel Discussion (Misc queries) | |||
| Can I make multiple room scheduler (Excel) 15 minute increments? | Excel Discussion (Misc queries) | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
| How do I make this display a "0" value | Excel Discussion (Misc queries) | |||
Linear Mode
