| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data into a data sheet from a list
Is it possible for me to enter data from a list unto a colum rather than just
one cell. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data into a data sheet from a list
Suppose you have your list in A1:A20 and you want the first 10 items
in column C. Highlight the cells C1:C10 with C1 as the active cell, then begin to enter the formula =A1 into C1 but press CTRL-Enter instead of just Enter. This will copy the formula down the highlighted cells to give you what you wanted (I think). Hope this helps. Pete On Apr 28, 10:26*am, oa501 wrote: Is it possible for me to enter data from a list unto a colum rather than just one cell. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data into a data sheet from a list
Probably.
Is the data currently all in one cell or? Gord Dibben MS Excel MVP On Mon, 28 Apr 2008 02:26:00 -0700, oa501 wrote: Is it possible for me to enter data from a list unto a colum rather than just one cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to compare a list of data that is same as the main data sheet | New Users to Excel | |||
| Can I make a list, on one summary sheet, of data collected from ma | Excel Worksheet Functions | |||
| List matching data from sheet 1 in sheet 2 | Excel Worksheet Functions | |||
| adding data from one sheet to another sheet as a dropdown list bo. | Excel Discussion (Misc queries) | |||
| How do I get a list of data on one sheet into the form on the fir. | Excel Discussion (Misc queries) | |||
Linear Mode
