A number of ways:

Select cell B1. Edit/ Copy (or CTRL-C). Select cells B2 to B225. Edit/
Paste (or CTRL-V).
or
Hover the cursor over the bottom right-hand corner of cell B1 so that the
pointer turns to a + sign. Click, & while holding the mouse button down
drag that + sign down across cells B2 to B225.

You did say you were a newbie, so perhaps you need some Excel basics
training, either a book such as "Excel for Dummies" or a basic course
(either on-line or elsewhere)? If you're after a recommendation for such
instruction, you might try the microsoft.public.excel.newusers newsgroup.
--
David Biddulph

"kalai" wrote in message
oups.com...
thanks for ur reply. actually u want me copy the formula in each and
every row upto the one i needed, which is specific to one particular
row and column. but what i wanted is a single formula or that need to
written once for whole of the two columns. the data entry may goes
upto nth row which i did not know. so whenever i enter a value in a
row say a225, the corresponding value should be reflected in b225.
Is there any workaround for this.

On Aug 16, 4:55 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
In B1 put the formula =A1
If you want B1 to stay blank until A1 is filled in, then use
=IF(A1="","",A1)

Copy down as far as you like.

"kalai" wrote in message

ups.com...
I am a newbie. how could map two columns in excel.

For example column a to column b. If i enter any value in any row of
column a that should be reflected in corresponding row of column b.
Please help me in this regard.