Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Type it once, copy, and paste it into the remaining rows- unless the
rows are not contiguous. How is the data arranged? |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Word tables to Excel | Excel Discussion (Misc queries) | |||
How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
Embedded word doc changed to image-need to change back to word. | Excel Discussion (Misc queries) | |||
Hyperlink to a word document | Excel Discussion (Misc queries) | |||
Hyperlink to word document problem | Links and Linking in Excel |