Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2010
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel 2010
Resolved · Urgent Priority · Version 2010
Reply Thu 26 Jan 2012, 18:39Delegate Sylvia said...
Sylvia has attended:
Powerpoint Intermediate Advanced course
Excel Intermediate course
Excel 2010
I am trying to copy some data from one worksheet to another. On the first worksheet the data has been entered in one column ( vertical). I need to copy the data so that it is in rows ( horizontal). I am trying to set up the = function, and go to the corresponding cell in the worksheet. It works. I now have : a formula : ='EROFL Net Performance'!F14. I would like to copy this through horizontally, but so that the next cell is ='EROFL Net Performance'!F15 . This doesn't work, because I get ='EROFL Net Performance'!G15. What should I do to make sure that I get one cell down, but always F instead of moving over by one column? ( G, E, etc...?). I hope this is clear...? Thank you very much.
Best regards. Sylvie
For upcoming training course dates see: Pricing & availability
RE: Excel 2010
Hi Sylvia, thanks for your query. What you are trying to do is called transposition and there is a function to do that for you in Excel:
http://www.dummies.com/how-to/content/moving-excel-2010-data-from-rows-to-columns-and-ba.html
Hope this helps,
Anthony
Reply Fri 27 Jan 2012, 18:43Delegate Sylvia said...
RE: Excel 2010
Anthony, thank you for your reply. The problem is that it works for values, but I am trying to copy the formula as well, and it automatically tranposes the formulas. Any tip to prevent that?
Thank you .
Sylvie
Reply Mon 30 Jan 2012, 12:34Delegate Barry said...
RE: Excel 2010
Hi all, you could try; copy what you want, Paste Special - Formulas in to a new worksheet or workbook, then paste again using Values. If that don't work try them the other way round. Let me know if either works for you.
Baz
|