how to put(repeat 7000times) the word "available" in a column
 

I have 7000items in excel worksheet and I want to write the word "available"
in the end of each line, please help me

Hi

select your 7000 lines by typing the range in the name box (little box to
left of formula bar above the letter A)
e.g.
h1:H7000
and press enter
this will select all the cells for you
now type (don't click anywhere just type)
available
and press control & enter
this will put it into each selected cell.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"eksel" wrote in message
...
I have 7000items in excel worksheet and I want to write the word
"available"
in the end of each line, please help me

Hi
Alongside the first one, type 'Available' in the next column. Once done,
reselect the cell and double-click the little square in the bottom
right-hand corner of the cell. This will autofill it all the way down to the
bottom.
Another way is to select the range you want to fill, type 'Available' and
hit Ctrl+Enter.

--
Andy.


"eksel" wrote in message
...
I have 7000items in excel worksheet and I want to write the word
"available"
in the end of each line, please help me

Type it once, copy, and paste it into the remaining rows- unless the
rows are not contiguous. How is the data arranged?

One easy way would be to use a help column, assume the text you want to add
to is in A1:A7000, insert a new column B, in B1 put

=A1&" available"

press enter, reselect the B1 again and move the mouse pointer to the lower
right corner of B1, it should change from a fat cross to a thin, then double
click
and copy down, while selected, copy the range and paste special as values in
place, delete column A and it will be replaced by B


Regards,

Peo Sjoblom


"eksel" wrote:

I have 7000items in excel worksheet and I want to write the word "available"
in the end of each line, please help me