Data into a data sheet from a list

  • Thread starter Thread starter oa501
  • Start date Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Data validation list from table 6
Excel Help to copy information from one row at a time to another sheet 1
using the =page! feature to transpose a row to column 0
Segrigation of different datas from one colum 1
Data Validation 1
Dynamic name range for use in data validation 1
Vlookup? populate 3 columns of data when match a common value, 1

Back
Top