Home› General Chat
If you need urgent support, call 999 or go to your nearest A&E. To contact our Crisis Messenger (open 24/7) text THEMIX to 85258.
Options

how do i

Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
in General Chat
copy and paste columns in excel that have been calulated with equations?

Comments

  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    its been a while since i have done it, but im sure its >edit then >special paste. Im sure it then gives you an option to copy the formulas.
  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    Think so - because I'm pretty certain special paste can be used to move tables into other documents as well (though that might be export)
  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    Calvin wrote: »
    its been a while since i have done it, but im sure its >edit then >special paste. Im sure it then gives you an option to copy the formulas.

    :yes:

    Except if you just want the results of the equation then select "values" and not formula...
  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    Problem sorted :D
  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    thanks.

    how can i multiply a column by something?
  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    Each cell in a column or the column total?
  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    each cell
  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    =(select first cell)*(enter number you want to multiply by)

    You then copy (or drag) the forumla down the coloumn so that it applies to all cells you want to multiply...
  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    ta
Sign In or Register to comment.