Hi ronmjo,

There are a number of ways you could do this:

If the number you enter won't change much, you can simply copy it to the
other cells by either clicking on the cell you want to copy and point to the
lower right corner of the cell so that your cursor changes to the + symbol.
Then click and drag that across the columns you want to copy to and Excel
will place that data in the columns.

The other way to do the copy & paste to a range is to right click on the
data you want to copy, select "Copy" from the menu, then highlight the range
of cells you want to fill with the data, right click and select "Paste".

If the budget data will be changing and you want the other cells to update
automatically, use a formula to copy the data. For example, if the budget
lines are on separate rows and the months are in columns and the first budget
data is in cell A5 and subsequent months for this data are in B5, C5, etc.,
then do this:

In the first cell of this row (B5), place this formula: =$A5
Now click on this cell and copy it (by dragging) to all the other cells in
this row and the rows below it. The "$" tells Excel to always look at column
A for the data, but Excel will change the row to match the row that the cell
is in.

Now as you enter the data in each cell of column A, it will automatically be
copied to the adjacent cells to the right, where the formlaes are.

Hope that makes sense.

Henry Falk

"ronmjo" wrote:

Lets say you are doing a budget for 12 months. You input a number in the
first month (jan) and you want to carry that same number to each month for
the rest of the year. What is the automatic way to do that. I should be able
to tell it to copy, hit a button and it will copy to the range I have.