Software

Ask something
Discussion Locked

Excel Copying and Pasting

0 helpful
9 replies

by layland

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have built an Excel spread sheet. In the spreadsheet I have data, cells outlined and some formulas. My question is, when I copy the worksheet and try to paste into another worksheet (not the same one) only the outlines will show, the data will notcopy over into the new worksheet. Any suggestions? Thanks for your time.

9 replies

by dreamboat

If your data has underlying formulas, perhaps the formulas are not working when they link to the cells in the new wooksheet/book. Try copying, then on new worksheet/book, hit Edit-Paste special-Values.

~Dreamboat
www.thewordexpert.com

by syscokid

Hi, I don't have an answer, I just wanted to say hello to Dreamboat. Hello! Welcome to TR.

Believe me, there's nothing about Office she doesn't know.

by dklippert

You can create a copy of the worksheet by right-clicking the sheet tab and choosing Move or Copy ... If you're going to copy, be sure to put a check mark in the "Create a copy box"

I, too, would like to say hello to Dreamboat. I have a link to WWW.TheWordExpert.com handy at all times.

by applenmango

Hi,

What you could do is click on drop down menu
1. Edit,
2. then click move or copy sheet,then a dialoge box appear, say move or selected sheet to Books :
3. then type in new book
4. before sheets:- click on sheet one,
5. tick check box -creat a copy
5. then click OK.

This will give you a copy of work sheet including all the formulas and data.

Hope it help!

Apple N mango

This discussion is closed to new replies.