Thread: Filling in Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Filling in Data

Hi,

Try this and enter data into cells

A1=50
a10=600

Select A1 to A10 then

Edit|Fill|Series
Ensure 'Columns' and 'Linear' are selected and Excel will work out the step
for a linear growth from 10 to 600.
OK
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Jamie" wrote:

I have several points where I need data. I only have the start and the end
values and I want to fill in each of the points between the two. How is that
accomplished.

Example. Point 1 = 50, Point 10 = 600. I need Points 2-9.