Copy certain date to worksheet

**annielizs** · 12-13-2010, 02:45 PM

Hello,

I have an excel file with 8 worksheets in it, it lists products, prices, and has a formula so you can enter in the number of products and get the total price. I need to be able to copy some of these cells (certain products for different proposals) to another worksheet or a word document. When I try to simply copy and paste the cells, it pastes all of the cells between the two that I want, not just the two that are selected, and I'm not sure why.
I'm using Excel 2007. Any help is greatly appreciated. Thank you.

**Avinash Beepath** · 12-13-2010, 02:48 PM

After selecting the columns, hit [F5] and then Special then hit Visible cells only. this would select only what u selected on screen.

**Cheeky Charlie** · 12-13-2010, 02:49 PM

Hold control, not shift, when clicking the individual cells you want to copy.

hth

**annielizs** · 12-13-2010, 03:02 PM

Ok, I tried hitting F5 and doing the "visible cells" thing and it isn't working, it's still pasting all of the cells between the two lines that are selected. And I'm also using ctrl, not shift so I'm not sure why this is happening.

**Avinash Beepath** · 12-13-2010, 04:09 PM

how exactly are you trying to select the rows/columns? Did you hide the columns you didnt want to select? that selecting Visible option would only work if you hide the columns you didnt want to select.

**annielizs** · 12-13-2010, 04:32 PM

No, I haven't hidden anything...I'm just looking for the easiest way to move selected information from one worksheet to another. When I copy and paste it takes everything between the two selected cells of text, not just the two cells that are selected. How do I just copy the cells that I have selected?