Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to automatically populate a cell?
As for your specific request, go to T1 enter"=" and click "A1".
This way upon entering a data into A1, it will be automatically entered to T1 as well. If you want to repeat it for other rows in column T, drag the T1 up to desired row. Is this you question? "RW" wrote: Is there a way to automatically populate a cell with the same data that is entered into a different cell? Say for example I have a 20 column wide spreadsheet. When I enter data into the cell at row 1, column 'A', I want that data to automatically be entered into the cell at row 1, column 'T'. Can this be done? Can I link entire columns? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to automatically populate a cell?
Thanks! That worked great for one cell but you lost me when you said "drag the T1 up to desired row". Will you explain that again please? "Khoshravan" wrote in message ... As for your specific request, go to T1 enter"=" and click "A1". This way upon entering a data into A1, it will be automatically entered to T1 as well. If you want to repeat it for other rows in column T, drag the T1 up to desired row. Is this you question? "RW" wrote: Is there a way to automatically populate a cell with the same data that is entered into a different cell? Say for example I have a 20 column wide spreadsheet. When I enter data into the cell at row 1, column 'A', I want that data to automatically be entered into the cell at row 1, column 'T'. Can this be done? Can I link entire columns? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to automatically populate a cell?
Never mind Khoshravan. I figured it out. Thanks again!
"RW" wrote in message ... Thanks! That worked great for one cell but you lost me when you said "drag the T1 up to desired row". Will you explain that again please? "Khoshravan" wrote in message ... As for your specific request, go to T1 enter"=" and click "A1". This way upon entering a data into A1, it will be automatically entered to T1 as well. If you want to repeat it for other rows in column T, drag the T1 up to desired row. Is this you question? "RW" wrote: Is there a way to automatically populate a cell with the same data that is entered into a different cell? Say for example I have a 20 column wide spreadsheet. When I enter data into the cell at row 1, column 'A', I want that data to automatically be entered into the cell at row 1, column 'T'. Can this be done? Can I link entire columns? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to automatically populate a cell?
Glad to hear that you find the reply yourself. Dragging the left-bottom point
of a cell, is a method to copy the embeded formula across the column or raw. You should know about relative and absolute reference method, uopn using this method. "RW" wrote: Never mind Khoshravan. I figured it out. Thanks again! "RW" wrote in message ... Thanks! That worked great for one cell but you lost me when you said "drag the T1 up to desired row". Will you explain that again please? "Khoshravan" wrote in message ... As for your specific request, go to T1 enter"=" and click "A1". This way upon entering a data into A1, it will be automatically entered to T1 as well. If you want to repeat it for other rows in column T, drag the T1 up to desired row. Is this you question? "RW" wrote: Is there a way to automatically populate a cell with the same data that is entered into a different cell? Say for example I have a 20 column wide spreadsheet. When I enter data into the cell at row 1, column 'A', I want that data to automatically be entered into the cell at row 1, column 'T'. Can this be done? Can I link entire columns? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to automatically populate a cell? | New Users to Excel | |||
User Name Automatically Populate | Excel Worksheet Functions | |||
make dates automatically populate a cell on different worksheets | Excel Worksheet Functions | |||
How to automatically populate the next available invoice # | Excel Worksheet Functions | |||
make a cell automatically populate with "1" when specified cell va | Excel Discussion (Misc queries) |