98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking cells
Linking cells
Resolved · Low Priority · Version 2003
Wed 21 May 2008, 16:28Delegate Nasif said...
Nasif has attended:
Excel Advanced course
Linking cells
I am trying to link cells(with formula) in the opposite direction. for eg. If I have a range of formula which are horizontal across a row how do I link to those forumla horizontally down a column without referring to each cell manually? Thanks
Wed 28 May 2008, 16:27Trainer Amanda said...
RE: Linking cells
Hi Nasif
Thank you for your question; and welcome to the forum.
Can you please explain what the formula you are creating is doing, e.g. is the formula adding the cell range which is in the row?
Thank you in advance
Amanda
Wed 28 May 2008, 16:33Delegate Nasif said...
RE: Linking cells
Hi Amanda
Its simply linking cells in a spreadsheet.(trying to link cells which are displaynig horizontal data to display it vertically down a column)
For eg. if you have the months of the year across a row and data underneath each month, is there a way of linking the data down a column, so I could drag the column down and it would pick up the data across the row?
I have used the transpose function in the paste tools but am unable to link the actual cells. What I then have to do is reference each cell which can take alot of time.
Hope this makes sense.
Thu 29 May 2008, 10:39Trainer Amanda said...
RE: Linking cells
Hi Nasif
Thank you for clarifying this for me.
This is a tricky one - I will need to do some further research to find out if this is possible. I'll look into and let you know if I find anything that will help.
Amanda
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 tip:Checking formulas with multiple operatorsWhen dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right: |
