by Anonymous on July 11th, 2009

Anonymous

Question

Help answer this question below.

I want to take a list of names in a column in one spread sheet and copy them into a row on another spread sheet please help

  • Like
  • Report

Answers. 4 helpful answers below.

  • by Bull wears a COAT of many colours on July 11th, 2009

    Bull wears a COAT of many colours

    Highlight the ones that you want to copy. Press the control and c keys together. Go to the place that you want to insert them. Press the control and v keys together.

    • Like
    • Report

    1 comment | Post one | Permalink

  • by Brian I on July 12th, 2009

    Brian I

    Select and copy the data.
    Switch to the other spreadsheet and select the cell you want the first item of data to appear.
    Go to the Edit... Paste Special menu.
    Put a check mark in the 'Transpose' box and click OK.

    • Like
    • Report

    1 comment | Post one | Permalink

  • by Over and Out on July 11th, 2009

    Over and Out

    Highlight the row of names to copy, click on Edit, Copy from the menu, paste in the proper row on the other spread sheet.

    • Like
    • Report

    No comments. Post one | Permalink

  • by genius-bag on July 11th, 2009

    genius-bag

    can you not just copy and paste?

    • Like
    • Report

    No comments. Post one | Permalink

Want to attach an image to your answer? Click here.

Did this answer your question? If not, then ask a new question or create a poll.

You're reading I want to take a list of names in a column in one spread sheet and copy them into a row on another spread sheet please help

Follow us on Facebook!

Related Ads

ANSWERBAG BUZZ

A column of names into a list of names