Computer problems,Computer help
*AX SOFT>>>Software

Can i copy Excel sheet w/ commands and formulas to a new sheet w/ the formulas and commands i have created?how

Because when I copy the whole thing and paste it to a new sheet, it seems that only the numbers are copied and not the formulas i used to achieve them...
Can you pls teach me how? I will be taking an Excel exam can you tell me what's in the exam usually?
pls pls pls...
thanks in advance

In general, Yes, you can copy an excel sheet to another sheet and get the formulas to copy over as well. It should work very simply, by copying and pasting, which you say you have tried.

For example, if on Sheet 1 you have a value of 8 in cell A1, and a value of 12 in cell B1, and you enter a formula of = A1 + B1 in cell C1, then C1 would display 20 and if you changed the value in either A1 or B1, then C1 would change along with it. If you then copied & pasted those 3 cells to Sheet 2, then everything should copy over just the same and operate independently.

The same is true for copying and pasting the entire sheet.

In your question above you mention the term "commands". What exactly is that? I sent you an e-mail about this.

If you would like to e-mail me your spreadsheet I will see if I can help you further. dave@share2help.com

Tags
　　General - Computers & Internet 　　Software 　　Security 　　Programming & Design 　　Facebook
Related information
  • Having a bit of computer problems?

    You could try opening them in Windows compatability mode, such as in '98 / 2000. Right click on the programme, go to properties > compatability > Run in comp.... However the best way ...

  • Ive got a windows problem called 'explorer.exe'?

    Explorer.exe is essential to the running of windows! I can't solve your problem because you haven't explained the problem well enough. BUT I WILL TELL YOU THIS the other answers before...

  • Every time i turn on my computer a program automatically opens up. how do i stop this from happening???

    see my video on windows tweaks on yourube ...

  • How can i turn a pdf into a a word doc?

    Unfortunately, this depends highly on your source PDF document. If you can select the text in Adobe Reader/Acrobat, as in individual letters, there's no reason why it won't work. But if y...

  • Is there anywhere i can get microsoft word free on the internet?

    Microsoft Word is not free but there is a free alternative. Try Open Office, a free alternative to Microsoft Office and is completely compatible with Office programs. The program Writer included...

  • How can I fix this problem with AudioCommander?

    Check this page for details from the company that sells the program. ...

  • How do i repair XP without deleting any of my files or programs?

    some of the previous answers are partially correct with regards to repairing your windows installation but to correctly repair windows without losing any Data proceed as follows if your pc is set i...

  • I want to buy songs to download to my computer and make a cd of all my favorites. Which's best? Itunes, or..?

    i think itunes would be the best. the other things are just lame. =]

    ...
    • 　

    Categories--Copyright/IP Policy--Contact Webmaster